chartered accountant

Copy Page

Published on 12 April 2025

Essential Excel Shortcuts: Boost Your Productivity with 95 Time-Saving Keys

Understanding Timesaver Excel Shortcuts

Timesaver Excel Shortcuts consist of 95 essential and advanced Excel shortcuts designed to streamline your workflow. Before exploring these shortcuts, it is vital to understand the notation used:

  • Keys separated by “ + ” indicate that all keys should be pressed simultaneously.
  • Keys separated by “ , ” signify that you should press the first key, release it, and then press the second key.

List of Excel Shortcuts

Here’s a detailed list of Excel shortcuts along with their functions:

  1. Ctrl+N: Create a new workbook
  2. Shift+F11: Add a new worksheet to the left of the current worksheet
  3. Alt, E, L: Delete the current worksheet
  4. Ctrl + Down Arrow: Move to the last cell of the current column
  5. Ctrl + Right Arrow: Move to the last cell of the current row
  6. Ctrl + Up Arrow: Move to the first cell of the current column
  7. Ctrl + Left Arrow: Move to the first cell of the current row
  8. Ctrl + Shift + Down Arrow: Select all cells down to the last cell of the current column
  9. Ctrl + Shift + Right Arrow: Select all cells across to the last cell of the current row
  10. Ctrl + Shift + Up Arrow: Select all cells up to the first cell of the current column
  11. Ctrl + Shift + Left Arrow: Select all cells to the left up to the first cell of the current row
  12. Ctrl + Space: Select the entire column of the active cell(s)
  13. Shift + Space: Select the entire row of the active cell(s)
  14. Alt + Enter: Insert a new line within the same cell
  15. Ctrl + Y or F4: Repeat the last action performed
  16. Ctrl + Page Up: Navigate to the previous sheet
  17. Ctrl + Page Down: Navigate to the next sheet
  18. Alt, H, F, F: Change the font
  19. Alt, H, F, S: Change the font size
  20. Alt, H, F, C: Change the font color
  21. Alt, H, H: Fill color in cell(s)
  22. Alt, H, H, N: Remove color from cell(s)
  23. Alt, H, A, T: Align text to the top of cell(s)
  24. Alt, H, A, M: Align text to the middle of cell(s)
  25. Alt, H, A, B: Align text to the bottom of cell(s)
  26. Alt, H, A, L: Align text to the left of cell(s)
  27. Alt, H, A, C: Align text to the center of cell(s)
  28. Alt, H, A, R: Align text to the right of cell(s)
  29. Alt, H, W: Wrap text in cell(s)
  30. Alt, H, W: Unwrap text in cell(s)
  31. Alt, H, M, C: Merge cells centered
  32. Alt, H, M, A: Merge cells left-aligned
  33. Alt, H, M, U: Unmerge cells
  34. Ctrl + 1: Open the Format Cell option
  35. Alt, H, B, A: Apply all borders to cell(s)
  36. Ctrl + Shift + 7 or Alt, H, B, S: Apply outside border to cell(s)
  37. Alt, H, B, T: Apply a thick outside border to cell(s)
  38. Alt, H, B, L: Apply left border to cell(s)
  39. Alt, H, B, R: Apply right border to cell(s)
  40. Alt, H, B, P: Apply top border to cell(s)
  41. Alt, H, B, O: Apply bottom border to cell(s)
  42. Alt, H, B, B: Apply double bottom border to cell(s)
  43. Alt, H, B, U: Apply top and double bottom borders to cell(s)
  44. Ctrl + Shift + - or Alt, H, B, N: Remove border from cell(s)
  45. Alt, H, K: Apply accounting format to cell(s)
  46. Alt, H, 0: Increase decimal place
  47. Alt, H, 9: Decrease decimal place
  48. Alt, I, R: Insert row(s) above the current row
  49. Alt, I, C: Insert column(s) to the left of the current column
  50. Ctrl + -:
    • Shift cell
    • Delete Row/Column
  51. Ctrl + F: Open find option
  52. Ctrl + H: Open find & replace option
  53. Ctrl + Shift + U: Expand/collapse the formula bar
  54. Ctrl + Shift + F1: Hide/unhide the toolbar
  55. Ctrl + Shift + F6: Switch between workbooks
  56. Ctrl + Shift + 1: Convert selected cells to number format
  57. Ctrl + Shift + 2: Convert selected cells to time format
  58. Ctrl + Shift + 3: Convert selected cells to date format
  59. Ctrl + Shift + 4: Apply currency symbol
  60. Ctrl + Shift + 5 or Alt, H, P: Apply percentage style
  61. Ctrl + Shift + 8 or Ctrl + Shift + A: Select all cells
  62. Ctrl + 9: Hide rows
  63. Ctrl + Shift + 9 or Alt, H, O, U, O: Unhide rows
  64. Ctrl + 0: Hide columns
  65. Ctrl + Shift + 9 or Alt, H, O, U, L: Unhide columns
  66. Shift + F2: Insert or edit a comment in a cell
  67. Ctrl + Shift + O: Select all comments in the active worksheet
  68. Shift + F10, M: Delete comment from selected cell(s)
  69. Ctrl + D: Copy content/formula from the cell above
  70. Ctrl + R: Copy content/formula from the adjacent cell to the right
  71. Alt, H, O, A: AutoFit Row Height
  72. Alt, H, O, I: AutoFit Column Width
  73. Alt, H, O, H: Set custom row height
  74. Alt, H, O, W: Set custom column width
  75. Alt, H, O, R: Rename worksheet
  76. Alt, H, O, T: Apply color to the active worksheet tab
  77. Alt, H, O, T, N: Remove color from the worksheet tab
  78. Alt, H, O, M: Move or copy worksheet
  79. Ctrl + ;: Insert the current date in a cell
  80. Ctrl + Shift + ;: Insert the current time in a cell
  81. Alt + W + F: Open freeze pane options
  82. Alt + W + F + R: Freeze the top row
  83. Alt + W + F + C: Freeze the first column
  84. Alt + W + F + F: Unfreeze panes
  85. Ctrl + G, Alt + S: Go to special
  86. Ctrl + G, Alt + S, K, Enter: Go to special - Select blanks
  87. Alt + W + V + G: Hide/unhide gridlines
  88. Ctrl + Shift + L or Alt + D + F + F: Apply/remove filter option
  89. a. Alt + Down Arrow: Open filter dropdown
    b. Up & Down Arrow Keys: Navigate within the filter dropdown
    c. Space Bar: Select/unselect items
  90. Alt + D + F + S: Unfilter cells
  91. Ctrl + Alt + V, V, Enter or Alt + E + S + V, Enter: Paste Special - Values
  92. Ctrl + Alt + V, E, Enter or Alt + E + S + E, Enter: Paste Special - Transpose
  93. Alt + N + V: Create a pivot table
  94. Alt + =: AutoSum
  95. Ctrl + Enter: Fill all selected cells with the same data or formula

By familiarizing yourself with these shortcuts, you can significantly enhance your efficiency when using Excel.

Share: