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.

2 comments:

Anonymous said...

IЎЇm delighted that I have observed this weblog. Lastly something not a junk, which we go through incredibly frequently. The website is lovingly serviced and saved as much as date. So it should be, thanks for sharing this with us.
My partner and I really enjoyed studying this blog submit, I used to be just itching to know do you trade featured posts? I am always trying to find someone to make trades with and merely thought I might ask.
You ought to really think about engaged on developing this blog into a serious authority in this market. You evidently have a grasp deal with of the matters everyone seems to be trying to find on this website anyways and you might certainly even earn a buck or two off of some advertisements. I might discover following latest topics and elevating the amount of write ups you place up and I assure you’d start seeing some amazing targeted visitors in the close to future. Just a thought, good luck in whatever you do!
Hey – good weblog, simply wanting around some blogs, seems a fairly good platform You Are using. I’m currently utilizing Drupal for just a few of my websites but looking to change considered one of them over to a platform very much the identical to yours as a trial run. Something specifically you'd recommend about it?
Certainly one of the challenges which people starting a new on-line firm face is that of acquiring guests to their net site.

Anonymous said...

Hi there! Someone in my Facebook group shared this site with us so
I came to take a look. I'm definitely enjoying the information. I'm bookmarking and will be tweeting this to my followers!
Terrific blog and brilliant design and style.

Also visit my website - children clothing distributor