top of page

Excel Operations From Keyboard Shortcuts

  • Writer: Zach Pfeffer
    Zach Pfeffer
  • Sep 5, 2024
  • 2 min read

This post contains an index of Microsoft Excel operations from keyboard shortcuts. These can be useful when you need to work with huge tables that contain a lot of data.


Index


Excel Operations From Keyboard Shortcuts


See the number of rows and columns of data

  1. Hold down Ctrl + Shift + tap Space Bar

  2. Look in the upper left



Clear selection

Any arrow key



Select all unused columns

  1. Ctrl + Home

  2. Ctrl + End

  3. Right Arrow Key

  4. Ctrl + Space

  5. Shift + Ctrl + Right Arrow Key



Delete selected columns

One of these:

  • Ctrl + (Minus sign) -

  • Alt, then h, then d, then c



Hide selected columns

Ctrl+0



Select all unused rows

  1. Ctrl + Home

  2. Ctrl + End

  3. Down Arrow Key

  4. Shift + Space

  5. Ctrl + Shift + Down Arrow Key



Delete selected row

One of these:

  • Ctrl + (Minus sign) -

  • Alt, then h, then d, then r



Hide selected rows

Ctrl+9



Create a table with all the data

  1. Ctrl + Home

  2. Ctrl + Shift + End

  3. Alt, then h, then t, then Enter, then Enter



Select table column

Ctrl + Space



Select table row

Shift + Space



Select from a row down

  1. Shift + Space

  2. Ctrl + Shift + Down Arrow



Select from a row up

  1. Shift + Space

  2. Ctrl + Shift + Up Arrow



Select all table data

Ctrl + a



Launch table header drop-down

One of these:

  • Regular

    • Ctrl + up

    • Alt + Down Arrow

  • End Mode (press End then...) ("End mode" auto ends on arrow key)

    • Up Arrow

    • Alt + Down Arrow



Clear all table filters

Alt a, then c



Insert row above

Ctrl + (Plus) +



Remove row below

Ctrl + (Minus) -



All Excel Shortcuts



References




Microsoft Office Excel (2019–present).svg 258 × 240 pixels

Excel Operations From Keyboard Shortcuts

 
 

© 2025 by Centennial Software Solutions LLC.

bottom of page