34-Excel-Hotkey.pdf - Microsoft Excel Keyboard Keys General Description New file Open file Save file Move between open workbooks Close file Save as

34-Excel-Hotkey.pdf - Microsoft Excel Keyboard Keys General...

This preview shows page 1 - 2 out of 2 pages.

Microsoft Excel Keyboard Keys 1Microsoft Excel Keyboard Keys General Description Shortcut Key Description Shortcut Key New file Ctrl + N Select whole spreadsheet Ctrl + A Open file Ctrl + O, Ctrl + F12 Select column Ctrl + Space Save file Ctrl + S Select row Shift + Space Move between open workbooks Ctrl + F6 Undo last action Ctrl + Z Close file Ctrl + F4 Redo last action Ctrl + Y Save as F12 Start a formula = (Equals Sign), eg. =SUM(A1+A2) Display the print menu Ctrl + P Exit Excel Alt + F4 Enter Formula as an Array Ctrl + Shift + Enter Close File Ctrl + W Calc Entire File F9 Active Sheet Only Shift + F9 Show Context Menu (right click) F10 Navigating Description Shortcut Key Description Shortcut Key Move to next cell in row Tab Move to end of section Ctrl + Arrow Key Move to previous cell in row Shift + Tab Select section Ctrl + Shift + Arrow Key Move between open workbooks Ctrl + Tab, Ctrl + F6 Go To Previous Cells F5, Ctrl + G Move between open applications Alt + Tab Select All Commented Cells Ctrl + Shift + O Move to cell below Tab Move to cell to right Enter Up one screen Page Up Move to cell above Shift + Tab Move to cell to left Shift + Enter Down one screen Page Down Select current and next worksheet Ctrl + Shift + Page Down Move to next worksheet Ctrl + Page Down Select current and previous worksheet Ctrl + Shift + Page Up Move to previous worksheet Ctrl + Page Up Go to first cell in data region Ctrl + Home Go to last cell in data region Ctrl + End Move Clockwise to next Corner (within selection) Ctrl + . Formatting Text/Cells In Worksheet Description Shortcut Key Description Shortcut Key Bold toggle for selection Ctrl + B Unhide Columns Ctrl + Shift + 0 Italic toggle for selection Ctrl + I Hide Rows Ctrl + 9 Underline toggle for selection Ctrl + U Unhide Rows
Background image
Image of page 2

You've reached the end of your free preview.

Want to read both pages?

  • Spring '18
  • Lu
  • Ctrl, Computer keys

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture