-->

MS Excel Shortcuts Cheat Sheet: Full List of Keyboard Shortcuts for Windows Laptops or PCs

Excel Shortcuts Cheat Sheet

Excel Shortcuts Cheat Sheet

Want to increase speed in MS Excel? Do you know Microsoft Excel Shortcuts make your professional life easy! Here's a complete cheat sheet of the most important shortcuts for Microsoft Excel.

List of basic excel shortcut keys:

  1. Arrow Keys Moves to the next cell in that direction
  2. Backspace -  Deletes the selection or one character to the left Shift + Delete Cuts the selection to the clipboard
  3. Tab-  Moves from left to right within a selection
  4. Tab Enters the contents of the active cell and moves one cell to the right
  5. Tab Moves to the next cell on the right (or unprotected cell)
  6. Home Moves to the first column in the current row
  7. Page Down Moves to the next screen of rows down
  8. Enter - Moves from top to bottom within a selection
  9. Enter Enters the contents of the active cell and moves to the cell below (by default)
  10. Enter Moves to the cell directly below
  11. Delete-  Deletes the selection or one character to the right
  12. Page Up Moves to the previous screen of rows up

Excel Alt Shortcut Keys

  1. Alt + ' Displays the Style dialog box
  2. Alt +; Selects the visible cells in the current selection
  3. Alt + = Enters the SUM() function (AutoSum) to sum the adjacent block of cells
  4. Alt + 0128 Enters the euro symbol (€) (using Number keypad)
  5. Alt + 0162 Enters the cent symbol (¢) (using Number keypad)
  6. Alt + 0163 Enters the pound sign symbol (£) (using Number keypad)
  7. Alt + Ctrl + F9 Calculates All cells on All worksheets in All workbooks
  8. Alt + Ctrl + Left Arrow Moves to the left between non-adjacent cells in a selection
  9. Alt + Ctrl + Right Arrow Moves to the right between non-adjacent cells in a selection
  10. Alt + Down Arrow Displays the Pick From List drop-down list Esc Cancels the cell entry and restores the original contents
  11. Alt + Enter Enters a new line (or carriage return) into a cell
  12. Alt + F1 Creates a chart (on a chart sheet) using the highlighted range
  13. Alt + F11 Toggles between the Visual Basic Editor window and the Excel window
  14. Alt + F2 Displays the (File > Save As) dialog box
  15. Alt + F4 Closes all the workbooks (saving first) and exits Excel (File > Exit)
  16. Alt + F8 Displays the (Tools > Macro >Macros) dialog box
  17. Alt + Page Down Moves you one screen of columns to the right
  18. Alt + Page Up Moves you one screen of columns to the left
  19. Alt + Shift + F1 Inserts a new worksheet (before the active sheet) into the active workbook (Insert > Worksheet)
  20. Alt + Shift + F10 Displays the drop-down menu for the corresponding smart tag
  21. Alt + Shift + F11 Activates the Microsoft Script Editor window
  22. Alt + Shift + F2 Displays the (File > Save As) dialog box
  23. Alt + Shift + F4 Closes all the workbooks (saving first) and exits Excel (File > Exit)
  24. Alt + Shift + Tab Moves to the previous application open on your computer
  25. Alt + Tab Moves to the next application open on your computer

