Last updated on 10th January, 2023
Excel is a Microsoft software that uses spreadsheets to arrange numbers and data using formulas and functions.
Most of us use Microsoft Excel every day, whether it’s to create a chart, analyze data, make financial analysis or run a report to present at the upcoming team meeting.
You can organize your data more easily because Excel offers a ton of built-in tools. We’ve compiled a list of 40 Microsoft Excel keyboard shortcuts for both Windows and Mac. Even though you can perform all of these actions manually, knowing these shortcuts will allow you to focus on the things that really matter by saving you time. You may also be interested the Microsoft Word features in our previous article.
Mac user should kindly skip to this section
Excel Shortcuts for PC (Windows)
No. | DESCRIPTION | SHORTCUT (PC) |
---|---|---|
1 | Create a new workbook | |
2 | Open an existing workbook | |
3 | Save the active workbook | |
4 | Close the active workbook. | |
5 | Copy contents of the selected Cells to the clipboard | |
6 | Cut contents of the selected Cells to the clipboard | |
7 | Paste content on the clipboard into the selected cell | |
8 | Save as | |
9 | Undo your last action | |
10 | Redo previous action | |
11 | Move to the next sheet | |
12 | Move to the previous sheet | |
13 | ||
14 | Show/Hide Excel ribbon | |
15 | Switch to the next Excel workbook opened. | |
16 | Move to the beginning of a worksheet (First Cell) | |
17 | Move to the last used cell of the current worksheet | |
18 | Select the entire column | |
19 | Select the entire row | |
20 | Edit a cell | |
21 | Select all the cells on the right | |
22 | Select all the cells on the left | |
23 | Select the column from the selected cell to the end of the table | |
24 | Select all the cells above the selected cell | |
25 | Select all the cells below the selected cell | |
26 | Insert the current date | |
27 | Insert the current time | |
28 | Apply the currency format | |
29 | Apply the percentage format | |
30 | Hide selected row | |
31 | Apply comma formatting | |
32 | Place borders around the selected cells | |
33 | Unhide selected row | |
34 | Hide a selected column | |
35 | Unhide a selected column | |
36 | Close and save active workbook | |
37 | Export workbook | |
38 | Zoom in | |
39 | Zoom out | |
40 | Close Excel |
Excel Keyboard Shortcuts for Mac
No. | DESCRIPTION | SHORTCUT (Mac) |
---|---|---|
1 | Create a new workbook | |
2 | Open an existing workbook | |
3 | Save the active workbook | |
4 | Close the active workbook. | |
5 | Copy contents of the selected Cells to the clipboard | |
6 | Cut contents of the selected Cells to the clipboard | |
7 | Paste content on the clipboard into the selected cell | |
8 | Save as | |
9 | Undo your last action | |
10 | Redo previous action | |
11 | Move to the next sheet | |
12 | Move to the previous sheet | |
13 | ||
14 | Show/Hide Excel ribbon | |
15 | Switch to the next Excel workbook opened. | |
16 | Move to the beginning of a worksheet (First Cell) | |
17 | Move to the last used cell of the current worksheet | |
18 | Select the entire column | |
19 | Select the entire row | |
20 | Edit a cell | |
21 | Select all the cells on the right | |
22 | Select all the cells on the left | |
23 | Select the column from the selected cell to the end of the table | |
24 | Select all the cells above the selected cell | |
25 | Select all the cells below the selected cell | |
26 | Insert the current date | |
27 | Insert the current time | |
28 | Apply the currency format | |
29 | Apply the percentage format | |
30 | Hide selected row | |
31 | Apply comma formatting | |
32 | Place borders around the selected cells | |
33 | Unhide selected row | |
34 | Hide a selected column | |
35 | Unhide a selected column | |
36 | Zoom in | |
37 | Zoom out | |
38 | Close Excel |
We sincerely hope that these tips will be helpful to you. By consistently using Excel, you should be able to learn these shortcut keys. Please let us know in the comments if you believe we missed anything or if you have any recommendations.