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:
Follow the same basic steps to hide columns. Check
- Select the row header just beneath the used area of your spreadsheet, where you want to start hiding rows.
- Press Ctrl + Shift + Down Arrow. This will highlight everything from
your selected row through the bottom of the worksheet.
- From the worksheet's Format menu, choose Row, then Hide.
appeared in DSS News 06/09/02