Perform Excel 2010 File Menu Commands with Handy Hot Keys

You activate all of the Excel 2010 hot keys by pressing down the Alt key before you type the various sequences of mnemonic letters. The mnemonic letter for all of the commands on the Excel 2010 File menu in the new Backstage View is F (for File). Therefore, all you have to concentrate on learning in the following table is the second letter in the File menu hot key sequence.


Unfortunately, not all of these second letters are as easy to associate and remember as Alt+F. For example, check out the Info option hot key sequence, Alt+FE, where the second mnemonic letter doesn’t occur anywhere in the option name (either in the word Info or even Information)!









































































Hot KeysExcel Ribbon CommandFunction
Alt+FSFile MenuSaveSaves changes to a workbook. When you first select this command
for a new workbook, Excel displays the Save As dialog box
Alt+FAFile MenuSave AsDisplays the Save As dialog box in the regular worksheet view
where you can modify the filename, location where the file is
saved, and format that the file is saved in
Alt+FOFile MenuOpenDisplays the Open dialog box in the regular worksheet view
where you can select a new Excel workbook to open for editing or
printing
Alt+FCFile MenuCloseCloses the current workbook without exiting Excel
Alt+FEFile MenuInfoDisplays the Information panel in the Backstage View where you
can see a preview of the current worksheet along with statistics
about the workbook as well as protect the workbook, check the file
for compatibility issues, and manage different versions created by
the AutoRecover feature
Alt+FRFile MenuRecentDisplays a list of the last 20 workbook files most recently
opened for editing in Excel
Alt+FNFile MenuNewDisplays the Available Templates panel in the Backstage View
box where you can open a blank workbook or one from a template
Alt+FPFile MenuPrintDisplays the Print panel in the Backstage View where you can
change the print settings before sending the current worksheet,
workbook, or cell selection to the printer
Alt+FHFile MenuShareDisplays the Share panel in the Backstage View where you can
send the current workbook as an e-mail attachment or fax it using
Internet Fax, attach it to an e-mail as a PDF file, save it in a
new file format, or save it online to your company’s
SharePoint site or your own Windows Live SkyDrive
Alt+FLFile MenuHelpDisplays the Support panel in the Backstage View where you get
help using Excel, check for updates to the program, and get
statistics about the version of Excel 2010 you’re
running
Alt+FZFile MenuAdd InsDisplays a pop-up menu in the Backstage View with menus for
common commands for automatically installed add-in programs such as
the Acrobat PDF Maker add-in (on the Save As and Send Add-Ins
submenus) and the Microsoft ShareView add-in (on the Share
submenu)
Alt+FIFile MenuOptionsDisplays the Excel Options dialog box in the regular worksheet
view where you can change default program settings, modify the
buttons on the Quick Access toolbar, and customize the Excel
Ribbon
Alt+FXFile MenuExit ExcelQuits the Excel program and closes all open workbooks after
prompting you to save them



dummies

Source:http://www.dummies.com/how-to/content/perform-excel-2010-file-menu-commands-with-handy-h.html

No comments:

Post a Comment