Excel: Keyboard shortcuts
Workbook
Control
| Action | Keyboard shortcut |
|---|---|
| Open an existing workbook. | Ctrl+O |
| Create & open a new workbook. | Ctrl+N |
| Close the current workbook. | Ctrl+W |
| Save the current workbook. | Ctrl+S |
Navigate: Tabs
| Action | Keyboard shortcut |
|---|---|
| Navigate to the “Home” tab. | Alt+H |
| Navigate to the “Insert” tab. | Alt+N |
| Navigate to the “Draw” tab. | Alt+J+I |
| Navigate to the “Page Layout” tab. | Alt+P |
| Navigate to the “Formulas” tab. | Alt+M |
| Navigate to the “Data” tab. | Alt+A |
| Navigate to the “Review” tab. | Alt+R |
| Navigate to the “View” tab. | Alt+W |
| Navigate to the “Developer” tab. | Alt+L |
Worksheet
Align Text
| Action | Keyboard shortcut |
|---|---|
| Align the contents of the selected cells to the left. | Alt+H,A,L |
| Align the contents of the selected cells to the right. | Alt+H,A,R |
| Align the contents of the selected cells to the center. | Alt+H,A,C |
| Align the contents of the selected cells to the top. | Alt+H,A,T |
| Align the contents of the selected cells to the middle. | Alt+H,A,M |
| Align the contents of the selected cells to the bottom. | Alt+H,A,B |
Apply Borders
| Action | Keyboard shortcut |
|---|---|
| Apply a black, single-line border to the topmost, bottommost, leftmost & rightmost edges of the selected cells. | Ctrl+Shift+& |
| Remove all borders from the selected cells. | Ctrl+Shift+_ |
| Apply a border to the bottommost edge of the selected cells. | Alt+H,B,O |
| Apply a border to the topmost edge of the selected cells. | Alt+H,B,P |
| Apply a border to the leftmost edge of the selected cells. | Alt+H,B,L |
| Apply a border to the rightmost edge of the selected cells. | Alt+H,B,R |
| Remove all borders from the selected cells. | Alt+H,B,N |
| Apply a border around every edge of all selected cells. | Alt+H,B,A |
| Apply a border to the topmost, bottommost, leftmost & rightmost edges of the selected cells. | Alt+H,B,S |
| Apply a thick border to the topmost, bottommost, leftmost & rightmost edges of the selected cells. | Alt+H,B,T |
| Apply a double-lined border to the bottommost edge of the selected cells. | Alt+H,B,B |
| Apply a thick border to the bottommost edge of the selected cells. | Alt+H,B,H |
| Apply a border to the topmost and bottommost edge of the selected cells. | Alt+H,B,D |
| Apply a border to the topmost edge of the selected cells and a thick border to the bottommost. | Alt+H,B,C |
| Apply a border to the topmost edge of the selected cells and a double-lined border to the bottommost. | Alt+H,B,U |
| Draw a border around the edge of a selection of cells. | Alt+H,B,W |
| Draw a border around every edge of all selected cells. | Alt+H,B,G |
| Erase every border around every edge of all selected cells. | Alt+H,B,E |
| Choose the color of borders. | Alt+H,B,I |
| Choose the style of border lines. | Alt+H,B,Y |
Enter Data
| Action | Keyboard shortcut |
|---|---|
| Enter the current time into a cell or formula. | Ctrl+Shift+; |
| Enter today’s date into a cell or formula. | Ctrl+; |
Format Cells
| Action | Keyboard shortcut |
|---|---|
| Apply the “General” format to a cell. | Ctrl+Shift+~ |
| Choose a color for the selected cell’s background. | Alt+H,H |
| Choose a color for the selected cell’s text. | Alt+H,F,C |
| Toggle a cell’s contents between having and not having bold formatting. | Ctrl+B |
| Toggle a cell’s contents between having and not having italic formatting. | Ctrl+I |
| Toggle a cell’s contents between being and not being underlined. | Ctrl+U |
| Toggle a cell’s contents between being and not being double-underlined. | Alt+H,3,D |
| Toggle a cell’s contents between being and not being struck-through with a single line. | Ctrl+5 |
| Toggle a cell’s contents between being and not being angled counterclockwise. | Alt+H,F,Q,O |
| Toggle a cell’s contents between being and not being angled clockwise. | Alt+H,F,Q,L |
| Toggle a cell’s contents between being and not being angled vertically. | Alt+H,F,Q,V |
| Toggle a cell’s contents between being and not being rotated counterclockwise by 90°. | Alt+H,F,Q,V |
| Toggle a cell’s contents between being and not being rotated clockwise by 90°. | Alt+H,F,Q,D |
Format Numbers
| Action | Keyboard shortcut |
|---|---|
| Apply the default currency format to a cell containing a number. | Ctrl+Shift+$ |
Navigate Cells
| Action | Keyboard shortcut |
|---|---|
| Move to the cell above the currently active one. | ↑ |
| Move to the cell below the currently active one. | ↓ |
| Move to the cell to the left of the currently active one. | ⟵ |
| Move to the cell to the right of the currently active one. | ⟶ |
| Navigate to cell A1. | Ctrl+Home |
| Navigate to the cell at the intersection of the rightmost column and lowest row to have been populated. | Ctrl+End |
Open Dialogue Windows
| Action | Keyboard shortcut |
|---|---|
| Open the “Create Table” dialogue window. | Ctrl+T |
| Open the “Find” dialogue window. | Ctrl+F |
| Open the “Find and Replace” dialogue window. | Ctrl+H |
| Open the “Format Cells” dialogue window. | Ctrl+1 |
| Open the “Format Cells: Alignment” dialogue window. | Alt+H,F,Q,M |
| Open the “Format Cells: Border” dialogue window. | Alt+H,B,M |
| Open the “Go To” dialogue window. | Ctrl+G |
| Open the “Insert Hyperlink” dialogue window. | Ctrl+K |
| Open the “Print” dialogue window. | Ctrl+P |