Home > Skills > Shortcuts > Keyboard Excel Keyboard ShortcutsGet a list of Excel keyboard shortcuts, or use the interactive list, shown below. Also see the list of Top Excel Tips, shown below, to help you save time. ![]() |
Also see:
Watch these short videos to see quick ways to get things done with Excel mouse and keyboard shortcuts.
Instead of dragging down a long list of data, click the first cell in the range that you want to select. Then, scroll down, press the Shift key, and click on the last cell that you want to select.
In a large table, quickly move to the edge of the range with a double-click of the mouse, or a keyboard shortcut.
If you are copying and pasting in the same rows in a filtered list, you can use the shortcut Ctrl + R, to fill right, or use a Ribbon command to fill left
Use these Excel keyboard shortcuts to quickly create a chart from the selected data. Change the default settings to determine which chart type will be used.
Category |
Hold |
Press |
Keyword |
Result |
---|---|---|---|---|
Format Data |
Ctrl |
0 |
column |
Hide columns |
Format Data |
Ctrl |
1 |
format |
Display the Format Cells dialog box |
Format Data |
Ctrl + Shift |
2 |
time |
Apply Time format |
Format Data |
Ctrl |
5 |
strikethrough |
Apply or remove strikethrough formatting |
Select Cells |
Ctrl |
6 |
object |
Alternate between hiding objects, displaying objects, and displaying placeholders for objects |
Select Cells |
Ctrl |
7 |
toolbar |
Show or hide the Standard toolbar |
Outline Data |
Ctrl |
8 |
outline |
Display or hide outline symbols |
Format Data |
Ctrl |
9 |
row |
Hide rows |
Enter Data |
Ctrl |
' |
copy |
Copy formula from cell above |
Format Data |
Alt |
' |
style |
Style dialog box |
Format Data |
Ctrl + Shift |
' |
number |
Apply number format |
Edit Data |
Ctrl |
- |
delete |
Delete selection |
Format Data |
Ctrl + Shift |
- |
border |
Remove outline borders |
Format Data |
Ctrl + Shift |
! |
number |
Apply Number format with 2 decimal places, thousands separator |
Enter Data |
Ctrl + Shift |
" |
copy |
Copy value from cell above |
Format Data |
Ctrl + Shift |
# |
date |
Apply the Date format with the day, month, and year |
Format Data |
Ctrl + Shift |
$ |
currency |
Apply Currency format |
Format Data |
Ctrl + Shift |
% |
percent |
Apply Percentage format with no decimal places |
Format Data |
Ctrl + Shift |
& |
border |
Apply the outline border |
Format Data |
Ctrl + Shift |
( |
row |
Unhide rows |
Format Data |
Ctrl + Shift |
) |
column |
Unhide columns |
Select Cells |
Ctrl + Shift |
* |
region |
Select the current region |
Move within Selection |
Ctrl |
. |
move |
Move clockwise to the next corner of the selection |
Select Cells |
Ctrl |
/ |
array |
Select current array |
Enter Data |
Ctrl + Shift |
; |
time |
Enter the time |
Enter Data |
Ctrl |
; |
date |
Enter the date |
Select Cells |
Alt |
; |
cells |
Select visible cells in current selection |
Select Cells |
Ctrl |
[ |
dependent |
Select direct dependents |
Select Cells |
Ctrl + Shift |
[ |
dependent |
Select all dependents |
Select Cells |
Ctrl |
\ |
difference |
Select differences |
Select Cells |
Ctrl + Shift |
\ |
unequal |
Select unequal cells |
Select Cells |
Ctrl |
] |
precedent |
Select direct precedents |
Select Cells |
Ctrl + Shift |
] |
precedent |
Select all precedents |
Format Data |
Ctrl + Shift |
^ |
number |
Apply Exponential number format |
Enter Data |
Ctrl |
` |
formula |
Toggle formula view |
Edit Data |
Ctrl + Shift |
= |
insert |
Insert blank cells |
Enter Data |
Alt |
= |
AutoSum |
Insert the AutoSum formula |
Enter Data |
Ctrl |
A |
formula |
Display Formula Palette after typing function name in formula |
Enter Data |
Ctrl + Shift |
A |
formula |
Insert the argument names and parentheses for a function after you type a function name in a formula |
Select Cells |
Ctrl |
A |
All |
Select the entire worksheet |
Enter Data |
|
Arrow key |
move |
Move one character up, down, left, or right |
Move and Scroll |
Ctrl |
Arrow key |
move |
Move to edge of current region |
Move and Scroll |
|
Arrow key |
move |
Move one cell up, down, left, or right |
Select Cells |
Ctrl + Shift |
Arrow Key |
select |
Extend the selection to the last nonblank cell in the same column or row as the active cell |
Select Cells |
Shift |
Arrow Key |
select |
Extend the selection by one cell |
Format Data |
Ctrl |
B |
bold |
Apply or remove bold formatting |
Enter Data |
|
Backspace |
delete |
Delete character to left of insertion point, or delete selection |
Move and Scroll |
Ctrl |
Backspace |
scroll |
Scroll to display the active cell |
Select Cells |
Shift |
Backspace |
select |
Select only the active cell when multiple cells are selected |
Edit Data |
Ctrl |
C |
copy |
Copy the selection |
Enter Data |
Ctrl |
D |
fill |
Fill down |
Enter Data |
Ctrl |
Delete |
delete |
Delete text to the end of the line |
Enter Data |
|
Delete |
delete |
Delete character to right of insertion point, or delete selection |
Enter Data |
Alt |
Down Arrow |
AutoComplete |
Display the AutoComplete list |
Move and Scroll |
Ctrl |
End |
move |
Move to the last cell on the worksheet |
Select Cells |
Ctrl + Shift |
End |
select |
Extend the selection to the last used cell on the worksheet (lower-right corner) |
Enter Data |
Alt |
Enter |
line break |
Start a new line in the same cell |
Enter Data |
Ctrl |
Enter |
fill |
Fill the selected cell range with current entry |
Enter Data |
Ctrl + Shift |
Enter |
array |
Enter formula as array formula |
Enter Data |
Shift |
Enter |
complete |
Complete cell entry and move up in selection |
Enter Data |
|
Enter |
complete |
Complete cell entry and move down in selection |
Enter Data |
|
Esc |
cancel |
Cancel a cell entry |
Menus |
|
Esc |
close |
Close visible menu or submenu |
Windows |
Ctrl |
Esc |
Start |
Show the Windows Start menu |
Help |
|
F1 |
Help |
Open the Help Task pane |
Menus |
Shift |
F10 |
shortcut |
Show a shortcut menu |
Menus |
|
F10 |
menu |
Make the menu bar active |
Windows |
Ctrl |
F10 |
maximize |
Maximize or restore the workbook window |
Charts |
|
F11 |
chart |
Create a chart that uses the current range |
Macros |
Alt |
F11 |
VBE |
Display the Visual Basic Editor |
Macros |
Ctrl |
F11 |
macro |
Insert a Microsoft Excel 4.0 macro sheet |
Worksheets |
Shift |
F11 |
worksheet |
Insert a new worksheet |
Workbook |
Ctrl |
F12 |
open |
Display the Open dialog box |
Workbook |
|
F12 |
save as |
Open the Save As dialog box |
Workbook |
Shift |
F12 |
save |
Save the file |
|
Ctrl + Shift |
F12 |
|
Display the Print dialog box |
Charts |
Alt |
F2 |
chart |
Create a chart that uses the current range |
Enter Data |
Shift |
F2 |
comment |
Edit a cell comment |
Enter Data |
|
F2 |
edit |
Edit the active cell and position the insertion point at the end of the line |
Worksheets |
Alt + Shift |
F2 |
worksheet |
Insert a new worksheet |
Enter Data |
Ctrl |
F3 |
name |
Define a name |
Enter Data |
Ctrl + Shift |
F3 |
name |
Create names from row and column labels |
Enter Data |
Shift |
F3 |
function |
Paste a function into a formula |
Enter Data |
|
F3 |
name |
Paste defined name into formula |
Enter Data |
|
F4 |
repeat |
Repeat the last action |
Move and Scroll |
Shift |
F4 |
find |
Repeat the last Find action (Find Next) |
Windows |
Ctrl |
F4 |
close |
Close the active workbook window |
Move and Scroll |
Shift |
F5 |
find |
Display the Find dialog box |
Move and Scroll |
|
F5 |
go to |
Display the Go To dialog box |
Windows |
Ctrl |
F5 |
restore |
Restore the active workbook window size |
Dialog Box |
|
F6 |
dialog box |
In a range selection box, switch focus to the worksheet |
Move and Scroll |
Ctrl |
F6 |
window |
Move to the next workbook or window |
Move and Scroll |
Ctrl+Shift |
F6 |
window |
Move to the previous workbook or window |
Move and Scroll |
Shift |
F6 |
pane |
Move to previous pane in workbook that has been split |
Move and Scroll |
|
F6 |
pane |
Move to next pane in split workbook |
Edit Data |
|
F7 |
spell |
Display the Spelling dialog box |
Windows |
Ctrl |
F7 |
move |
Carry out Move command (workbook icon menu, menu bar), or use arrow keys to move the window |
Macros |
Alt |
F8 |
macro |
Display the Macro dialog box |
Select Cells |
Shift |
F8 |
select |
Add another range of cells to the selection; or use the arrow keys to move to the start of the range you want to add, and then press F8 and the arrow keys to select the next range |
Select Cells |
|
F8 |
select |
Turn on extending a selection by using the arrow keys |
Windows |
Ctrl |
F8 |
size |
Carry out Size command (workbook icon menu, menu bar), or use arrow keys to size the window |
Enter Data |
Ctrl + Alt |
F9 |
calculate |
Calculate all sheets in the active workbook |
Enter Data |
Shift |
F9 |
calculate |
Calculate the active worksheet |
Enter Data |
|
F9 |
calculate |
Calculate all sheets in all open workbooks |
Windows |
Ctrl |
F9 |
minimize |
Minimize the workbook window to an icon |
Move and Scroll |
Ctrl |
Home |
move |
Move to the beginning of the worksheet |
Move and Scroll |
|
Home |
move |
Move to the beginning of the row |
Select Cells |
Ctrl + Shift |
Home |
select |
Extend the selection to the beginning of the worksheet |
Select Cells |
Shift |
Home |
select |
Extend the selection to the beginning of the row |
Format Data |
Ctrl |
I |
italic |
Apply or remove italic formatting |
Enter Data |
Ctrl |
K |
hyperlink |
Insert a hyperlink |
Move within Selection |
Ctrl + Alt |
Left Arrow |
move |
Move left between nonadjacent selections |
Outline Data |
Alt + Shift |
Left Arrow |
group |
Ungroup rows or columns |
Select Cells |
Ctrl + Shift |
O |
comment |
Select all cells with comments |
|
Ctrl |
P |
|
Display the Print dialog box |
Move and Scroll |
Alt |
Page Down |
move |
Move one screen to the right |
Move and Scroll |
Ctrl |
Page Down |
move |
Move to the next sheet in the workbook |
Move and Scroll |
|
Page Down |
move |
Move down one screen |
Select Cells |
Shift |
Page Down |
select |
Extend the selection down one screen |
Worksheets |
Ctrl + Shift |
Page Down |
select |
Select current and next sheet in workbook |
Move and Scroll |
Alt |
Page Up |
move |
Move one screen to the left |
Move and Scroll |
Ctrl |
Page Up |
move |
Move to the previous sheet in the workbook |
Move and Scroll |
|
Page Up |
move |
Move up one screen |
Select Cells |
Shift |
Page Up |
select |
Extend the selection up one screen |
Worksheets |
Ctrl + Shift |
Page Up |
select |
Select current and previous in workbook |
Windows |
Alt |
Print Screen |
copy |
Copy the image of the active window to the Clipboard |
Windows |
|
Print Screen |
copy |
Copy the image of the screen to the Clipboard |
Enter Data |
Ctrl |
R |
fill |
Fill to the right |
Move within Selection |
Ctrl + Alt |
Right Arrow |
move |
Move right between nonadjacent selections |
Outline Data |
Alt + Shift |
Right Arrow |
group |
Group rows or columns |
Menus |
Alt |
Spacebar |
menu |
Show control menu |
Select Cells |
Ctrl |
Spacebar |
column |
Select the entire column |
Select Cells |
Ctrl + Shift |
Spacebar |
objects |
With an object selected, select all objects on a sheet |
Select Cells |
Shift |
Spacebar |
row |
Select the entire row |
Move and Scroll |
Ctrl |
Tab |
window |
Move to the next workbook or window |
Move and Scroll |
Ctrl+Shift |
Tab |
window |
Move to the previous workbook or window |
Move within Selection |
Shift |
Tab |
left |
Move left |
Move within Selection |
|
Tab |
right |
Move right |
Windows |
Alt |
Tab |
program |
Switch to the next program |
Windows |
Alt + Shift |
Tab |
program |
Switch to the previous program |
Format Data |
Ctrl |
U |
underline |
Apply or remove an underline |
Edit Data |
Ctrl |
V |
paste |
Paste the selection |
Windows |
Ctrl |
W |
close |
Close the active workbook window |
Edit Data |
Ctrl |
X |
cut |
Cut the selection |
Enter Data |
Ctrl |
Y |
repeat |
Repeat the last action |
Edit Data |
Ctrl |
Z |
undo |
Undo the last action |
1. Download the pdf file: Excel Tips and Keyboard Shortcuts.
2. Download the zipped Excel file: Excel keyboard shortcuts
Last updated: May 10, 2023 12:32 PM