82 Keyboard Shortcuts for Excel YOU Need + (PDF Cheat Sheet)

Knowing and using Keyboard Shortcuts is one of those Excel Skills that can help you save a ton of time every day. There are more than 500 keyboard shortcuts that you can use in Excel, but the problem is not all of those can be helpful for you.

That’s why I have listed only the 82 most important keyboard shortcuts that you can learn and use easily. If somehow you are not able to find a keyboard shortcut for the option that you use frequently in your work, you can use the following method to find it.

Most Amazing Keyboard Shortcuts for Excel

Navigation

• Move to edge of data region
  • Windows: Ctrl + Arrow Keys
  • Mac: Command + Arrow Keys
  • Windows: Ctrl + Home
  • Mac: Command + Home
  • Windows: Ctrl + End
  • Mac: Command + End
  • Windows: Ctrl + G or F5
  • Mac: Command + G or F5
  • Windows: Ctrl + Backspace
  • Mac: Command + Delete

  Formatting

  • Open Format Cells dialog box
    • Windows: Ctrl + 1
    • Mac: Command + 1
    • Windows: Ctrl + B
    • Mac: Command + B
    • Windows: Ctrl + I
    • Mac: Command + I
    • Windows: Ctrl + U
    • Mac: Command + U
    • Windows: Ctrl + 5
    • Mac: Command + Shift + X
    • Windows: Alt + H, H
    • Mac: Option + Command + H
    • Windows: Alt + H, H, N
    • Mac: Option + Command + H, N
    • Windows: Alt + H, H, M
    • Mac: Option + Command + H, M
    • Windows: Alt + H, FC
    • Mac: Option + Command + C
    • Windows: Alt + H, AC
    • Mac: Option + Command + C
    • Windows: Alt + H, AL
    • Mac: Option + Command + L
    • Windows: Alt + H, AR
    • Mac: Option + Command + R
    • Windows: Alt + H, B
    • Mac: Option + Command + B
    • Windows: Alt + H, O, I
    • Mac: Option + Command + I
    • Windows: Ctrl + Shift + $
    • Mac: Command + Shift + $
    • Windows: Ctrl + Shift + %
    • Mac: Command + Shift + %
    • Windows: Ctrl + Shift + ^
    • Mac: Command + Shift + ^
    • Windows: Ctrl + Shift + #
    • Mac: Command + Shift + #
    • Windows: Ctrl + Shift + @
    • Mac: Command + Shift + @

    Fo rmulas

    • Start a formula
      • Windows: =
      • Mac: =
      • Windows: Alt + =
      • Mac: Command + Shift + T
      • Windows: Ctrl + `
      • Mac: Command + `
      • Windows: Shift + F3
      • Mac: Shift + F3
      • Windows: Ctrl + [
      • Mac: Command + [
      • Windows: Ctrl + ]
      • Mac: Command + ]
      • Windows: Shift + F9
      • Mac: Shift + F9
      • Windows: F9
      • Mac: F9

      Miscellaneous

      • Open Help
        • Windows: F1
        • Mac: Command + /
        • Windows: Alt + F1
        • Mac: F11
        • Windows: F11
        • Mac: Fn + F11
        • Windows: Shift + F11
        • Mac: Shift + Fn + F11
        • Windows: Ctrl + 9
        • Mac: Command + 9
        • Windows: Ctrl + Shift + 9
        • Mac: Command + Shift + 9
        • Hide columns
          • Windows: Ctrl + 0
          • Mac: Command + 0
          • Windows: Ctrl + Shift + 0
          • Mac: Command + Shift + 0
          • Windows: Ctrl + T
          • Mac: Command + T
          • Windows: Ctrl + Shift + &
          • Mac: Command + Shift + &
          • Windows: Ctrl + Shift + _
          • Mac: Command + Shift + _
          • Windows: Alt + H, O, I
          • Mac: Option + Command + I
          • Windows: Ctrl + Shift + $
          • Mac: Command + Shift + $
          • Windows: Ctrl + Shift + %
          • Mac: Command + Shift + %
          • Windows: Ctrl + Shift + ^
          • Mac: Command + Shift + ^
          • Windows: Ctrl + Shift + #
          • Mac: Command + Shift + #
          • Windows: Ctrl + Shift + @
          • Mac: Command + Shift + @
          • Windows: Ctrl + D
          • Mac: Command + D

          Selection

          • Select entire column
            • Windows: Ctrl + Space
            • Mac: Command + Space
            • Windows: Shift + Space
            • Mac: Shift + Space
            • Windows: Ctrl + A
            • Mac: Command + A
            • Windows: Shift + Arrow Keys
            • Mac: Shift + Arrow Keys
            • Windows: Ctrl + Shift + Arrow Keys
            • Mac: Command + Shift + Arrow Keys
            • Windows: Ctrl + Shift + Home
            • Mac: Command + Shift + Home
            • Windows: Ctrl + Shift + End
            • Mac: Command + Shift + End
            • Windows: Shift + Page Up
            • Mac: Shift + Fn + Up Arrow
            • Windows: Shift + Page Down
            • Mac: Shift + Fn + Down Arrow
            • Windows: Ctrl + Shift + Space
            • Mac: Command + Shift + Space

            Data

            • Edit active cell
              • Windows: F2
              • Mac: Control + U
              • Windows: Ctrl + C
              • Mac: Command + C
              • Windows: Ctrl + X
              • Mac: Command + X
              • Windows: Ctrl + V
              • Mac: Command + V
              • Windows: Ctrl + Z
              • Mac: Command + Z
              • Windows: Ctrl + Y
              • Mac: Command + Y
              • Windows: Delete
              • Mac: Delete
              • Windows: Alt + E, S, V
              • Mac: Command + Control + V
              • Windows: Ctrl + D
              • Mac: Command + D
              • Windows: Ctrl + R
              • Mac: Command + R
              • Windows: Ctrl + Shift + Plus (+)
              • Mac: Command + Shift + Plus (+)
              • Windows: Ctrl + Minus (-)
              • Mac: Command + Minus (-)
              • Windows: Ctrl + K
              • Mac: Command + K
              • Windows: Alt + A, R, H
              • Mac: Option + Command + R, H
              • Windows: Ctrl + Shift + A
              • Mac: Command + Shift + A

              Workbook Management

              • New workbook
                • Windows: Ctrl + N
                • Mac: Command + N
                • Windows: Ctrl + O
                • Mac: Command + O
                • Windows: Ctrl + S
                • Mac: Command + S
                • Windows: Ctrl + P
                • Mac: Command + P
                • Windows: Ctrl + W
                • Mac: Command + W
                • Windows: F12
                • Mac: Command + Shift + S
                • Windows: Ctrl + F2
                • Mac: Command + P
                • Windows: Alt + F4
                • Mac: Command + Q

                Helpful Note

                When you press the ALT‌ key Excel shows you the keys that you can use to open the tab from the ribbon.

                

                And when you press a key for a particular tab to open it further shows you the keys to open the options that you have on that tab, so one for further dropdowns.

                

                Some Less Known Excel Shortcuts

                Using keyboard shortcuts can speed up your workflow and make you more efficient. Here are some amazing keyboard shortcuts that I have learned throughout the years.

                1. Quick Analysis Tool - After selecting a range of cells, press Ctrl + Q to open the Quick Analysis tool. This tool offers options for formatting charts, totals, tables, and sparklines tailored to the selected data.
                2. Toggle Formulas View - Press Ctrl + ` to toggle between displaying formulas and their results in cells. It is handy for quickly reviewing the formulas in a worksheet.
                3. Insert Current Date and Time - Ctrl + ; (semicolon) inserts the current date into a cell, and Ctrl + Shift + ; inserts the current time. This is especially entertaining for timestamps in a cell.
                4. Open Insert Function Dialog - Press Shift + F3 to open the Insert Function dialog box. This box allows you to search for and insert functions without typing them manually or remembering syntax.
                5. Select All Cells with Comments - Press Ctrl + Shift + O (the letter O) to select all cells that have comments. This is handy when quickly navigating through or editing comments in a worksheet.