"How To Excel" Mini-Tutorials
by TheExcelAddict.com
"Helping Average Spreadsheet Users Become Local Spreadsheet Experts"

Hiding Unused Rows and Columns


As you may or may not know (or even care), an Excel worksheet contains 16,777,216 cells (65,536 columns x 256 rows). Most Excel worksheets use only a very tiny portion of that area. It may be useful to hide the area that you aren't using to keep from scrolling off the edge of your work area.

Here's how:

  1. Select a cell in a row beneath the work area of your worksheet.
  2. While holding down the CTRL + SHIFT keys press the down arrow on your keyboard. This will select a range of cells from the cell you selected down to the last row of the worksheet (i.e. row 16,556).
  3. Select Format, Row, Hide.
  4. Next, select a cell in a column to the right of the work area of your worksheet.
  5. While holding down the CTRL + SHIFT keys press the right arrow on your keyboard. This will select a range of cells from the cell you selected over to the last column on the far-right side of your worksheet (i.e. Column IV).
  6. Select Format, Column, Hide.
You will notice that the cells outside your work area are grayed out. Be aware that if you use the Select All button (the grey rectangle in the upper-left corner of the worksheet where the row and column headings meet) before adjusting your row heights or column widths, this will unhide the previously hidden rows or columns. To adjust the row heights or column widths without unhiding the other rows and columns, select only the visible row or column headings first.


Why not print (CTRL+P) this tip and share it with your friends and associates?

Get more time-saving tips just like this one delivered to you by email every week in my FREE newsletter "Spreadsheet Tips From An Excel Addict". Subscribe at the www.TheExcelAddict.com/Newsletter.htm.
You'll be amazed how much time you'll save just by learning a few of these tips.

Copyright 2003 All Rights Reserved by Francis Hayes (The Excel Addict)

If you came to this page from my Excel Mini-Tutorials page, click here to close this window,
otherwise click here and you'll find lots more time-saving Excel tutorials like this one.