Hide Unused Rows and Columns

Users can get lost navigating the more than 16 million cells in an Excel worksheet. For practical and aesthetic reasons hide the unused rows and columns. Rodney Powell in a posting at beyondtechnology.com explained the steps to "hide" rows:
  1. Select the row header just beneath the used area of your spreadsheet, where you want to start hiding rows.
  2. Press Ctrl + Shift + Down Arrow. This will highlight everything from your selected row through the bottom of the worksheet.
  3. From the worksheet's Format menu, choose Row, then Hide.
Follow the same basic steps to hide columns. Check http://www.beyondtechnology.com/tips003.shtml.

appeared in DSS News 06/09/02