94432_47510_ms_excel_short_cut_keys (1)

Please download to get full document.

View again

of 23
8 views
PDF
All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
Document Description
MS Excel Shortcut Keys By Gaurav Sharma Keys for General Use Working with Spreadsheet Files To perform this action... To create a new spreadsheet file To open a spreadsheet file To close a spreadsheet file To save a spreadsheet file To quit Excel Working with Workbook Windows To perform this action... To close the selected workbook window To restore the window size of the selected workbook window To switch to the next pane in a worksheet that has been split (by using the Split command on the W
Document Share
Documents Related
Document Tags
Document Transcript
  MS Excel Shortcut KeysBy Gaurav Sharma Keys for General UseWorking with Spreadsheet Files To perform this action...Press...To create a new spreadsheet file CTRL+N To open a spreadsheet file CTRL+O To close a spreadsheet file CTRL+W To save a spreadsheet file CTRL+S To quit Excel ALT+F4 Working with Workbook Windows To perform this action...Press...To close the selected workbookwindow CTRL+F4 or  CTRL+W To restore the window size of theselected workbook window CTRL+F5 To switch to the next pane in aworksheet that has been split (by usingthe Split command on the Windowmenu) F6 To switch to the previous pane in aworksheet that has been split SHIFT+F6 To switch to the next workbook windowwhen more than one workbook windowis open CTRL+F6 To switch to the previous workbookwindow CTRL+SHIFT+F6 To minimize a workbook window to anicon CTRL+F9 To maximize or restore the selectedworkbook window CTRL+F10 Working with Menus and Toolbars 1  MS Excel Shortcut KeysBy Gaurav Sharma To perform this action...Press...To show or hide the Standard toolbar  CTRL+7 Working with Worksheets To perform this action...Press...To insert a new worksheet SHIFT+F11 or  ALT+SHIFT+F1 To move to the next worksheet in theworkbook CTRL+PAGE DOWN To move to the previous worksheet inthe workbook CTRL+PAGE UP To select the current and nextworksheet SHIFT+CTRL+PAGE DOWN (Tocancel selection of multiple sheets,press CTRL+PAGE DOWN ; or to selecta different sheet, press CTRL+PAGEUP )To select the current and previousworksheet SHIFT+CTRL+PAGE UP To rename the current worksheet ALT+O, H, R ( Format menu, Sheet submenu, Rename command)To move or copy the current worksheet ALT+E, M ( Edit menu, Move or CopySheet command)To delete the current worksheet ALT+E, L ( Edit menu, Delete Sheet command)To alternate between displaying cellvalues and displaying cell formulas CTRL+` (SINGLE LEFT QUOTATIONMARK) To calculate the active worksheet SHIFT+F9 To calculate all sheets in all openworkbooks F9 Working with Speech, E-Mail, Macros, and Other LanguagesUsing Speech Recognition and Text-to-Speech To perform this action...Press...To switch between command modeand dictation mode CTRL To stop reading when text is being ESC 2  MS Excel Shortcut KeysBy Gaurav Sharma read aloud Sending E-Mail Messages To perform this action...Press...With cell A1 selected, to move to theIntroduction box in the e-mail messageheader  SHIFT+TAB (In the message header,moves to the Subject, Bcc (if displayed), Cc, To, and From (if displayed) boxes, then to the addressbook for the Bcc, Cc, To, and Fromboxes, and then to cell A1.)To send the e-mail message ALT+S To open the Address Book CTRL+SHIFT+B To open the Options menu for accessto the Options, Bcc Field, and FromField commands ALT+O To open the Outlook Message Optionsdialog box (Options menu, Optionscommand) ALT+P To check the names in the To, Cc, andBcc boxes against the Address Book ALT+K To open the Address Book for the Tobox ALT+PERIOD To open the Address Book for the Ccbox ALT+C To open the Address Book for the Bccbox if the Bcc box is displayed ALT+B To go to the Subject box ALT+J To create a message flag CTRL+SHIFT+G To add interactivity to the range or sheet being sent ALT+ANote: To use keys to send e-mail messages, you must configure Microsoft Outlook as your default e-mailprogram. Most of the keystrokes above do not work with Outlook Express. Working with Macros To perform this action...Press...To display the Macro dialog box ALT+F8 3  MS Excel Shortcut KeysBy Gaurav Sharma To display the Visual Basic Editor  ALT+F11 To insert a Microsoft Excel 4.0 macrosheet CTRL+F11 Working with Multiple National Languages To perform this action...Press...To switch to right-to-left paragraphdirection (the text must contain onlyneutral characters) CTRL+RIGHT SHIFT To switch to left-to-right paragraphdirection (the text must contain onlyneutral characters) CTRL+LEFT SHIFT To move the pointer into the phoneticguides in Japanese text for whichyou've displayed phonetic guides ALT+SHIFT+UP ARROW To move the pointer from the phoneticguides back to the parent string of characters ALT+SHIFT+DOWN ARROW To enter a unicode character  NUM LOCK, ALT+numeric padnumbers To convert the hexadecimal code for aunicode character to the character, or to convert a unicode character to itshexadecimal code ALT+X (Press immediately after typingthe hexadecimal code or the unicodecharacter) Miscellaneous To perform this action...Press...To cancel an action ESC To undo an action CTRL+Z To redo an action F4 or  CTRL+Y Keys for Moving and Scrolling on Worksheets To perform this action...Press...To move one cell up, down, left, or  Arrow keys 4
We Need Your Support
Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

Thanks to everyone for your continued support.

No, Thanks