Leading the way in Microsoft Office Development
 Home|

Excel

|Word|PowerPoint|Consultancy|Feedback|Contact 
 Excel > Shortcut Keys > Getting Started | Next > 

 

Most useful shortcut keys in Excel

 
 
End + HomeMoves to the last used cell on the active worksheet*
F11Creates a chart (on a chart sheet) using the highlighted range
Shift + F9Calculates just the active worksheet
Ctrl + 1Displays the (Format > Cells) dialog box
Ctrl + DCopies the first cell in the selection downwards (Edit > Fill > Down)
Ctrl + Page DownMoves to the next worksheet in the active workbook
Ctrl + TabMoves to the next workbook or window
Ctrl + Shift + Down ArrowSelects all the cells to the end of the current region
Alt + Shift + F1Inserts a new worksheet into the active workbook
Alt + Down ArrowDisplays the Pick From List drop-down list
Ctrl + Shift + =Inserts rows above the current selection.
Ctrl + Shift + -Deletes the rows currently selected.
 
 

Note: *This is only updated when the workbook is closed.

 

 Copyright © 2010 Better Solutions Limited. All Rights Reserved.Top | Next >