Although it’s handy to have 1,048,576 rows and 16,384 columns of space available for analysis in Excel, too much data can be totally overwhelming. So you might want to consider only highlighting only the results of your analysis or some easily digestible summary. One way to make your conclusions easier for your audience is by turning off all those empty, unused cells.
So instead of this with a bunch of empty cells cluttering the screen….
…you can simply hide all the unused rows & columns to get something like this.
How It Works:
1. Start by selecting the first column you want to hide.
2. Press CTRL+Shift+Right Arrow to select all the columns to the end of the sheet (ColumnXFD)
3. Right click in the column header area and select Hide.
4.Select the first row you want to hide.
5. Press CTRL+Shift+Down Arrow to select all rows to the bottom of the sheet. (Row 1,048,576)
6. Right-click in the row header area and Hide them too.