Excel Ctrl Shortcut Keys

  1. Ctrl + ' Enters the contents from the cell directly above into the active cell
  2. Ctrl + (# or ~) Applies the Custom Date format "dd-mmm-yy" to the selection
  3. Ctrl + * Selects the current region (using the * on the number keyboard)
  4. Ctrl + . Moves clockwise to the next corner within a selection
  5. Ctrl + / Selects the array containing the active cell ??
  6. Ctrl +; Enters the current date into the active cell
  7. Ctrl + [ Selects all the cells that are directly referred to by the formula in the active cell (precedents)
  8. Ctrl + \ Selects the cells in a selected row that do not match the value in the active cell
  9. Ctrl + ] Selects all the cells that directly refer to the active cell (dependents)
  10. Ctrl + ` Toggles between the value layer and the formula layer
  11. Ctrl + 0 Hides the columns in the current selection
  12. Ctrl + 1 Displays the formatting dialog box
  13. Ctrl + 2 Toggles bold on the current selection
  14. Ctrl + 3 Toggles italics on the current selection
  15. Ctrl + 4 Toggles underlining on the current selection
  16. Ctrl + 5 Toggles the strikethrough of text on the current selection
  17. Ctrl + 6 Toggles between hiding, displaying
  18. Ctrl + 8 Toggles the display of Outline symbols on the active worksheet
  19. Ctrl + 9 Hides the rows in the current selection (Format > Row > Hide)
  20. Ctrl + A Displays formula palette is given a function name or selects the whole worksheet or current date
  21. Ctrl + B Toggles bold on the current selection
  22. Ctrl + C Copies the current selection to the clipboard
  23. Ctrl + D Copies the first cell in the selection downwards
  24. Ctrl + Delete Deletes text to the end of the line Ctrl + - Displays the Delete dialog box
  25. Ctrl + Down Arrow Moves to the last row in the current region
  26. Ctrl + End Moves to the last used cell on the active worksheet*
  27. Ctrl + F Displays the Find dialog box
  28. Ctrl + F1 Closes and reopens the current task pane (ribbon in 2007)
  29. Ctrl + F10 Maximises the size of the active workbook or window
  30. Ctrl + F12 Displays the (File > Open) dialog box
  31. Ctrl + F2 Print Preview
  32. Ctrl + F3 Displays the (Insert > Name > Define) dialog box
  33. Ctrl + F4 Closes the selected workbook window
  34. Ctrl + F5 Restores the size of the active workbook or window
  35. Ctrl + F6 Moves to the next open workbook or window
  36. Ctrl + F7 Activates the Move window command
  37. Ctrl + F8 Activates the Resize window command
  38. Ctrl + F9 Minimises the size of the active workbook or window
  39. Ctrl + G Displays the GoTo dialog box
  40. Ctrl + H Displays the Replace dialog box
  41. Ctrl + Home Moves to cell "A1" on the active sheet
  42. Ctrl + I Toggles italics on the current selection
  43. Ctrl + Insert Copies the current selection to the clipboard
  44. Ctrl + K Displays the Insert Hyperlink dialog box
  45. Ctrl + L Displays the Create Table dialog box
  46. Ctrl + Left Arrow Moves to the first column in the current region
  47. Ctrl + N Creates a new workbook
  48. Ctrl + O Displays the Open dialog box
  49. Ctrl + P Displays the Print dialog box
  50. Ctrl + Page Down Moves to the next worksheet in the workbook
  51. Ctrl + Page Up Moves to the previous worksheet in the workbook
  52. Ctrl + R Copies the leftmost cell in the selection to the right
  53. Ctrl + Right Arrow Moves to the last column in the current region
  54. Ctrl + S Saves, Displays the Save As dialog box if a new workbook
  55. Ctrl + Shift + ( ' or ) Applies the Time format "hh:mm" to the selection
  56. Ctrl + Shift + (- or _ ) Removes all the borders from the selection
  57. Ctrl + Shift + ( Unhides any hidden rows within the selection
  58. Ctrl + Shift + (# or ~) Applies the General format to the selection
  59. Ctrl + Shift + (1 or !) Applies the Comma separated format "#,##0.00" to the selection
  60. Ctrl + Shift + (4 or $) Applies the Currency format "£#,##0.00" to the selection
  61. Ctrl + Shift + (5 or %) Applies the Percentage format "0%" to the selection
  62. Ctrl + Shift + (6 or ^) Applies the Exponential format "#,##E+02" to the selection
  63. Ctrl + Shift + (7 or &) Applies the outline border to the selection
  64. Ctrl + Shift + (8 or *) Selects the current region (surrounded by blank rows and columns)
  65. Ctrl + Shift + ) Unhides any hidden columns within the selection
  66. Ctrl + Shift + ; Enters the current time into the active cell
  67. Ctrl + Shift + [ Selects all the cells that are directly (or indirectly) referred to by the formula in the active cell
  68. Ctrl + Shift + \ Select unequal cells
  69. Ctrl + Shift + \ Selects the cells in a selected column that do not match the value in the active cell
  70. Ctrl + Shift + ] Selects all the cells that directly (or indirectly) refer to the active cell
  71. Ctrl + Shift + = Displays the Cells dialog box
  72. Ctrl + Shift + 0 Unhides the columns in the current selection
  73. Ctrl + Shift + 2 Enters the value from the cell directly above into the active cell
  74. Ctrl + Shift + 2 Enters the value from the cell directly above into the active cell
  75. Ctrl + Shift + 8 Selects the current region (surrounded by blank rows and columns)
  76. Ctrl + Shift + 9 Unhides the rows in the current selection
  77. Ctrl + Shift + Arrow Key Extends the selection to the next cell adjacent to a blank cell in that direction
  78. Ctrl + Shift + End Extends the selection to the last used cell on the worksheet
  79. Ctrl + Shift + Enter Enters the formula as an Array Formula
  80. Ctrl + Shift + F Activates the Font Tab of the format cells
  81. Ctrl + Shift + F10 Activates the Menu Bar or Shortcut Characters in 2007
  82. Ctrl + Shift + F12 Displays the (File > Print) dialog box
  83. Ctrl + Shift + F3 Displays the (Insert > Name > Create) dialog box
  84. Ctrl + Shift + F6 Moves to the previous open workbook or window
  85. Ctrl + Shift + Home Extends the selection to the beginning of the worksheet
  86. Ctrl + Shift + O Selects all the cells with comments
  87. Ctrl + Shift + P Activates the Font Size tab of the format cells
  88. Ctrl + Shift + Page Down Selects the active worksheet and the one after it
  89. Ctrl + Shift + Page Up Selects the active worksheet and the one before it
  90. Ctrl + Shift + Spacebar Selects all the objects on the worksheet when an object is selected or selects the whole worksheet
  91. Ctrl + Shift + Tab Moves to the previous open workbook or window
  92. Ctrl + Spacebar Selects the current column
  93. Ctrl + Tab Moves to the next open workbook or window
  94. Ctrl + U Toggles underlining on the current selection
  95. Ctrl + Up Arrow Moves to the first row in the current region
  96. Ctrl + V Pastes the entry from the clipboard
  97. Ctrl + W Closes the active workbook or window
  98. Ctrl + X Cuts the current selection to the clipboard
  99. Ctrl + Y Repeats the last workbook action.
  100. Ctrl + Z Undo the last workbook action

Excel Scroll Shortcut Keys

  1. End + Arrow Keys Moves to the next non-empty cell in that direction
  2. End + Enter Moves to the last cell in the current row that is not blank
  3. End + Home Moves to the last used cell on the active worksheet*
  4. End + Home Moves to the last used cell on the active worksheet*
  5. End + Shift + Arrow Keys Extends the selection to the next non-blank cell in that direction
  6. End + Shift + End Extends the selection to the last cell in the current row*
  7. End + Shift + Home Extends the selection to the last used cell on the worksheet
  8. Equal To (=) Starts a Formula

Excel Function Shortcut Keys

  1. F1 Displays the Office Assistant or (Help > Microsoft Excel Help).
  2. F2 Edits the active cell, putting the cursor at the end.
  3. F3 Displays the (Insert > Name > Paste) dialog box.
  4. F4 Repeats the last worksheet action (Edit > Repeat).
  5. F5 Displays the (Edit > GoTo) dialog box.
  6. F6 Moves to the next pane in a workbook (if the window is split).
  7. F7 Displays the (Tools > Spelling) dialog box.
  8. F8 Toggles whether to extend a selection with the arrow keys.
  9. F9 Calculates All the worksheets in All the open workbooks.
  10. F10 Toggles the activation of the Menu Bar.
  11. F11 Displays the (Insert > Chart) dialog box that creates a chart (on a chart sheet) using the highlighted range.
  12. F12 Displays the (File > Save As) dialog box.

Excel Scroll Lock Shortcut Keys

  1. Scroll Lock + Arrow Keys Moves the workbook or window one cell the corresponding direction
  2. Scroll Lock + End Moves to the last cell in the current window
  3. Scroll Lock + Home Moves to the first cell in the current window
  4. Scroll Lock + Page Down Moves you down one screen (current selection unchanged
  5. Scroll Lock + Page Up Moves you up one screen (current selection unchanged)

Excel Shift Shortcut Keys

  1. Shift + Arrow Keys Extends the selection by one cell in that direction
  2. Shift + Arrow keys Select the active cell and the cell in the given direction
  3. Shift + Backspace Selects the active cell when multiple cells are selected
  4. Shift + Enter Enters the contents of the active cell and moves to the cell above (by default)
  5. Shift + Enter Moves to the cell directly above (opposite direction to Enter)
  6. Shift + F10 Displays the (Shortcut) menu for the selected item
  7. Shift + F11 Inserts a new worksheet (before the active sheet) into the active workbook (Insert > Worksheet)
  8. Shift + F12 Saves, Displays the (File > Save As) dialog box if a new workbook
  9. Shift + F2 Inserts or edits a cell comment (Insert > Comment)
  10. Shift + F3 Displays the (Insert > Function) dialog box
  11. Shift + F4 Repeats the last Find, the same as (Edit > Find Next)
  12. Shift + F5 Displays the (Edit > Find) dialog box
  13. Shift + F6 Moves to the previous pane in a workbook (if the window is split)
  14. Shift + F8 Toggles between switching Add Mode on or off*
  15. Shift + F9 Calculates just the active worksheet
  16. Shift + Home Extends the selection to the first column
  17. Shift + Insert Enters the data from the clipboard
  18. Shift + Page Down Extends the selection down one screen
  19. Shift + Page Up Extends the selection up one screen
  20. Shift + Spacebar Selects the current row.
  21. Shift + Tab Enters the contents of the active cell and moves one cell to the left
  22. Shift + Tab Moves from right to left within a selection (opposite direction to Tab)
  23. Shift + Tab Moves to the cell directly to the left (opposite direction to Tab).

So, Here's the complete cheat sheet of the most important Microsoft Excel to increase speed in MS Excel. If you found any other shortcuts other than this then please share with us.