Resources

Microsoft Excel Keyboard Shortcuts

Don't remember all of those Excel keyboard shortcuts you learned in your last class? No problem! Here are some of the most popular shortcuts for you to use.

While many of these shortcuts will work for all versions of Excel, these lists have been prepared for Excel 2010, 2007 and 2003 so if you have another version of the program, some of the actions may or may not be applicable.

Action

Shortcut Key

Edit cells F2
Move between open workbooks Ctrl + Tab
Move to next sheet Ctrl + PgDn
Move to previous sheet Ctrl + PgUp
Insert a new worksheet Shift + F11
Select the current sheet and the next sheet Shift + Ctrl + PgDn
Select the current sheet and the previous sheet Shift + Ctrl + PgUp
Select the entire column Ctrl + Spacebar
Select the entire row Shift + Spacebar
Display the format cells dialog box Ctrl + 1
Select a range of cells Ctrl + Shift + *
Enter a line break within a cell Alt + Enter
Toggle between absolute and relative cell references F4
Toggle between viewing values and formulas in cells Ctrl + ~
Delete the selected cells Ctrl + -
Insert blank cells Ctrl + Shift + +
Hide the selected rows Ctrl + 9
Unhide any hidden rows in the selection Ctrl + Shift + (
Hide the selected columns Ctrl + 0
Unhide any hidden columns in the selection Ctrl + Shift + )
Apply an outline border to the selected cells Ctrl + Shift + &
Remove the outline border Ctrl + Shift + _
Open the Visual Basic editor Alt + F11
Insert the current date Ctrl + ;
Insert the current time Ctrl + Shift + ;
Create a new, blank workbook Ctrl + N
Create a chart F11
Repeat the last action F4
Define a range name Ctrl + F3
Fill a range to the right Ctrl + R
Fill a range down Ctrl + D
Enter the cent character Alt + 0162
Enter the pound sterling character Alt + 0163
Enter the yen symbol Alt + 0165
Enter the euro symbol Alt + 0128
Display the insert function dialog box Shift + F3
Copy the value from the cell above Ctrl + Shift + "
Copy the formula from the cell above Ctrl + '
Open Print Preview Ctrl + F2
Apply the currency format Ctrl + Shift + $
Apply the percentage format Ctrl + Shift + %
Apply the exponential number format Ctrl + Shift + ^
Apply the number format with two decimals Ctrl + Shift + !
Apply the general number format Ctrl + Shift + ~
Display the style dialog box Alt + '
rotates the active cell through the corners of a selection Ctrl + .
Select direct precedent cells Ctrl + [
Select all precedent cells Shift + Ctrl + [
Select directly dependent cells Ctrl + ]
Select all dependent cells Shift + Ctrl + ]
Select entire worksheet cells Ctrl+A
Paste named range in formula F3
Format cells dialog Ctrl + 1

Action

Shortcut Key

Edit cells F2
Move between open workbooks Ctrl + Tab
Move to next sheet Ctrl + PgDn
Move to previous sheet Ctrl + PgUp
Insert a new worksheet Shift + F11
Select the current sheet and the next sheet Shift + Ctrl + PgDn
Select the current sheet and the previous sheet Shift + Ctrl + PgUp
Select the entire column Ctrl + Spacebar
Select the entire row Shift + Spacebar
Display the format cells dialog box Ctrl + 1
Select a range of cells Ctrl + Shift + *
Enter a line break within a cell Alt + Enter
Toggle between absolute and relative cell references F4
Toggle between viewing values and formulas in cells Ctrl + ~
Delete the selected cells Ctrl + -
Insert blank cells Ctrl + Shift + +
Hide the selected rows Ctrl + 9
Unhide any hidden rows in the selection Ctrl + Shift + (
Hide the selected columns Ctrl + 0
Unhide any hidden columns in the selection Ctrl + Shift + )
Apply an outline border to the selected cells Ctrl + Shift + &
Remove the outline border Ctrl + Shift + _
Open the Visual Basic editor Alt + F11
Insert the current date Ctrl + ;
Insert the current time Ctrl + Shift + ;
Create a new, blank workbook Ctrl + N
Create a chart F11
Repeat the last action F4
Define a range name Ctrl + F3
Fill a range to the right Ctrl + R
Fill a range down Ctrl + D
Enter the cent character Alt + 0162
Enter the pound sterling character Alt + 0163
Enter the yen symbol Alt + 0165
Enter the euro symbol Alt + 0128
Display the insert function dialog box Shift + F3
Copy the value from the cell above Ctrl + Shift + "
Copy the formula from the cell above Ctrl + '
Open Print Preview Ctrl + F2
Apply the currency format Ctrl + Shift + $
Apply the percentage format Ctrl + Shift + %
Apply the exponential number format Ctrl + Shift + ^
Apply the number format with two decimals Ctrl + Shift + !
Apply the general number format Ctrl + Shift + ~
Display the style dialog box Alt + '

Action

Shortcut Key

Edit cells F2
Delete cells entirely Ctrl + -
Move between open workbooks Ctrl + Tab
Move to next sheet Ctrl + PgDn
Move to previous sheet Ctrl + PgUp
Insert a new worksheet Shift + F11
Select the current sheet and the next sheet Shift + Ctrl + PgDn
Select the current sheet and the previous sheet Shift + Ctrl + PgUp
Select the entire column Ctrl + Spacebar
Select the entire row Shift + Spacebar
Display the format cells dialog box Ctrl + 1
Select a range of cells Ctrl + Shift + *
Enter a line break within a cell Alt + Enter
Toggle between absolute and relative cell references F4
Toggle between viewing values and formulas in cells Ctrl +
Delete the selected cells Ctrl + -
Insert blank cells Ctrl + Shift + +
Hide the selected rows Ctrl + 9
Unhide any hidden rows in the selection Ctrl + Shift + (
Hide the selected columns Ctrl + 0
Unhide any hidden columns in the selection Ctrl + Shift + )
Apply an outline border to the selected cells Ctrl + Shift + &
Remove the outline border Ctrl + Shift + _
Open the Visula Basic editor Alt + F11
Insert the current date Ctrl + ;
Insert the current time Ctrl + Shift + ;
Insert the current time and date Ctrl + Spacebar then Ctrl + Shift + ;
Create a chart F11
Repeat the last action F4
Define a range name Ctrl + F3
Fill a range to the right Ctrl + R
Fill a range down Ctrl + D
Enter the cent character Alt + 0162
Enter the pound sterling character Alt + 0163
Enter the yen symbol Alt + 0165
Enter the euro symbol Alt + 0128
Display the insert function dialog box Shift + F3
Copy the value from the cell above Ctrl + Shift + "
Copy the formula from the cell above Ctrl + '
Edit a cell comment Ctrl + F2
Apply the currency format Ctrl + Shift + $
Apply the percentage format Ctrl + Shift + %
Aply the exponential number format Ctrlj + Shift + ^
Apply the number format with two decimals Ctrl + Shift + !
Apply the general number format Ctrl + Shift + ~
Display the style dialog box Alt + '