Monday, August 14, 2006

The View Menu

View Menu

  • Normal - Displays the worksheet in normal view from Page break review(has no effect if the worksheet is already in normal view)
  • Page Break Review - Displays the worksheet in Page break review from normal view (has no effect if the worksheet is already in page break review)
  • Task Pane - Shows or hides the task pane. If it is shown, a tick mark would be displayed to the left. - CTRL+F1
  • Toolbars - Shows the toolbars available in excel. If a toolbar is shown, a tick mark would be displayed to the left
  • Formula Bar - Shows or hides the formula bar. If it is shown, a tick mark would be displayed to the left.
  • Status Bar - Shows or hides the status bar. If it is shown, a tick mark would be displayed to the left.
  • Header and Footer - Displays the header and footer to be printed (Triggers the Page Setup dialog box)
  • Comments - Displays all the comments in the worksheet and also triggers the reviewing toolbar
  • Custom Views - Displays the custom views dialog
    • Show - Shows all the custome views available
    • Close - Closes the dialog box
    • Add - Adds the present view to the custom views coolection
      • Name - Name for the custom view
      • Print Settings - If this box is checked, then print settings would be included in the custom view.
      • Hidden rows,columns and filter settings - If this box is checked, then hidden rows, columns and filter settings would be included in the custom view
    • Delete - Deletes the selected custom views
  • Full Screen - Removes all the toolbars except the worksheet menu bar so as to give you more space with work with
  • Zoom - Zooms the worksheet to the specified size(anything between 10 to 400)
    • Fit Selection - Zooms the selected area to a particular size so as to cover the entire screen
    • Custom - Zooms the worksheet to the value of your choice
Among the above, Task pane, Formula Bar, Status Bar,Comments, Full Screen are toggle buttons.

A TOGGLE BUTTON is just like a SWITCH turning ON or OFF. If you press it once, it would turn on a feature and pressing it again would turn the feature off. When the feature is on, then a tick mark is displayed to the left of the toggle button in Excel

Normally the task pane would show up whenever Microsoft Excel is opened. To turn off task pane, go to Tools->Options->View and then under the Show label, uncheck the Startup Task Pane.

If a box is ticked, then it is said to be checked. If it is not, then it is set to be unchecked. Such a box is called a check box and it may be checked or unchecked by clicking it.

0 comments: