Excel Keyboard Shortcuts

May 03, 2017 - by Andrew Reeves

I have had a number of people in my excel classes recently asking if there is a good list of excel shortcuts. Microsoft have produced an article but I have composed a list of the best and most useful ones I have come across from working with excel over the last 20 years. As excel has changed and developed over the years with plenty of new versions, some of these areas may be unfamiliar to you. So if you would like to find out more about using excel and getting the most from it do have a look at attending one of our courses such as Excel Functions and Formulas for beginner to intermediate users or Excel Data Analysis for more advanced users.

CTRL + Home                  

Move to cell A1

CTRL + PgUp (PgDown) 

Moves between sheets in a workbook

Shift + Arrow Keys          

Select a series of cells

CTRL + Arrow Keys         

Moves around current objects on a sheet

CTRL + SHIFT + Arrow Keys 

Selects whole area (range of data)

CTRL + *

Selects current region

Function Key F11  

Create a graph of current selection – adds a separate graph sheet

CTRL + F3  

Opens the Name Manager Dialog

CTRL + 1 

Opens Format Cells Dialog

Function Key F4    

Repeats last command (useful for adding extra rows or columns)

CTRL + -    

Invokes delete column / cell / row dialog

CTRL + +    

Invokes add column / cell / row dialog

CTRL + Enter  

Auto Fill Region - Select a series of cells and enter text into top cell then press CTRL + Enter to fill the entire range

Ctrl+Shift+1       

Format cell into comma (number) format.

Ctrl+Shift+4       

Format number into currency format.

Ctrl+Shift+5       

Format number into percentage format.

Ctrl+Shift+6       

Format number into scientific format.

CTRL + ~             

Format number into date (custom) format

CTRL + 0

Hide selected column

CTRL + 9

Hide selected Row

CTRL + ;

Adds in Todays date an formats cell to date

I hope you find this list of shortcuts useful and do feel free to ask us if you need any assistance or want to attend one of our couses.

0 comments

Leave a reply