Here you will find an exhaustive resource of quick-keyboard shortcuts for Excel. Each shortcut title is clickable to a more complete description and the types of shortcuts are separated by type headings.
File Shortcuts
Shortcut | Description | Windows | Mac |
---|---|---|---|
New Workbook | Creates a new, blank workbook. | CTRL + N | ⌘ + N |
Open Workbook | Displays the Open File dialog box. | CTRL + O | ⌘ + O |
Save Workbook | Displays the Save File dialog box. | CTRL + S | ⌘ + S |
Save As | Displays the Save As File dialog box. | F12 | ⌘ + ⇧ + S |
Displays the Print pane in the File tab in Windows and displays the Print dialog box on Mac. | CTRL + P | ⌘ + P | |
Open print preview | Displays the print preview window. CTRL + P has the same effect in later Excel versions on Windows. | CTRL + F2 | None available |
Go to next workbook | Move to the next or previous workbook by cycling through open workbooks. | CTRL + TAB | ^ + TAB |
Close current workbook | Closes the current workbook. | CTRL + F4 | ⌘ + W |
Close Excel | Closes the open Excel file. | ALT + F4 | ⌘ + Q |
Ribbon Shortcuts
Shortcut | Description | Windows | Mac |
---|---|---|---|
Show ribbon access keys | Displays the access keys to navigate the ribbon using only a keyboard. | ALT | None available |
Show/hide ribbon | Expand or collapse the ribbon. | CTRL + F1 | ⌘ + R |
Move to next ribbon control | Moves to the next ribbon from the currently active control. Using SHIFT + TAB moves backwards. | TAB | TAB |
Open selected controls | Active the selected control or command in the ribbon. | SPACE | SPACE |
Confirm control change | Confirms any change made to a ribbon or dialog window box. | ENTER | RETURN |
Get help on selected control | Gets help for selected control on the ribbon. | F1 | None available |
Navigation Shortcuts
Shortcut | Description | Windows | Mac |
---|---|---|---|
Return to a hyperlink | Returns to a hyperlink after clicking the link. | CTRL +G + ENTER | ^ + G + RETURN |
Move one cell right | Moves one cell to the right of the active selection. | ⇨ | ⇨ |
Move one cell left | Moves one cell to the left of the active selection. | ⇦ | ⇦ |
Move one cell up | Moves one cell above the active selection. | ⇧ | ⇧ |
Move one cell down | Moves one cell below the active selection. | ⇩ | ⇩ |
Move to right edge of data region | Moves to the first non-empty cell to the right when the active cell is empty. | CTRL + ⇨ | ^ + ⇨ |
Move to left edge of data region | Moves to the first non-empty cell to the left when the active cell is empty. | CTRL + ⇦ | ^ + ⇦ |
Move to top edge of data region | Moves to the first non-empty cell above the active cell when the cell is empty. | CTRL + ⇧ | ^ + ⇧ |
Move to bottom edge of data region | Moves to the first non-empty cell below the active cell when the cell is empty. | CTRL + ⇩ | ^ + ⇩ |
Move to beginning of row | Moves to the beginning of a row, regardless of whether the cell has data or not. | HOME | FN + ⇦ |
Move to last cell in worksheet | Moves to the last cell that is the intersection of the last row and last column that contains data. | CTRL + END | FN + ^ + ⇨ |
Move to first cell in worksheet | Moves to cell A1, if freeze pane is turned off. If freeze pane is turned on, goes to upper left cell of the current pane. | CTRL + HOME | FN + ^ + ⇦ |
Turn end mode on | Enables end mode. When using end mode arrow keys take you further across the spreadsheet. | END | FN + ⇨ |
Move one screen right | Moves current selection one screen to the right of the active selection. | CTRL + PgDn | FN + ⌥ + ⇩ |
Move one screen left | Moves current selection one screen to the left of the active selection. | CTRL + PgUp | FN + ⌥ + ⇧ |
Move one screen up | Moves current selection one screen above the active selection. | PgUp | FN + ⇧ |
Move one screen down | Moves current selection one screen below the active selection. | PgDn | FN + ⇩ |
Drag & Drop Shortcuts
Shortcut | Description | Windows | Mac |
---|---|---|---|
Drag and cut | Drag using the mouse. | Drag | Drag |
Drag and copy | Copies cells during drag and drop. | CTRL + DRAG | ⌥ + DRAG |
Drag and insert | Inserts cells at new location. | SHIFT + DRAG | ⇧ + DRAG |
Drag and insert copy | Copies values and inserts them in the new location. Works with rows and columns. | CTRL + SHIFT + DRAG | ⌥ + ⇧ + DRAG |
Drag to worksheet | Used to drag a selection to a different worksheet. | ALT + DRAG | ⌘ + DRAG |
Drag to duplicate worksheet | Creates a duplicate of a worksheet. | CTRL + DRAG | ⌥ + DRAG |
Tables & Filters Shortcuts
Shortcut | Description | Windows | Mac |
---|---|---|---|
Insert table | Converts range of data to an Excel table. | CTRL + T | ^ + T |
Toggle Autofilter | Turns filters for a range of data on and off. Works on tables and filtered lists. | CTRL + SHIFT + L | ⌘ + ⇧ + F |
Activate filter | Activates an already existing filter. | ALT + ⇩ | ⌥ + ⇩ |
Select table row | Selects one or more table rows in a table. | SHIFT + SPACE | ⇧ + SPACE |
Select table column | Selects one or more table columns in a table. | CTRL + SPACE | ^ + SPACE |
Select table | Selects the data area of a table. | CTRL + A | ⌘ + A |
Clear slicer filter | Clears or resets the filter for a selected slicer. | ALT + C | ⌥ + C |
Toggle table total row | Toggles the visibility of the total row in an Excel table. | CTRL + SHIFT + T | ⌘ + ⇧ + T |
General Shortcuts
Shortcut | Description | Windows | Mac |
---|---|---|---|
Open options | Opens the options area. Options are called "preferences" on Mac. | ALT + F + T | ⌘ + , |
Open help | Open Excel's help system. | F1 | ⌘ + / + F |
Undo last action | Allows multiple levels of undo, stepping back one level each time it's used. | CTRL + Z | ⌘ + Z |
Redo last action | Allows multiple levels of redo, stepping forward one level each time it's used. | CTRL + Y | ⌘ + Y |
Copy selected cells | Places all selected items on the clipboard for pasting. | CTRL + C | ⌘ + C |
Repeat last action | Repeats the last action, when available. | F4 | ⌘ + Y |
Cut selected cells | Puts text, formulas, formatting, etc. on the clipboard. | CTRL + X | ⌘ + X |
Paste content from clipboard | Pastes everything on the clipboard. Includes content and formatting. | CTRL + V | ⌘ + V |
Display the paste special box | Opens the paste special dialog box for advanced paste options. | CTRL + ALT + V | ^ + ⌘ + V |
Display find and replace | Displays the find dialog box. | CTRL + F | ⌘ + F |
Display find and replace, replace selected | Displays the find dialog box with replace option selected. | CTRL + H | ^ + H |
Find next match | Searches for the same query after find has been used. | SHIFT + F4 | ⌘ + G |
Find previous match | Finds a previous match after find criteria has been set. | CTRL + SHIFT + F4 | ⌘ + ⇧ + G |
Create embedded chart | Creates and inserts a chart as an embedded object using data in the current range. | ALT + F1 | FN + ⌥ + F1 |
Create chart in new window | Creates and inserts a chart on a separate worksheet using data in the current range. | F11 | FN + F11 |
Selection Shortcuts
Shortcut | Description | Windows | Mac |
---|---|---|---|
Select entire row | Selects the entire row of the current selection. | SHIFT + SPACE | ⇧ + SPACE |
Select entire column | Selects the entire column of the current selection. | CTRL + SPACE | ^ + SPACE |
Select entire worksheet | Selects the entire worksheet. | CTRL + A | ⌘ + A |
Add adjacent cells to selection | Extends the current selection to include adjacent cells. | SHIFT + CLICK | ⇧ + CLICK |
Add non-adjacent cells to selection | Extends the current selection to include non-adjacent cells. | CTRL + CLICK | ⌘ + CLICK |
Same selection in next column | Moves the current selection to the next column to the right | None available | ⌥ + TAB |
Same selection in previous column | Moves the current selection to the previous column to the left | None available | ⌥ + ⇧ + TAB |
Move right between non-adjacent selections | Cycles the active cell through non-adjacent selections. Starts left and moves right. | CTRL + ALT + ⇨ | ^ + ⌥ + ⇨ |
Move left between non-adjacent selections | Cycles the active cell through non-adjacent selections. Starts right and moves left. | CTRL + ALT + ⇦ | ^ + ⌥ + ⇦ |
Toggle add to selection mode | Eliminates need to press CTRL to add non-adjacent cells to current selection. | SHIFT + F8 | FN + ⇧ + F8 |
Cancel selection | Aborts the operation when editing a cell and leaves the cell in its original state. | ESC | ESC |
Active Cell Shortcuts
Shortcut | Description | Windows | Mac |
---|---|---|---|
Select active cell only | Leaves only active cell selected when multiple cells are selected. | SHIFT + BACKSPACE | ⇧ + DELETE |
Show active cell on worksheet | Scrolls the screen to show the active cell on the worksheet. | CTRL + BACKSPACE | ⌘ + DELETE |
Move active cell clockwise in selection | Moves the active cell around four corners of a selection in a clockwise direction. | CTRL + . | ^ + . |
Move active cell down in selection | Cycles through every cell in a selection, moving from top left to bottom right. | ENTER | RETURN |
Move active cell up in selection | Cycles through every cell in a selection, moving from bottom right to top left. | SHIFT + ENTER | ⇧ + RETURN |
Move active cell right in selection | Moves active cell right one cell when multiple cells are selected. | TAB | TAB |
Move active cell left in selection | Moves active cell left one cell when multiple cells are selected. | SHIFT + TAB | ⇧ + TAB |
Dialog Boxes Shortcuts
Shortcut | Description | Windows | Mac |
---|---|---|---|
Move to next control | Moves to the next control in the dialog box. | TAB | TAB |
Move to previous control | Moves to the previous control in the dialog box. | SHIFT + TAB | ⇧ + TAB |
Move to next tab | Moves to the next tab in the dialog box. | CTRL + TAB | ^ + TAB |
Move to previous tab | Moves to the previous tab in the dialog box. | CTRL + SHIFT + TAB | ^ + ⇧ + TAB |
Accept and apply | Accepts and applies the settings in the dialog box. | ENTER | RETURN |
Check and uncheck box | Checks and unchecks boxes in the dialog box. | SPACE | SPACE |
Cancel and close the dialog box | Closes the dialog box without applying any changes. | ESC | ESC |
Workbook Shortcuts
Shortcut | Description | Windows | Mac |
---|---|---|---|
Insert new worksheet | Inserts a new worksheet as a tab in the active workbook. | SHIFT + F11 | FN + ⇧ + F11 |
Go to next worksheet | Moves to the next worksheet to the right and stops at the last worksheet. | CTRL + PgDn | FN + ^ + ⇩ |
Go to previous worksheet | Moves to the next worksheet to the left and stops at the last worksheet. | CTRL + PgUp | FN + ^ + ⇧ |
Move to next pane | Moves to the next pane in a worksheet that has been split. | F6 | FN + F6 |
Move to previous pane | Moves to the previous pane in a worksheet that has been split. | SHIFT + F6 | FN + ⇧ + F6 |
Go to next workbook | Moves to the next or previous window, cycling through the open workbooks. | CTRL + TAB | ^ + TAB |
Go to previous workbook | Moves to the next workbook window. | CTRL + SHIFT + TAB | ^ + ⇧ + TAB |
Minimize current workbook window | Minimizes the current workbook window. | CTRL + F9 | ⌘ + M |
Maximize current workbook window | Maximizes the current workbook window. | CTRL + F10 | FN + ^ + F10 |
Select adjacent worksheet | Selects additional adjacent worksheets. | SHIFT + CLICK | ⇧ + CLICK |
Select non-adjacent worksheet | Selects additional non-adjacent worksheets. | CTRL + CLICK | ⌘ + CLICK |
Toggle scroll lock | Toggles scroll lock on and off. | FN + HOME | FN + ⇧ + F14 |
Toggle full screen | Toggles full screen mode that hides the ribbon and status bar. | CTRL + SHIFT + F1 | ^ + ⌘ + F |
Pivot Table Shortcuts
Shortcut | Description | Windows | Mac |
---|---|---|---|
Select entire pivot table | Selects the entire pivot table, excluding report filters. | CTRL + A | ⌘ + A |
Toggle pivot table field checkbox | Toggles check and uncheck the box for fields listed in the pivot table field list. | SPACE | SPACE |
Group pivot table items | Groups pivot table items. | ALT + SHIFT + ⇨ | ⌘ + ⇧ + K |
Ungroup pivot table items | Ungroups selected pivot table items. | ALT + SHIFT + ⇦ | ⌘ + ⇧ + J |
Hide pivot table | Acts the same as filtering a pivot table field to exclude an item in the field. | CTRL + - | CTRL + - |
Create pivot chart on same worksheet | Embeds a pivot chart on the same worksheet as the pivot table. | ALT + F1 | None available |
Create pivot chart on new worksheet | Embeds a pivot chart on a new worksheet. | F11 | FN + F11 |
Open pivot table wizard | Launches the PivotTable Wizard dialog box. | ALT + D + P | ⌘ + ⌥ + P |
Number Formatting Shortcuts
Shortcut | Description | Windows | Mac |
---|---|---|---|
Apply general format | Applies general number format. | CTRL + SHIFT + ~ | ^ + ⇧ + ~ |
Apply currency format | Applies currency format with two decimal places. | CTRL + SHIFT + $ | ^ + ⇧ + $ |
Apply percentage format | Applies percentage format with no decimal places. | CTRL + SHIFT + % | ^ + ⇧ + % |
Apply scientific format | Applies scientific format with two decimal places. | CTRL + SHIFT + ^ | ^ + ⇧ + ^ |
Apply date format | Applies the date format as day, month, year. | CTRL + SHIFT + # | ^ + ⇧ + # |
Apply time format | Applies time format as hour and minutes and indicates AM or PM. | CTRL + SHIFT + @ | ^ + ⇧ + @ |
Apply number format | Applies the number format with two decimal places, thousands separator and the minus (-) sign for negative numbers. | CTRL + SHIFT + ! | ^ + ⇧ + ! |
Extending Selection Shortcuts
Shortcut | Description | Windows | Mac |
---|---|---|---|
Extend selection by one cell right | Extends right edge of current selection when multiple cells are selected. | SHIFT + ⇨ | ⇧ + ⇨ |
Extend selection by one cell left | Extends left edge of current selection when multiple cells are selected. | SHIFT + ⇦ | ⇧ + ⇦ |
Extend selection by one cell up | Extends top edge of current selection when multiple cells are selected. | SHIFT + ⇧ | ⇧ + ⇧ |
Extend selection by one cell down | Extends bottom edge of current selection when multiple cells are selected. | SHIFT + ⇩ | ⇧ + ⇩ |
Extend selection to the last cell right | Extends the selection to the first non-empty cell to the right if the active cell is empty. | CTRL + SHIFT + ⇨ | ^ + ⇧ + ⇨ |
Extend selection to the last cell left | Extends the selection to the first non-empty cell to the left if the active cell is empty. | CTRL + SHIFT + ⇦ | ^ + ⇧ + ⇦ |
Extend selection to the last cell up | Extends the selection to the first non-empty cell above the active cell if the active cell is empty. | CTRL + SHIFT + ⇧ | ^ + ⇧ + ⇧ |
Extend selection to the last cell down | Extends the selection to the first non-empty cell below the active cell if the active cell is empty. | CTRL + SHIFT + ⇩ | ^ + ⇧ + ⇩ |
Extend selection up one screen | Distance moved up will depend on the worksheet window. | SHIFT + PgUp | FN + ⇧ + ⇧ |
Extend selection down one screen | Distance moved down will depend on the worksheet window. | SHIFT + PgDn | FN + ⇧ + ⇩ |
Extend selection right one screen | Extends current selection one screen to the right. | ALT + SHIFT + PgDn | FN + ⇧ + ⌘ + ⇩ |
Extend selection left one screen | Extends current selection one screen to the left. | ALT + SHIFT + PgUp | FN + ⇧ + ⌘ + ⇧ |
Extend selection to start of row | Distance moved depends on size of the worksheet window. | SHIFT + HOME | FN + ⇧ + ⇦ |
Extend selection to first cell in worksheet | Extends to the home cell. Typically A1. | CTRL + SHIFT + HOME | FN + ^ + ⇧ + ⇦ |
Extend selection to last cell in worksheet | Extends to the cell at the intersection of the last column on the right that contains data and the last row that contains data. | CTRL + SHIFT + END | FN + ^ + ⇧ + ⇨ |
Toggle extend selection mode | Removes the need to press Shift to extend the current selection when enabled. | F8 | FN + F8 |
Select Special Shortcuts
Shortcut | Description | Windows | Mac |
---|---|---|---|
Display "Go To" dialog box | Allows you to go to a named range or specific address. | CTRL + G | ^ + G |
Select cells with comments | Will report "no cells found" if no cells with comments found. | CTRL + SHIFT + O | FN + ^ + ⇧ + O |
Select current region around active cell | Extends the selection around the active cell to include the current region around the active cell. | CTRL + SHIFT + * | ⇧ + ^ + SPACE |
Select current region | Selects the current region around the active cell when first used and the entire worksheet when used a 2nd consecutive time. | CTRL + A | ⌘ + A |
Select current array | Select the array that the active cells belongs to. | CTRL + / | ^ + / |
Select row differences | Selects all cells that do not match the value in the active cell in a row or selection within a row. | CTRL + \ | ^ + \ |
Select column differences | Selects all cells that do not match the value in the active cell in a column or selection within a column. | CTRL + SHIFT + | | ^ + ⇧ + | |
Select direct precedents | Selects cells that are directly referred to in a selected formula. | CTRL + [ | ^ + [ |
Select all precedents | Selects all cells that are directly or indirectly referred to in a selected formula. | CTRL + SHIFT + { | ^ + ⇧ + { |
Select direct dependents | Selects all cells with formulas that depend on the cells in the current selection. | CTRL + ] | FN + ^ + ] |
Select all dependents | Selects all cells with formulas that refer directly or indirectly to cells in the current selection. | CTRL + SHIFT + } | ^ + ⇧ + } |
Select visible cells only | Selects only visible cells in the current selection. | ALT + ; | ⌘ + ⇧ + Z |
Entering Data Shortcuts
Shortcut | Description | Windows | Mac |
---|---|---|---|
Enter and move down | Completes a cell entry and moves the cursor down one cell. | ENTER | RETURN |
Enter and move up | Completes a cell entry and moves the cursor up one cell. | SHIFT + ENTER | ⇧ + RETURN |
Enter and move right | Completes a cell entry and moves the cursor right one cell. | TAB | TAB |
Enter and move left | Completes a cell entry and moves the cursor left one cell. | SHIFT + TAB | ⇧ + TAB |
Complete entry and stay in same cell | Enters a value and stays in same cell when a single cell is selected. | CTRL + ENTER | ^ + RETURN |
Enter same data in multiple cells | Enters the same data in every cell when multiples cells are selected. | CTRL + ENTER | ^ + RETURN |
Insert current date | Inserts current date as a fixed, non-changing value. | CTRL + ; | ^ + ; |
Insert current time | Inserts current time as a fixed, non-changing value. | CTRL + SHIFT + : | ^ + ⇧ + : |
Fill down from cell above | Clones data from cells above to cells below, without having to copy/paste. | CTRL + D | ^ + D |
Fill right from cell left | Copies data from left to right. | CTRL + R | FN + ^ + R |
Copy formula from cell above | Copies the formula in the cell above to the current cell and leaves it in edit mode. | CTRL + ' | ^ + ' |
Copy value from cell above | Copies the value in the cell above to the current cell and leaves it in edit mode. | CTRL + SHIFT + " | ^ + ⇧ + " |
Add hyperlink | Adds a hyperlink to selected cell. | CTRL + K | ⌘ + K |
Display AutoComplete list | Display various Excel lists without having to use a mouse. | ALT + ⇩ | ⌥ + ⇩ |
Flash fill | Excel applies the same pattern to all rows of data based off of an initial value that represents the desired action. | CTRL + E | None available |
Cell Edit Mode Shortcuts
Shortcut | Description | Windows | Mac |
---|---|---|---|
Edit the active cell | Enters cell edit mode with the cursor at the end of the last line of text. | F2 | ^ + U |
Insert or edit comment | Opens an existing comment for edit, or create new comment if none exists. | SHIFT + F2 | FN + ⇧ + F2 |
Cancel entry | Aborts the operation without changing anything. | ESC | ESC |
Select one character right | Extends the selection by one character to the right when in a cell. | SHIFT + ⇨ | ⇧ + ⇨ |
Select one character left | Extends the selection by one character to the left when in a cell. | SHIFT + ⇦ | ⇧ + ⇦ |
Move one word right | Moves the cursor by one word to the right when in a cell. | CTRL + ⇨ | ^ + ⇨ |
Move one word left | Moves the cursor by one word to the left when in a cell. | CTRL + ⇦ | ^ + ⇦ |
Select one word right | Extends the selection by one word to the right when in a cell. | CTRL + SHIFT + ⇨ | ^ + ⇧ + ⇨ |
Select one word left | Extends the selection by one word to the left when in a cell. | CTRL + SHIFT + ⇦ | ^ + ⇧ + ⇦ |
Select to beginning of cell | Selects from the cursor to the beginning of text. | SHIFT + HOME | FN + ⇧ + ⇦ |
Select to end of cell | Selects from the cursor to the end of text. | SHIFT + END | FN + ⇧ + ⇨ |
Delete to end of line | Deletes text starting from the cursor to the end of the text. | CTRL + DELETE | ^ + DELETE |
Delete character to the left of the cursor | Deletes a single character to the left of the cursor. | BACKSPACE | DELETE |
Delete character to the right of the cursor | Deletes a single character to the right of the cursor. | DELETE | FN + DELETE |
Start a new line in the same cell | Enters line break inside the same cell. | ALT + ENTER | ^ + ⌥ + RETURN |
Formatting Shortcuts
Shortcut | Description | Windows | Mac |
---|---|---|---|
Format anything | Displays Format Cells dialog box when regular cells are selected, even if the ribbon is collapsed. | CTRL + 1 | ⌘ + 1 |
Display format cells with font tab selected | Displays Format Cells dialog box with the Font tab selected. | CTRL + SHIFT + F | ^ + ⇧ + F |
Apply or remove bold formatting | Toggles bolding on and off. | CTRL + B | ⌘ + B |
Apply or remove italic formatting | Toggles italics on and off. | CTRL + I | ⌘ + I |
Apply or remove underscoring | Toggles underlining on and off. | CTRL + U | ⌘ + U |
Apply or remove strikethrough formatting | Toggles strikethrough on and off. | CTRL + 5 | ⌘ + ⇧ + X |
Add or remove shadow font style | Toggles shadow font style on and off. | None available | ⌘ + ⇧ + W |
Add or remove the outline font style | Toggles outline font style on and off. | None available | ⌘ + ⇧ + D |
Align center | Aligns text in selected cells to center. | ALT + H + A + C | ⌘ + E |
Align left | Aligns text in selected cells to left. | ALT + H + A + L | ⌘ + L |
Align right | Aligns text in selected cells to right. | ALT + H + A + R | ⌘ + R |
Indent | Increases the indent in a cell by one step. | ALT + H + 6 | ^ + ⌥ + TAB |
Remove indent | Decreases the indent in a cell by one step. | ALT + H + 5 | ^ + ⌥ + ⇧ + TAB |
Increase font size one step | Increases the font size of current selection by one step. | ALT + H + FG | ⌘ + ⇧ + > |
Decrease font size one step | Decreases the font size of current selection by one step. | ALT + H + FK | ⌘ + ⇧ + < |
Borders Shortcuts
Shortcut | Description | Windows | Mac |
---|---|---|---|
Add border outline | Adds a border around the outside edge of current selection. | CTRL + SHIFT + & | ⌘ + ⌥ + 0 |
Add or remove right border | Adds or removes a border to the right edge of current selection. | ALT + R | ⌘ + ⌥ + ⇨ |
Add or remove left border | Adds or removes a border to the left edge of current selection. | ALT + L | ⌘ + ⌥ + ⇦ |
Add or remove top border | Adds or removes a border to the top edge of current selection. | ALT + T | ⌘ + ⌥ + ⇧ |
Add or remove bottom border | Adds or removes a border to the bottom edge of current selection. | ALT + B | ⌘ + ⌥ + ⇩ |
Add or remove upward diagonal border | Adds or removes an upward diagonal border to current selection. | ALT + D | None available |
Add or remove horizontal interior border | Adds or removes a horizontal interior border to current selection. | ALT + H | None available |
Add or remove vertical interior border | Adds or removes a vertical interior border to current selection. | ALT + V | None available |
Remove borders | Removes all cell borders with the exception of diagonal borders. | CTRL + SHIFT + _ | ⌘ + ⌥ + _ |
Formulas Shortcuts
Shortcut | Description | Windows | Mac |
---|---|---|---|
Toggle absolute and relative references | Toggles cell references from relative to absolute, to partially absolute, back to relative. | F4 | ⌘ + T |
Open the Insert Function dialog box | Displays Insert Function dialog box. This is the Formula Builder on a Mac. | SHIFT + F3 | FN + ⇧ + F3 |
Autosum selected cells | SUM formulas are placed below a group of selected cells. | ALT + = | ⌘ + ⇧ + T |
Toggle formulas on and off | Enables and disables the Show Formulas button on the Formula tab of the Ribbon. | CTRL + ` | ^ + ` |
Insert function arguments | Inserts function arguments needed for a function after the function name is typed. | CTRL + SHIFT + A | ^ + ⇧ + A |
Enter array formula | Enters an array formula, indicated by curly braces around the formula. | CTRL + SHIFT + ENTER | ^ + ⇧ + RETURN |
Calculate worksheets | Calculates all worksheets in all open workbooks. | F9 | FN + F9 |
Calculate active worksheet | Calculates only the active worksheet. | SHIFT + F9 | FN + ⇧ + F9 |
Force calculate all worksheets | Forces all worksheets in all open workbooks to calculate, even when cells haven't changed. | CTRL + ALT + F9 | None available. |
Evaluate part of a formula | Evaluates parts of a formula. | F9 | FN + F9 |
Expand or collapse the formula bar | Toggles formula bar between collapsed and uncollapsed state. | CTRL + SHIFT + U | ^ + ⇧ + U |
Display function arguments dialog box | Displays function arguments dialog box after a valid function has been entered in the formula bar. | CTRL + A | ^ + A |
Define name | Displays the Name Manager dialog box. | CTRL + F3 | FN + ^ + F3 |
Define name using row and column labels | Displays the Create Names dialog box. | CTRL + SHIFT + F3 | FN + ^ + ⇧ + F3 |
Paste name into formula | Allows you to paste a previously defined name into a formula. | F3 | None available. |
Accept function with autocomplete | Accepts a function suggested by autocomplete. | TAB | ⇩ + TAB |
Grid Operations Shortcuts
Shortcut | Description | Windows | Mac |
---|---|---|---|
Display Insert Dialog box | Displays the Insert dialog box if no whole rows or columns are selected. | CTRL + SHIFT + + | ^ + I |
Insert rows | Inserts a row as long as at least one row is selected. | CTRL + SHIFT + + | ^ + I |
Insert columns | Inserts a column as long as at least one column is selected. | CTRL + SHIFT + + | ^ + I |
Display Delete dialog box | Displays the Delete dialog box if no whole rows or columns are selected. | CTRL + - | ^ + - |
Delete rows | Deletes selected rows. | CTRL + - | ^ + - |
Delete columns | Deletes selected columns. | CTRL + - | ^ + - |
Delete cells | Displays the Delete dialog box if no whole rows or columns are selected. | CTRL + - | ^ + - |
Delete contents of selected cells | Deletes the content of selected cells while leaving formatting intact. | DELETE | FN + DELETE |
Hide columns | Hides columns that intersect the active selection. | CTRL + 0 | ^ + 0 |
Hide rows | Hides rows that intersect the active selection. | CTRL + 9 | ^ + 9 |
Unhide rows | Unhides hidden rows that intersect the active selection. | CTRL +SHIFT + 9 | ^ + ⇧ + 9 |
Unhide columns | Unhides hidden columns that intersect the active selection. | CTRL +SHIFT + 0 | ^ + ⇧ + 0 |
Group rows or columns | Groups selected rows or columns when whole rows or columns are selected. | ALT +SHIFT + ⇨ | ⌘ + ⇧ + K |
Ungroup rows or columns | Ungroups selected rows or columns when whole rows or columns are selected. | ALT +SHIFT + ⇦ | ⌘ + ⇧ + J |
Open Group dialog box | Displays the Group dialog box when whole rows or columns are not selected. | ALT +SHIFT + ⇨ | ⌘ + ⇧ + K |
Open Ungroup dialog box | Displays the Ungroup dialog box when whole rows or columns are not selected. | ALT +SHIFT + ⇦ | ⌘ + ⇧ + J |
Hide or show outline symbols | Toggles the display of outline symbols on the worksheet. Some rows or columns must be grouped. | CTRL + 8 | ^ + 8 |
Zoom in | Zooms in on the current worksheet. | CTRL + ALT + + | ⌥ + ⌘ + + |
Zoom out | Zooms out of the current worksheet. | CTRL + ALT + - | ⌥ + ⌘ + - |
Miscellaneous Shortcuts
Shortcut | Description | Windows | Mac |
---|---|---|---|
Open Spelling dialog box | Displays the Spelling dialog box. | F7 | FN + F7 |
Open Thesaurus dialog box | Displays the Research window. | SHIFT + F7 | FN + ⇧ + F7 |
Open Macro dialog box | Displays the Macro dialog box. | ALT + F8 | FN + ⌥ + F8 |
Open VBA editor | Displays the Visual Basic Editor ("VBA"). | ALT + F11 | FN + ⌥ + F11 |
Duplicate object | Duplicates objects on the worksheet (charts, shapes, smart art, and text boxes). | CTRL + D | ⌘ + D |
Snap to grid | Snaps objects to the Excel grid, including charts, shapes, smart art, and text boxes. | ALT | ⌘ |
Hide or show objects | Displays objects on the worksheet. | CTRL + 6 | ^ + 6 |
Display Modify Cell Style dialog box | Displays the Modify Styles dialog box. | ALT + ' | ⌘ + ⇧ + L |
Display right-click menu | Displays the shortcuts menu that is shown when you right click with the mouse. | SHIFT + F10 | FN + ⇧ + F10 |
Delete comment | Deletes a comment in the worksheet. | SHIFT + F10 + D | FN + SHIFT + F10 |
Display control menu | Displays the control menu for the main Excel window. | ALT + SPACE | None available. |