Tuesday, August 08, 2006

The File Menu


  • New->Creates a new file->Ctrl+N
  • Open->Opens a new file->Ctrl+O
  • Close->Closes the active file->Ctrl+W(Hold down shift and then click file to close all open files)
  • Save->Saves the active file->Ctrl+S(This action only saves the active file, not all open files)
  • Save As->Saves the file in the required format(You could use this option to save files in any previous format or a lotus file or a CSV file or any other format you want.The default option is to save the workbook as Microsoft Excel file.Remember if you use this option you may lose certain features of Excel if you save in an another format)
  • Save As Web Page->Saves the file as webpage(If you have used buil-in functions,links to other workbooks,pivot tables then they may not work in webpage.The file is saved as a webpage with an embedded spreadsheet)
  • Save Workspace->Saves all open files under one name(If you have 4 open files and you would be always working with the 4 files you may save them as workspace.Whenever you open the workspace,all the 4 files are opened)
  • File Search->Performs a file search operation.Searches text within files
  • Web Page Preview->Previews how your excel file would look as a webpage.Shows only static text and formatting.
  • Page Setup->Opens the Page Setup dialog box used for printing.
  • Print Area
    • Set Print Area->Sets the print area for the selected range of cells. By default, excel sets the print area beginning from the first cell to the last cell that have content in it.
    • Clear Print Area->Clears the print area already set(Mostly by selecting the set print area option)
  • Print Preview->Previews how the document would be printed.
  • Print->Opens the Print Dialog Box->Ctrl+P
  • Send To(Relates to Microsoft Outlook,Outlook Express)
    • Mail Recipient->Sends the worksheet content as an e-mail
    • Mail Recipient(for Review)->Emails the workbook for reviewing(the workbook must be shared to use this option)
    • Mail Recipient(as Attachment)->Emails the entire workbook as an attachment
    • Routing Recipient->Emails the workbook from within Excel instead of Microsoft Outlook
    • Exchange Foler->Places the workbook in any folder of your default mail client(If you use Microsoft Outlook,you may send a workbook directly to inbox)
    • Online Meeting Participant->Shows you online meeting status and more scheduled by NetMeeting
    • Recipient using Internet Fax Service->Faxes you workbook
  • Properties->Shows the properties of the active file
  • Recently Opened files->Shows the list of recently opened files(1 to 9 as in Tools)
  • Exit-Quits Microsoft Excel

No comments: