40 Most Useful Excel Shortcuts That You Should Know In 2023

by Jake Wyatt

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.DESCRIPTIONSHORTCUT (PC)
1Create a new workbookCtrl + N
2Open an existing workbookCtrl + O
3Save the active workbookCtrl + S
4Close the active workbook.Ctrl + W
5Copy contents of the selected Cells to the clipboardCtrl + C
6Cut contents of the selected Cells to the clipboardCtrl + X
7Paste content on the clipboard into the selected cellCtrl + V
8Save asF12
9Undo your last actionCtrl + Z
10Redo previous actionCtrl + Y
11Move to the next sheetCtrl +
12Move to the previous sheetCtrl +
13PrintCtrl + P
14Show/Hide Excel ribbonCtrl + F1
15Switch to the next Excel workbook opened.Ctrl + Tab
16Move to the beginning of a worksheet (First Cell)Ctrl + Home
17Move to the last used cell of the current worksheetCtrl + End
18Select the entire columnCtrl + Space
19Select the entire rowShift + Space
20Edit a cellF2
21Select all the cells on the rightCtrl + Shift +
22Select all the cells on the leftCtrl + Shift +
23Select the column from the selected cell to the end of the tableCtrl + Shift +
24Select all the cells above the selected cellCtrl + Shift +
25Select all the cells below the selected cellCtrl + Shift +
26Insert the current dateCtrl + ;
27Insert the current timeCtrl + Shift + ;
28Apply the currency formatCtrl + Shift + $
29Apply the percentage formatCtrl + Shift + %
30Hide selected rowCtrl + 9
31Apply comma formattingCtrl + Shift + !
32Place borders around the selected cellsCtrl + Shift + &
33Unhide selected rowCtrl + Shift + 9
34Hide a selected columnCtrl + 0
35Unhide a selected columnCtrl + Shift + 0
36Close and save active workbookAlt + F + C
37Export workbookAlt + F + E
38Zoom inCtrl + Alt + +
39Zoom outCtrl + Alt +
40Close ExcelCtrl + F4

Excel Keyboard Shortcuts for Mac

No.DESCRIPTIONSHORTCUT (Mac)
1Create a new workbook + N
2Open an existing workbook + O
3Save the active workbook + S
4Close the active workbook. + W
5Copy contents of the selected Cells to the clipboard + C
6Cut contents of the selected Cells to the clipboard + X
7Paste content on the clipboard into the selected cell + V
8Save as + + S
9Undo your last action + Z
10Redo previous action + Y
11Move to the next sheet +
12Move to the previous sheet +
13Print + P
14Show/Hide Excel ribbon + + R
15Switch to the next Excel workbook opened. + `
16Move to the beginning of a worksheet (First Cell)Fn + +
17Move to the last used cell of the current worksheetFn + +
18Select the entire column + Space
19Select the entire row + Space
20Edit a cell + U
21Select all the cells on the right + +
22Select all the cells on the left + +
23Select the column from the selected cell to the end of the table + +
24Select all the cells above the selected cell + +
25Select all the cells below the selected cell + +
26Insert the current date + ;
27Insert the current time + ;
28Apply the currency format + + $
29Apply the percentage format + + %
30Hide selected row + 9
31Apply comma formatting + + !
32Place borders around the selected cells + + 0
33Unhide selected row + + 9
34Hide a selected column + 0
35Unhide a selected column + + 0
36Zoom in + + +
37Zoom out + +
38Close Excel + Q

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.

You may also like

Wavy trends black background
We are dedicated to giving you the latest Tech Hacks with sortable collections of entertainment, infographics, life hacks, tips and tricks, movies and news that can provide a daily dose of current events from around the Globe 🌍

NEWSLETTER

Latest Posts

©2023 WavyTrends | All Right Reserved. Designed and Developed by Webchef

Adblock Detected

Please support us by disabling your AdBlocker extension from your browsers for our website.