CUSTOMIZING VIEW OPTIONS/ Customizing the Excel Window Display Customizing the Comments View Options Customizing the Objects View Options Customizing the Worksheet View Options

♦Customizing the Excel Window Display

1- From the main menu, choose Tools  →  Options to display the Options dialog box. 
2- Click on the View tab, and select any of the following options from the Show area:Formula bar: Select to show the Formula bar.

 Status bar: Select to show the Status bar.

Windows in Taskbar: Select to list each open Workbook on the Taskbar.

3- Click OK to save the changed settings.

♦ Customizing the Comments View Options

1.       From the main menu, choose Tools   → Options to display the Options dialog box.

2.       Click on the View tab, and select any of the following options from the Comments area:

   

None: Select to hide all comments.

Comment indicator only: Select to indicate comments with red triangles.

Comment & indicator: Select to show the comments and its indicator.

3.       Click OK to save the changed settings.

♦Customizing the Objects View Options

1.       From the main menu, choose Tools  →  Options to display the Options dialog box.

2.       Click on the View tab, and select any of the following options from the Objects area:

Show all: Select to show all objects.

Show placeholder: Select to show a grey box in place of an object.

Hide all: Select to hide all objects.

3.       Click OK to save the changed settings.

♦ Customizing the Worksheet View Options

1.      From the main menu, choose Tools    →       Options to display the Options dialog box.

2.       Click on the View tab, and select any of the following options from the Window options area:

 

 Page breaks: Select to display page breaks.

Formulas: Select to display formulas instead of results in Worksheet cells.

Gridlines: Select to display gridlines.

Gridline color: Change the gridline color by clicking on the down arrow and

selecting a new color.

Row & column headers: Select to show the row and column headers.

Outline symbols: Select to show any outline symbols.

Zero values: Select to show cells containing 0.

Horizontal scroll bar: Select to show the horizontal scroll bars.

Vertical scroll bar: Select to show the vertical scroll bars.

Sheet tabs: Select to show the sheet tabs.

3.       Click OK to save the changed settings.