#293 Show Only A Few Rows & Columns of Your Spreadsheet

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.

Advertisements

One thought on “#293 Show Only A Few Rows & Columns of Your Spreadsheet

  1. Mike says:

    For some reason the background color of the hidden area is white, not grey… so no difference between the hidden area and the work space… is there a fix to this? Cheers.

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s