Microsoft Excel Keyboard Shortcuts

Action Shortcut Key
Go to “Tell me what you want to do” Alt + Q
Zoom Alt + W, Q, Tab to value you want
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
Applies or removes strikethrough Ctrl + 5
Displays or hides outline symbols Ctrl + 8
Select a range of cells Ctrl + Shift + *
Enter a line break within a cell Alt + Enter
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 (zero)
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
Define a range name Ctrl + F3
Fill a range to the right Ctrl + R
Fill a range down Ctrl + D
Add values to active column using surrounding data Ctrl + E
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 + ~
Apply the date format with day, month, year Ctrl + Shift + #
Apply the time format with hour and minute, AM or PM 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 (if data in worksheet, then once selects region and Ctrl + A twice selects entire worksheet) Ctrl+A
Format cells dialog Ctrl + 1
Fill Color Alt + H, H
Add Border Alt + H, B
Open the Find and Replace dialog box Ctrl + F
Open the GoTo dialog box Ctrl + G or F5
Open the Create Table dialog box Ctrl + L
Insert a hyperlink Ctrl + K
Open a new workbook Ctrl + O
Open Print in backstage view Ctrl + P
Display Quick Analysis options Ctrl + Q
Undo Ctrl + Z
Redo Ctrl + Y
Cancel Esc
Move to File tab ribbon Alt + F, use letters to navigate
Move to Home tab ribbon Alt + H, use letters to navigate
Move to Insert tab ribbon Alt + N, use letters to navigate
Move to Formulas tab ribbon Alt + M, use letters to navigate
Move to Page Layout tab ribbon Alt + P, use letters to navigate
Move to Data tab ribbon Alt + A, use letters to navigate
Move to Review tab ribbon Alt + R, use letters to navigate
Move to View tab ribbon Alt + W, use letters to navigate
Move to Developer tab ribbon Alt + L, use letters to navigate
On the ribbon, to move between commands Tab or Shift-tab
To move between groups on a ribbon Ctrl + Right Arrow or Ctrl + Left Arrow
Activate a selected command on the ribbon Spacebar or Enter key
Open a gallery on the ribbon Spacebar or Enter key
Finish with a control on the ribbon and move back to the document Enter key
Expand or collapse the ribbon Ctrl + F1
Help F1
Edit Cells F2
Paste named range in formula F3
Toggle between absolute and relative cell references F4
Go To F5
Switches between the worksheet, Ribbon, task pane, and Zoom controls F6
Spell check F7
Turn extend mode on or off F8
Calculate all worksheets in open workbook F9
Display ribbon key tip letters F10
Create a chart F11
Display Save As F12
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
Applies or removes strikethrough Ctrl + 5
Displays or hides outline symbols Ctrl + 8
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 (zero)
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
Add values to active column using surrounding data Ctrl + E
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 + ~
Apply the date format with day, month, year Ctrl + Shift + #
Apply the time format with hour and minute, AM or PM 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 (if data in worksheet, then once selects region and Ctrl + A twice selects entire worksheet) Ctrl+A
Paste named range in formula F3
Format cells dialog Ctrl + 1
Open the Find and Replace dialog box Ctrl + F
Open the GoTo dialog box Ctrl + G or F5
Open the Create Table dialog box Ctrl + L
Insert a hyperlink Ctrl + K
Open a new workbook Ctrl + O
Open Print in backstage view Ctrl + P
Display Quick Analysis options Ctrl + Q
Display Save As F12
Undo Ctrl + Z
Redo Ctrl + Y
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 + ‘

We provide Excel Training in the following cities