0.pdf - Excel Shortcuts Cheat Sheet F1 Displays the Office Assistant or(Help > Microsoft Excel Help F2 Edits the active cell putting the cursor at the

0.pdf - Excel Shortcuts Cheat Sheet F1 Displays the Office...

This preview shows page 1 - 3 out of 5 pages.

1 Excel Shortcuts Cheat Sheet F1 Displays the Office Assistant or (Help > Microsoft Excel Help) F2 Edits the active cell, putting the cursor at the end F3 Displays the (Insert > Name > Paste) dialog box F4 Repeats the last worksheet action (Edit > Repeat) F5 Displays the (Edit > GoTo) dialog box F6 Moves to the next pane in a workbook (if the window is split) F7 Displays the (Tools > Spelling) dialog box F8 Toggles whether to extend a selection with the arrow keys F9 Calculates All the worksheets in All the open workbooks F10 Toggles the activation of the Menu Bar F11 Displays the (Insert > Chart) dialog box that creates a chart (on a chart sheet) using the highlighted range F12 Displays the (File > Save As) dialog box Shift + F2 Inserts or edits a cell comment (Insert > Comment) Shift + F3 Displays the (Insert > Function) dialog box Shift + F4 Repeats the last Find, the same as (Edit > Find Next) Shift + F5 Displays the (Edit > Find) dialog box Shift + F6 Moves to the previous pane in a workbook (if the window is split) Shift + F8 Toggles between switching Add Mode on or off* Shift + F9 Calculates just the active worksheet Shift + F10 Displays the (Shortcut) menu for the selected item Shift + F11 Inserts a new worksheet (before the active sheet) into the active workbook (Insert > Worksheet) Shift + F12 Saves, Displays the (File > Save As) dialog box if a new workbook Ctrl + F1 Closes and reopens the current task pane (ribbon in 2007) Ctrl + F2 Print Preview Ctrl + F3 Displays the (Insert > Name > Define) dialog box Ctrl + F4 Closes the selected workbook window Ctrl + F5 Restores the size of the active workbook or window Ctrl + F6 Moves to the next open workbook or window Ctrl + F7 Activates the Move window command Ctrl + F8 Activates the Resize window command Ctrl + F9 Minimises the size of the active workbook or window Ctrl + F10 Maximises the size of the active workbook or window Ctrl + F12 Displays the (File > Open) dialog box Alt + F1 Creates a chart (on a chart sheet) using the highlighted range Alt + F2 Displays the (File > Save As) dialog box Alt + F4 Closes all the workbooks (saving first) and exits Excel (File > Exit) Alt + F8 Displays the (Tools > Macro > Macros) dialog box
Image of page 1
2 Alt + F11 Toggles between the Visual Basic Editor window and and the Excel window Alt + Ctrl + F9 Calculates All cells on All worksheets in All workbooks Alt + Shift + F1 Inserts a new worksheet (before the active sheet) into the active workbook (Insert > Worksheet) Alt + Shift + F2 Displays the (File > Save As) dialog box Alt + Shift + F4 Closes all the workbooks (saving first) and exits Excel (File > Exit) Alt + Shift + F10 Displays the drop-down menu for the corresponding smart tag Alt + Shift + F11 Activates the Microsoft Script Editor window Ctrl + Shift + F3 Displays the (Insert > Name > Create) dialog box Ctrl + Shift + F6 Moves to the previous open workbook or window Ctrl + Shift + F10 Activates the Menu Bar or Shortcut Characters in 2007 Ctrl + Shift + F12 Displays the (File > Print) dialog box
Image of page 2
Image of page 3

You've reached the end of your free preview.

Want to read all 5 pages?

  • Spring '19
  • mmm
  • Computer keys

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture