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.

Index

• Excel Operations From Keyboard Shortcuts

  • See the number of rows and columns of data

  • Clear selection

  • Select all unused columns

  • Delete selected columns

  • Select all unused rows

  • Delete selected row

  • Hide selected rows

  • Create a table with all the data

  • Select table column

  • Select table row

  • Select from a row down

  • Select from a row up

  • Select all table data

  • Launch table header drop-down

  • Clear all table filters

  • Insert row above

  • Remove row below

• All Excel Shortcuts

• References

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

Back to index

Clear selection

Any arrow key

Back to index

Select all unused columns

1. Ctrl + Home

2. Ctrl + End

3. Right Arrow Key

4. Ctrl + Space

5. Shift + Ctrl + Right Arrow Key

Back to index

Delete selected columns

One of these:

• Ctrl + (Minus sign) -

• Alt, then h, then d, then c

Back to index

Hide selected columns

Ctrl+0

Back to index

Select all unused rows

1. Ctrl + Home

2. Ctrl + End

3. Down Arrow Key

4. Shift + Space

5. Ctrl + Shift + Down Arrow Key

Back to index

Delete selected row

One of these:

• Ctrl + (Minus sign) -

• Alt, then h, then d, then r

Back to index

Hide selected rows

Ctrl+9

Back to index

Create a table with all the data

1. Ctrl + Home

2. Ctrl + Shift + End

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

Back to index

Select table column

Ctrl + Space

Back to index

Select table row

Shift + Space

Back to index

Select from a row down

1. Shift + Space

2. Ctrl + Shift + Down Arrow

Back to index

Select from a row up

1. Shift + Space

2. Ctrl + Shift + Up Arrow

Back to index

Select all table data

Ctrl + a

Back to index

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

Back to index

Clear all table filters

Alt a, then c

Back to index

Insert row above

Ctrl + (Plus) +

Back to index

Remove row below

Ctrl + (Minus) -

Back to index

All Excel Shortcuts

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

Back to index

References

Excel icon from https://en.m.wikipedia.org/wiki/File:Microsoft_Office_Excel_%282019%E2%80%93present%29.svg

Back to index

Excel Operations From Keyboard Shortcuts

Back to top