File Menu Commands: Common Excel 2010 Hot Keys

To activate the Excel 2010 hot keys, you press the Alt key before typing the mnemonic letters for a particular task. The mnemonic letter is F (for File) for the commands on the File menu in the new Backstage View. All you have to remember, then, is the second letter in the sequence; unfortunately, not all of the second letters are intuitive, as you can see in the following table.




































































Hot Key Excel Ribbon Command Function
Alt+FSFile Menu→SaveSaves changes to a workbook. When you first select this command for a new workbook, Excel displays the Save As dialog box
Alt+FAFile Menu→Save AsDisplay 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 Menu→OpenDisplays 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 Menu→CloseCloses the current workbook without exiting Excel
Alt+FIFile Menu→InfoDisplays 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 Menu→RecentDisplays a list of the last 20 workbook files most recently opened for editing in Excel
Alt+FNFile Menu→NewDisplays the Available Templates panel in the Backstage View box where you can open a blank workbook or one from a template
Alt+FPFile Menu→PrintDisplays 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+FDFile Menu→Save & SendDisplays the Save & Send panel in the Backstage View where you can send the current workbook as an e-mail attachment, save it in a new file format, or save it online to your company’s SharePoint site or your own Windows Live SkyDrive
Alt+FHFile Menu→HelpDisplays 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+FTFile Menu→OptionsDisplays 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 Menu→Exit ExcelQuits the Excel program and closes all open workbooks after prompting you to save them







dummies

Source:http://www.dummies.com/how-to/content/file-menu-commands-common-excel-2010-hot-keys.html

No comments:

Post a Comment