Datasheet
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 Office ➪ Excel Options. Then click the Advanced tab.
•
Windows in Taskbar: This option is in the Display section of the Advanced tab in the
Excel Options dialog box. When the Show All Windows in the Taskbar option is turned
on, each workbook appears as a separate icon on the Windows taskbar. It’s too much
clutter for my taste, so I keep it turned off.
•
Objects: This setting refers to graphical objects embedded in your sheets (including
charts). You may want to hide these objects if you have many of them and your system
performance is suffering. To hide all objects in the workbook, use the For Objects Show
options, located in the Display Options for This Workbook section of the Advanced tab in
the Excel Options dialog box.
•
Page Breaks: After you print or preview a document, Excel displays dotted line page
breaks in the worksheet. You can turn them off, if you like. Use the Show Page Breaks
check box in the Display Options for This Worksheet section of the Advanced tab in the
Excel Options dialog box.
•
Zero Values: Sometimes, you may prefer to hide all zero cells and show a blank cell
instead. Control this option by using the Show a Zero in Cells That Have Zero Value
check box in the Display Options For This Worksheet section of the Advanced tab in the
Excel Options dialog box.
•
Scroll Bars: You can hide the horizontal and vertical scroll bars for a workbook. Go to
the Display Options for This Workbook section on the Advanced tab of the Excel Options
dialog box, and use the two check boxes labeled Show Horizontal Scroll Bar and Show
Vertical Scroll Bar.
•
Sheet Tabs: To hide the sheet tab, go to the Display Options for This Workbook section
on the Advanced tab of the Excel Options dialog box, and remove the check mark from
the Show Sheet Tabs check box. With no sheet tabs, you can use Ctrl+PgUp and
Ctrl+PgDn to activate a different sheet.
A Setting That Requires a Macro
Turning off the display of one user interface element now requires a macro.
The status bar, at the bottom of the Excel window, displays a variety of information. In pre-
vious versions of Excel, the user could turn the status bar display on or off. Excel 2007
requires a VBA macro to toggle the status bar display:
Sub ToggleStatusBar()
With Application
.DisplayStatusBar = Not .DisplayStatusBar
End With
End Sub
Tip 15: Hiding User Interface Elements
45
Part I
04_137666 ch01.qxp 5/22/07 7:31 PM Page 45