Excel For Mac Selected Cells Turn Grey

After installing Kutools for Excel, please do as below: Select a range you want to display only, and click Kutools > Show/Hide > Set Scroll Area. https://cenxiirasi.weebly.com/blog/tube-buddy-download-for-mac

Apply or remove a cell shading in Excel for Mac Select the cells that you want to fill.. Figure B Figure B In the Page Break Preview view, the unused area will be greyed out.. ) Next, press Ctrl Shift Down Arrow to select every row between the selected row and the bottom of the sheet.. See screenshot: If you want to go back to normal view, just click Normal under View tab. Click

Press Ctrl Shift Right Arrow and then choose Column from the Format menu instead of Row.. Then, choose Row from the Format menu and select Hide Repeat this process to hide unused columns, only select the column header in the first empty column.. I cannot highlight all the unused rows or column as there seems to be an infinite amount that just keep appearing no matter how many I hide.. You usually hide a column or row to conceal or protect data and formulas But you can also hide unused regions of a sheet to keep users from exploiting unused areas or to help keep them on task by not allowing them to wander.. Figure A To hide unused rows in Excel 2003, select the row beneath the sheet's last used row. HERE

See screenshot: Then only the selection has been displayed only If you want to display all, click Kutools > Show/Hide > Unhide All Ranges.. Grey out unused area by Kutools for Excel With the Page Break Preview, it will show all used cells, but if you want to only display some cells in a specific range, you can use Kutools for Excel Set Scroll Area utility. 773a7aa168 4

By hiding unused rows and columns, you present a sheet that focuses on just the work area.. To be clear, the design of this app goes far beyond how it looks (Select the row header to select the entire row. HERE