Microsoft Office Tutorials and References
In Depth Information
Hiding Rows and Columns
The commands in the Zoom group on the View tab allow you to change the on-screen size
of the worksheet contents. Click Zoom to open a dialog box where you can choose from
five predeined magnification levels or enter a custom value. At zoom levels of 39 percent
or less, gridlines are automatically hidden.
INSIDE OUT Choose the right Zoom tools for maximum flexibility
Although you can open the Zoom dialog box and pick a magnification level, we
recommend using the Zoom slider, on the status bar in the lower right corner of the program
window, instead. Drag the slider left or right to make the window magnification larger
or smaller in 6 percent increments (these steps are much iner when you move below
100%). Each click of the plus or minus button on either side of the slider increases
the window magnification to the next multiple of 10 and then increases in 10 percent
increments. To zoom up and down in 15 percent increments, hold down the Ctrl key as
you roll the mouse wheel.
For any worksheet, the zoom scale ranges from a low of 10 percent (a bird’s-eye view)
to a high of 400 percent (an extreme close-up). By contrast, the Zoom dialog box offers
only a single larger-than-normal setting (200%) and three evenly spaced smaller levels
(25, 50, and 75 percent). Double-click the current Zoom percentage (to the left of the
slider) to open the Zoom dialog box. The fastest way to return to normal magnification
at any time is to click the 100% command in the Show group on the View tab.
The Zoom To Selection option lets you change the worksheet’s magnification so that it
shows the entire contents of the current selection, increasing or decreasing the width and
height of the worksheet window as needed. This setting is saved as a custom magnification
level; it applies to the current worksheet only and is not dynamic. If you change the size of
the worksheet window or hide user interface elements, the magnification level remains the
same percentage; after you make this type of change, you can resize the window manually
by clicking the Zoom To Selection command again.
Hiding Rows and Columns
Some worksheet data is required for calculations but isn’t necessary for display purposes
and might even be distracting in its raw form. For those occasions, you can hide one or
more rows or columns. Click any cell within the row or column you want to hide (or click
the heading to select the entire row or column). Then, in the Cells group on the Home tab,
click Format, click Hide & Unhide, and then click Hide Rows or Hide Columns. As an
alternative, you can right-click any heading and click Hide. You can also hide a column by
dragging the right edge of the column heading to the left until its width is 0; to hide a row, drag
the bottom edge of the row heading up until it disappears.