Office Button in MS Excel 2007

Prem Kumar

 

The same options are available in the MS Excel 2007 office button, which are found in the MS Word and MS PowerPoint 2007 office buttons.




New - Ctrl+O :- This option is used to add a new workbook file.

Open - Ctrl+O :- This option is used to open a workbook file that we saved earlier.

Save - Ctrl+S :- By this option we can save the current data in the current worksheet or workbook file.

Save As - F12 :- This option is used to save a new separate workbook file.

Print :- It has the following three options -

Ctrl+P :- It is used to print the worksheet, using this option you can select the printer, set the page range and you can also set how many copies to print.

Quick Print :- This option is used to print directly on the print settings set last.

Print Preview - Ctrl+F2 :- Using this option, we can see what the matter we are printing will look like when it is printed.

Encrypt Document (Prepare) :- With this option we put a password on the file, after which the presentation file will open only with the same password.

Send :- Using this option, we can send Excel files via e-mail or using Internet fax.

Close - Ctrl+W :- With this option we only close the workbook file, the program remains open.

Exit Excel- Alt+F4 :- With this option we close the program.







Comments

Post a Comment

Popular posts from this blog

Formulas Tab in MS Excel 2007

Prem Kumar
Image
  Formulas Tab Function Library Group Insert Functions  With the help of this option, we can edit the function (formula) of the current cell and insert the new function in the new cell. Apart from this, you can take offline help    related to the function.                Auto Sum With the help of this option, you can automatically add a range in the sheet in which the number data is written.                Recently Used            In this option, functions are found which have been used recently.                Financial            Financial options are available in this option. Like - PMT, PV, FV etc.                Logical            Logical functions are available in this option...
Read more

Home Tab in MS Excel 2007

Prem Kumar
Image
The main options are kept in the Home Tab of MS Excel 2007 which are more needed. Clipboard Group Cut (Ctrl+X) This option is used to cut selected content and save it in the clipboard. Copy (Copy+C) This option is used to copy selected content and save it to the clipboard. Paste (Ctrl+V) This option is used to access cut or copied content in the new range in the same sheet.  Format Painter  Through this option, we can copy the format on any cell and apply it on the new cell. Font Group Font  This option is used to change the font of the active cell. Font Size  This option is used to change the font size of the active cell. Increase Font Size  This option is used to increase the size of the font. Decrease Font Size    This option is used to reduce the font size. Bold (Ctrl+B) It is used to make the text of the active cell appear thick or dark.  Italic (Ctrl+I) It is used to make the text of the active cell appear italic. Underline (Ctrl+U) It is us...
Read more