| Action |
Shortcut |
Description |
| Save |
CTRL + S |
Highlights all data |
| Highlight All |
CTRL + A |
Highlights all data |
| Copy |
CTRL + C |
Copies selected cell or range of cells |
| Cut |
CTRL + X |
Cuts selected cell or range of cells |
| Paste |
CTRL + V |
Pastes cell or range of cells |
| Paste values |
ALT + H + V + V |
Pastes only the values from a range of cells (excludes formulas, formatting, etc. |
| Undo |
CTRL + Z |
Deletes the data you have selected and allows you to edit the cell you have selected |
| Redo |
CTRL + Y |
Deletes the data you have selected and allows you to edit the cell you have selected |
| Search |
ALT + Q |
Allows you to search for a specific functionality inside of Excel. |
| Action |
Shortcut |
Description |
| Edit cell |
F2 |
Edit the cell you have selected |
| Delete |
DELETE |
Deletes the data that you have selected |
| Delete and Edit |
BACKSPACE |
Delete the contents of the selected cell and begin editing. |
| Lock cell reference |
F4 |
When editing a cell reference, pressing F4 once will create an absolute cell reference. Press it a second time, yoy get a mixed reference with the locked row. Press it a third time, you will get a mixed reference with a locked column. Press it a fourth time, and your cell reference will return to being a relative reference. |
| Cancel cell edits |
ESC |
Deletes the edits to your current cell and reverts the contents back to it original state. |
| Finish editing but stay on cell |
CTRL + ENTER |
Finishes editing the current cell but keeps your cursor on that cell. |
| Insert datestamp |
CTRL + : |
Inserts datestamp into the cell you are editing. |
| Insert timestamp |
CTRL + SHIFT + : |
Inserts timestamp into the cell you are editing. |
| AutoSum |
ALT + = |
Automatically sums data adjacent to your cell. |
| AutoSum to Count Numbers (COUNT) |
ALT + M + U + C |
Automatically COUNT data adjacent to your cell. |
| AutoSum to Average Numbers (AVERAGE) |
ALT + M + U + A |
Automatically AVERAGE data adjacent to your cell. |
| AutoSum to find the Min value (MIN) |
ALT + M + U + I |
Automatically find the MIN of the data adjacent to your cell. |
| AutoSum to find the Max Value (MAX) |
ALT + M + U + M |
Automatically find the MIN of the data adjacent to your cell. |
| View result of logical test |
F9 |
When you highlight a logical test inside of a logical function, Excel will display what the result of the expression. |
| Action |
Shortcut |
Description |
| Ribbon access key |
ALT |
Access ribbon functionalities using hotkeys. |
| Bold |
CTRL + B |
Bold the selected data. |
| Italic |
CTRL + I |
Italicize the selected data. |
| Bold |
CTRL + U |
Underline the selected data. |
| Delete cell / row / column |
CTRL + – |
Access ribbon functionalities using hotkeys. |
| Insert cell / row / column |
CTRL + SHIFT + + |
Access ribbon functionalities using hotkeys. |
| Hide column |
CTRL + 0 |
Hides selected column. |
| Hide row |
CTRL + 9 |
Hides selected row. |
| Change font size |
ALT + H + F + S |
Opens the Excel dialogue to change the font size. |
| Merge and Center |
ALT + H + M + C |
Merges and centers the contents across the selected cells. |
| Unmerge |
ALT + H + M + U |
Unmerges the selected cells. |
| Autofit column width |
ALT + H + O + I |
Autofits the column width of each column based on cell contents. |
| Autofit row height |
ALT + H + O + A |
Autofits the row height of each row based on cell contents. |
| Set column width |
ALT + H + O + W |
Opens dialogue that allows you to hardcode column width. |
| Set row height |
ALT + H + O + H |
Opens dialogue that allows you to hardcode row height. |
| Top align |
ALT + H + A + T |
Align text to the top of the cell. |
| Middle align |
ALT + H + A + M |
Align text to the middle of the cell. |
| Bottom align |
ALT + H + A + B |
Align text to the bottom of the cell. |
| Left align |
ALT + H + A + L |
Align text to the left of the cell. |
| Center align |
ALT + H + A + C |
Align text to the center of the cell. |
| Right align |
ALT + H + A + R |
Align text to the right of the cell. |
| Bottom border |
ALT + H + B + O |
Insert border on the bottom of the selected cell. |
| Top border |
ALT + H + B + P |
Insert border at the top of the selected cell. |
| Insert hyperlink |
CTRL + K |
Insert hyperlink on selected cell. |
| Format as percentage |
ALT + H + P |
Format selected cell as a percentage. |
| Action |
Shortcut |
Description |
| Freeze top row |
ALT + W + F + R |
Freezes the top row of your Excel worksheet. |
| Unfreeze panes |
ALT + W + F + F |
Unfreezes all of the panes, rows, or columns in your worksheet. |
| Freeze panes |
ALT + W + F + F |
Freezes everything above and to the left of your cursor. If you highlight a row and use this shortcut, it will freeze all of the rows above your highlighted row. If you highlight a column and use this shortcut, it will freeze all of the columns to the left of your highlighted column. |
| Insert filters |
CTRL + SHIFT + L |
Inserts filters onto the data in your Excel workbook. |
| Sort by a custom list |
ALT + H + S + U | Opens the dialogue that allows you to specify a “custom” sort where you can define the order that records appear. |
| Select item in filter |
SPACE or ENTER |
Selects the action or item while navigating through a filter. |
| Open filter |
ALT + ↓ |
Opens the filter in the column that you are hovering. |
| Open filter and search |
ALT + ↓ → E |
Opens the filter in the column that you are hovering and brings you to the search bar inside of the filter. |
| Open filter and clear |
ALT + ↓ → C |
Opens the filter in the column that you are hovering and clears any pre-existing filters on that column. |
| Open filter and sort A-Z, ascending, or oldest to newest |
ALT + ↓ → S |
Opens the filter in the column that you are hovering and sorts A-Z for categorical data, ascending for numerical data, or oldest to newest for date data. |
| Open filter and select data type specific filters |
ALT + ↓ → F |
Opens the filter in the column that you are hovering and brings you to the search bar inside of the filter. |
| Open filter and sort Z-A, descending, or newest to oldest |
ALT + ↓ → O |
Opens the filter in the column that you are hovering and sorts Z-A for categorical data, descending for numerical data, or newest to oldest for date data. |
