XL_Shortcut_keys - Function keys in Microsoft Excel...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Function keys in Microsoft Excel Function Key SHIFT CTRL ALT CTRL+SHIFT ALT+SHIFT F1 What's This? Insert a chart sheet F2 Edit the active cell Edit a cell comment Save As command Save command F3 Define a name F4 Repeat the last action Close the window Exit F5 Go To Display the Find dialog box Restore the window size F6 Move to the next pane Move to the previous pane F7 Spelling command Move the window F8 Extend a selection Add to the selection Resize the window F9 Minimize the workbook F10 F11 Create a chart Insert a new worksheet F12 Save As command Save command Open command Print command Display Help or the Office Assistant Insert a new worksheet Paste a name into a formula Paste a function into a formula Create names by using row and column labels Repeat the last Find (Find Next) Move to the next workbook window Move to the previous workbook window Display the Macro dialog box Calculate all sheets in all open workbooks Calculate the active worksheet Make the menu bar active Display a shortcut menu (right click) Maximize or restore the workbook window Insert a Microsoft Excel 4.0 macro sheet Display Visual Basic Editor
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Enter data by using shortcut keys To Press Complete a cell entry ENTER Cancel a cell entry ESC Repeat the last action F4 or CTRL+Y Start a new line in the same cell ALT+ENTER Delete the character to the left of the insertion point, or delete the selection BACKSPACE Delete the character to the right of the insertion point, or delete the selection DELETE Delete text to the end of the line CTRL+DELETE Move one character up, down, left, or right Arrow keys Move to the beginning of the line HOME Edit a cell comment SHIFT+F2 Create names from row and column labels CTRL+SHIFT+F3 Fill down CTRL+D Fill to the right CTRL+R Fill the selected cell range with the current entry CTRL+ENTER Complete a cell entry and move down in the selection ENTER Complete a cell entry and move up in the selection SHIFT+ENTER Complete a cell entry and move to the right in the selection TAB Complete a cell entry and move to the left in the selection SHIFT+TAB Work in cells or the formula bar by using shortcut keys To Press Start a formula = (EQUAL SIGN) Cancel an entry in the cell or formula bar ESC Edit the active cell F2 BACKSPACE Paste a name into a formula F3 Define a name CTRL+F3 Calculate all sheets in all open workbooks F9 Calculate the active worksheet SHIFT+F9 Insert the AutoSum formula ALT+= (EQUAL SIGN) Enter the date CTRL+; (SEMICOLON) Enter the time CTRL+SHIFT+: (COLON) Insert a hyperlink CTRL+K Complete a cell entry ENTER CTRL+SHIFT+" (QUOTATION MARK) Alternate between displaying cell values and displaying cell formulas CTRL+` (SINGLE LEFT QUOTATION MARK) CTRL+' (APOSTROPHE) Enter a formula as an array formula CTRL+SHIFT+ENTER Display the Formula Palette after you type a valid function name in a formula CTRL+A CTRL+SHIFT+A Display the AutoComplete list ALT+DOWN ARROW Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit the cell contents
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 8

XL_Shortcut_keys - Function keys in Microsoft Excel...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online