Change Workbook Display Options : Workbook « Workbook Worksheet « Microsoft Office Excel 2007 Tutorial






Click the Office button, and then click Excel Options.
Click the Office button, and then click Excel Options.
In the left pane, click Advanced. 
           Click the Display options for this workbook list arrow. 
           Then select the option:
              Show horizontal scroll bar.
              Show vertical scroll bar.
              Show sheet tabs.
              Group dates in the AutoFilter menu.
              For objects, show All or Nothing.
For objects, show All or Nothing.
Click OK.
Click OK.








7.9.Workbook
7.9.1.Hide a WorkbookHide a Workbook
7.9.2.Unhide a WorkbookUnhide a Workbook
7.9.3.Change the color of the sheet tab namesChange the color of the sheet tab names
7.9.4.Change Workbook Display OptionsChange Workbook Display Options
7.9.5.Change New Workbook OptionsChange New Workbook Options