Microsoft Excel Keyboard Shortcuts

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 + ‘