Create a new workbook | Ctrl + N |
Open an existing workbook | Ctrl + O |
Save a workbook/spreadsheet | Ctrl + S |
Close the current workbook | Ctrl + W |
Close Excel | Ctrl + F4 |
Move to the next sheet | Ctrl + PageDown |
Move to the previous sheet | Ctrl + PageUp |
Go to the Data tab | Alt + A |
Go to the View tab | Alt + W |
Go the Formula tab | Alt + M |
Edit a cell | F2 |
Copy and paste cells | Ctrl + C, Ctrl + V |
Italicize and make the font bold | Ctrl + I, Ctrl + B |
Center align cell contents | Alt + H + A + C |
Fill color | Alt + H + H |
Add a border | Alt + H + B |
Remove outline border | Ctrl + Shift + _ |
Add an outline to the select cells | Ctrl + Shift + & |
Move to the next cell | Tab |
Move to the previous cell | Shift + Tab |
Select all the cells on the right | Ctrl + Shift + Right arrow |
Select all the cells on the left | Ctrl + Shift + Left Arrow |
Select the column from the selected cell to the end of the table | Ctrl + Shift + Down Arrow |
Select all the cells above the selected cell | Ctrl + Shift + Up Arrow |
Select all the cells below the selected cell | Ctrl + Shift + Down Arrow |
Add a comment to a cell | Shift + F2 |
Delete a cell comment | Shift + F10 + D |
Display find and replace | Ctrl + H |
Activate the filter | Ctrl + Shift + L |
Alt + Down Arrow | |
Insert the current date | Ctrl + ; |
Insert current time | Ctrl + Shift + : |
Insert a hyperlink | Ctrl + k |
Apply the currency format | Ctrl + Shift + $ |
Apply the percent format | Ctrl + Shift + % |
Go to the “Tell me what you want to do” box | Alt + Q |
Select the entire row | Shift + Space |
Select the entire column | Ctrl + Space |
Delete a column | Alt+H+D+C |
Delete a row | Shift + Space, Ctrl + – |
Hide selected row | Ctrl + 9 |
Unhide selected row | Ctrl + Shift + 9 |
Hide a selected column | Ctrl + 0 |
Unhide a selected column | Ctrl + Shift + 0 |
Group rows or columns | Alt + Shift + Right arrow |
Ungroup rows or columns | Alt + Shift + Left arrow |
Group pivot table items | Alt + Shift + Right arrow |
Ungroup pivot table items | Alt + Shift + Left arrow |
Hide pivot table items | Ctrl + – |
Create a pivot chart on the same sheet | Alt + F1 |
Create a pivot chart on a new worksheet | F11 |