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+FS | File Menu→Save | Saves changes to a workbook. When you first select this command for a new workbook, Excel displays the Save As dialog box |
Alt+FA | File Menu→Save As | Display 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+FO | File Menu→Open | Displays the Open dialog box in the regular worksheet view where you can select a new Excel workbook to open for editing or printing |
Alt+FC | File Menu→Close | Closes the current workbook without exiting Excel |
Alt+FI | File Menu→Info | Displays 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+FR | File Menu→Recent | Displays a list of the last 20 workbook files most recently opened for editing in Excel |
Alt+FN | File Menu→New | Displays the Available Templates panel in the Backstage View box where you can open a blank workbook or one from a template |
Alt+FP | File Menu→Print | Displays 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+FD | File Menu→Save & Send | Displays 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+FH | File Menu→Help | Displays 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+FT | File Menu→Options | Displays 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+FX | File Menu→Exit Excel | Quits 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