XL_Shortcut_keys - Function keys in Microsoft Excel...

Info icon This 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
Image of page 1

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

View Full Document Right 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
Image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern