You can use keyboard shortcuts to easily navigate throughout your worksheet, within a cell, or throughout your entire workbook.
|
Create a new workbook |
Ctrl+N |
|
Open an existing workbook |
Ctrl+O |
|
Save a workbook |
Ctrl+S |
|
Open the Save As dialog box |
F12 |
|
Close a workbook |
Ctrl+W |
|
Close Excel |
Ctrl+F4 |
|
Repeat the last command or action |
F4 |
|
Insert a new worksheet |
Shift+F11 |
|
Undo an action |
Ctrl+Z |
|
Redo an action |
Ctrl+Y |
|
Switch to Print Preview |
Ctrl+F2 |
|
Open the Help pane |
F1 |
|
Go to the “Tell me what you want to do” box |
Alt+Q |
|
Check the spelling |
F7 |
|
Calculate all worksheets in all open workbooks |
F9 |
|
Calculate active worksheets |
Shift+F9 |
|
Turnkey tips on or off |
Alt or F10 |
|
Show or hide the ribbon |
Ctrl+F1 |
|
Expand or collapse the formula bar |
Ctrl+Shift+U |
|
Minimize the workbook window |
Ctrl+F9 |
|
Create a bar chart based on selected data (on a separate sheet) |
F11 |
|
Create an embedded bar chart based on select data (same sheet) |
Alt+F1 |
|
Search in a spreadsheet, or use Find and Replace |
Ctrl+F |
|
Open the File tab menu |
Alt+F |
|
Go to the Home tab |
Alt+H |
|
Open the Insert tab |
Alt+N |
|
Go to the Page Layout tab |
Alt+P |
|
Go to the Formulas tab |
Alt+M |
|
Go to the Data tab |
Alt+A |
|
Go to the Review tab |
Alt+R |
|
Go to the View tab |
Alt+W |
|
Go to the Add-ins tab |
Alt+X |
|
Go to the Help tab |
Alt+Y |
|
Switch between open workbooks |
Ctrl+Tab |
|
Insert a function |
Shift+F3 |
|
Create, run, edit, or delete a macro |
Alt+F8 |
|
Open the Microsoft Visual Basic For Applications Editor Moving |
Alt+F11 |
|
Move one cell to the left or right |
Left/Right Arrow |
|
Move to the farthest cell left or right in the row |
Ctrl+Left/Right Arrow |
|
Move one cell up or down |
Up/Down Arrow |
|
Move to the top or bottom cell in the column |
Ctrl+Up/Down Arrow |
|
Go to the next cell |
Tab |
|
Go to the previous cell |
Shift+Tab |
|
Go to the most bottom right used cell |
Ctrl+End |
|
Go to any cell by pressing F5 and typing the cell coordinate or |
F5 |
|
Go to the leftmost cell in the current row (or go to the |
Home |
|
Move to the beginning of a worksheet |
Ctrl+Home |
|
Move one screen up or down in a worksheet |
Page Up/Down |
|
Move one screen to the right or left in a worksheet |
Alt+Page Up/Down |
|
Move to the previous or next worksheet |
Ctrl+Page Up/Down |
|
|
Selecting Cells |
|
Extend the cell selection to the left or right |
Shift+Left/Right Arrow |
|
Select the entire row |
Shift+Space |
|
Select the entire column |
Ctrl+Space |
|
Select the entire worksheet Editing Cells |
Ctrl+Shift+Space |
|
Edit a cell |
F2 |
|
Add or edit a cell comment |
Shift+F2 |
|
Cut contents of a cell, selected data, or selected cell range |
Ctrl+X |
|
Copy contents of a cell, selected data, or selected cell range |
Ctrl+C or Ctrl+Insert |
|
Paste contents of a cell, selected data, or selected cell range |
Ctrl+V or Shift+Insert |
|
Open the Paste Special dialog box |
Ctrl+Alt+V |
|
Remove the contents of a cell, selected data, or selected cell |
Delete |
|
Insert a hard return within a cell (while editing a cell) |
Alt+Enter |
|
Paste a cell name (if cells are named in the worksheet) |
F3 |
|
Delete column |
Alt+H+D+C |
|
Cancel an entry in a cell or the formula bar |
Esc |
|
Complete an entry in a cell or the formula bar Formatting Cells |
Enter |
|
Add or remove bold to the contents of a cell, selected data, or |
Ctrl+B |
|
Add or remove italics to the contents of a cell, selected data, |
Ctrl+I |
|
Add or remove underline to the contents of a cell, selected data, |
Ctrl+U |
|
Select a fill color |
Alt+H+H |
|
Add a border |
Alt+H+B |
|
Apply outline border |
Ctrl+Shift+& |
|
Remove outline border |
(Ctrl+Shift+(Underline |
|
Hide the selected rows |
Ctrl+9 |
|
Hide the selected columns |
Ctrl+0 |
|
Open the Format Cells dialog box |
Ctrl+1 |
|
Apply or remove strikethrough |
Ctrl+5 |
|
Apply currency format |
$+Ctrl+Shift |
|
Apply percent format |
%+Ctrl+Shift |