Microsoft Office Tutorials and References
In Depth Information
Hiding User Interface Elements
Hiding User Interface Elements
Excel has various options that enable you to hide elements in order to customize your
workspace. In some cases, you can change the display options in more than one place. For each of the
elements listed in this section, I show you the easiest Hide method possible.
From the Ribbon
Change the following settings by using controls on the Ribbon:
h Ruler: When your worksheet is in Page Layout view, use View
Ruler to toggle
the display of the rulers at the top and left side of the window. Turning off the rulers
gives you slightly more screen real estate.
h Gridlines: When View
Gridlines is not checked, cell gridlines are not displayed. If
you format ranges by using cell borders, turning off the gridlines makes the borders more
h Formula Bar: The Formula bar, located just below the Ribbon, displays the contents of
the selected cell. To see more of your worksheet, turn it off by choosing View
Formula Bar.
h Row & Column Headers: If this setting is turned off (by choosing View
Headings), you don’t see the row (numbers) and column (letters) headers.
From the keyboard
Modify the items below by using the keyboard:
h The Ribbon: Press Ctrl+F1 to turn the Ribbon display off or on. The tabs remain visible,
and the Ribbon appears (temporarily) when you click a tab.
h Outline symbols: This option is relevant only if you added a worksheet outline (by using
the Data
Group command). If you don’t like seeing the Outline symbols, you
can turn them off. Or, you can press Ctrl+8 to toggle the display of the Outline symbols.
From the Excel Options dialog box
You change the following settings from the Advanced tab in the Excel Options dialog box. To
display this dialog box, choose File
Options and then click the Advanced tab. Scroll down, and
you see three groups of options, as shown in Figure 17-1.
Search JabSto ::

Custom Search