Hiding rows and columns does not just have to be for concealing data or
formulas. If your spreadsheet only uses a small area of the 16,777,216
available cells in an Excel worksheet, maybe it would be nice to hide
some of that vast unused region to keep users from scrolling off the
edge of your working area.
Here are the simple steps to accomplish this task:
- 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.
Follow the same basic steps to hide columns. The difference will be
that you should begin by selecting a column header in the first empty
column to the right of your used area, then press
Ctrl + Shift + Right Arrow.
Finally, from the worksheet's Format menu, choose
Column, then Hide.
Know an even better way?
Let me know.
|
![Microsoft Office : Excel - Visual Basic for Applications [ VBA ] Software](img/1ptrans.gif){kind=small}
