Excel Operations From Keyboard Shortcuts

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.

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

https://support.microsoft.com/en-us/office/keyboard-shortcuts-in-excel-1798d9d5-842a-42b8-9c99-9b7213f0040f