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.



No comments:

Post a Comment