Top 40 Microsoft Excel Keyboard Shortcuts.
Microsoft Excel is a versatile software designed to help anyone who deals with spreadsheets and data professionally or in everyday life. It allows you to organize and store your data and perform complex mathematical calculations using formulas and functions. What’s even cooler is that Excel can also help you visualize your data and projects with pie charts, Gantt charts, flow charts, and just about every type of chart you can imagine.
Microsoft Excel was originally designed for data entry, but the software has since expanded to accommodate everything from accounting, task management, and financial modeling to event programming. This means that it is not the easiest software to use. To work effectively in Excel, you need to use keyboard shortcuts, and that’s what we’ll be focusing on in this article.
Why Do You Need Keyboard Shortcuts?
Even if you know what Microsoft Excel is and have used it extensively in the past, you might still be surprised by all the features and shortcuts you can use to get things done quickly and efficiently. Excel has hundreds of keyboard shortcuts and shortcuts, but don’t worry, you don’t have to memorize them all.
You will use some Excel keyboard shortcuts more than others. So, let’s focus on the most important ones that you will need on a daily basis.
Commonly Used Excel Shortcuts
You are probably familiar with some keyboard shortcuts as they are commonly used in most Windows 10/11 and Microsoft Office applications. However, here is a helpful table with the most commonly used Excel keyboard shortcuts that you need to start using to quickly improve your spreadsheet prowess.
Ctrl+XCutCtrl+ZUndoCtrl+YRedoCtrl+BBoldCtrl+IItalicizeCtrl+UUnderline Alt +HGo to Home tabDelete (or DEL)Delete content in cellCtrl+OOpen workbook Ctrl+WClose workbookAlt+H+HSelect cell fill color
These shortcuts are handy, and you should get used to using them not only in Excel, but also in Microsoft Word, Internet browsers, or any other application that you often use for work or play.
Pivot Table Shortcuts in Excel
The pivot table is a powerful tool in Excel. It can sum selected rows and columns of a spreadsheet, or even reorganize them. Pivot tables are handy if you have long rows of data that need to be summarized, and they also allow you to compare your data. If you find yourself using a lot of PivotTables, start using the keyboard shortcuts below regularly.
Right-click to access the context menu for the selected row, column, or cell.
Ctrl +DDelete tableCtrl+MMove tableCtrl+RRename table
Alt+Shift+Right ArrowGroup selected PivotTable itemsAlt+Shift+Left ArrowUngroup selected PivotTable items.
Now that you know the basic keyboard shortcuts, let’s focus on other Excel keyboard shortcuts that will increase your productivity and speed.
Shortcuts for Navigating in Excel
Navigate Excel and switch between worksheet tabs faster using the following keyboard shortcuts.
Ctrl+Page UpPress this command combination to switch worksheet tabs to the right.Ctrl+ Page DownThis command will switch the worksheet tabs to the left.Ctrl+BackspaceThis keyboard shortcut will show you which cell is active. F11 The F11 key will create a new diagram. This is a great shortcut that will allow you to skip all Excel toolbar navigation.Ctrl+FPress this keyboard shortcut to quickly access the search function.
Ctrl+QQuick access to the help function in Excel.Ctrl+arrow keyGo to the last filled cell in the direction of the arrow key. For example, Ctrl+Right Arrow will move you to the last cell on the right, and Ctrl+Down Arrow will select the last cell below. Ctrl+F12This command quickly opens the Open File dialog box and allows you to access another book.Ctrl+F1This key combination toggles the display of feeds.
Shortcuts for Selecting Items in Excel
Save time by selecting columns and rows faster by using the following keyboard shortcuts instead of clumsy mouse movements.
Ctrl+SpacePress Ctrl+Space to select an entire column. You no longer need to use the heading and navigate with the mouse.Shift+SpacePress Shift+Space to select the entire line.Ctrl+ 0This simple shortcut will hide all selected columns.
Shortcuts for Functions and Formulas in Excel
Excel mainly consists of formulas and functions. Stop typing them variable by variable and boost your productivity with the keyboard shortcuts below.
Ctrl+â€™Switch between showing all formulas on the worksheet. Alternatively, you can click a cell to display the formula in the formula bar.Ctrl+Alt+F9Use this keyboard shortcut when you need to calculate all the formulas in all your active workbooks. Ctrl+Shift+$To automatically convert a cell to currency, select it and press Ctrl+Shift+$. It can also work with multiple cells while they are selected.Ctrl+Shift+%This keyboard shortcut applies a percentage format to the selected cell.Alt+ =This label will automatically insert the SUM() function. This is arguably the most used formula in Excel and needs to have a shortcut.
The Sum() function automatically sums data across multiple columns and rows. Just be sure to select one extra column on the right and one extra row at the bottom. Excel will use them to display the summary data.Alt+H+O+IThis keyboard shortcut is a combination of keystrokes that executes a function in sequence. First, press Alt + H to select the Home tab, then press O while holding the Alt key to select the formatting menu. Finally, press I to automatically fit the column width.
Remember to hold your finger on the Alt key as you press each letter.Ctrl+[This keyboard shortcut allows you to see which cells are referenced by other cells. This is especially useful if you are working with complex formulas.Ctrl+Shift+JUse this keyboard shortcut to see a list of all the constants in your worksheet. Alt+MOpen the formulas tab.Shift+F3Press Shift+F3 to open the insert function window to insert a function.
Time and Date Shortcuts in Excel
Instantly log various actions using the time and date keyboard shortcuts below.
Ctrl+Shift+#This keyboard shortcut will allow you to change the date format.Ctrl+Shift+@
Pressing a combination of these keys will allow you to quickly access the style of the time of day. From here, you can go ahead and add it to the selected cell. Ctrl+;Would you like to add the current date to your Excel spreadsheet? Just click this shortcut to quickly add it.Ctrl+Shift+;This function will place the exact current time in the selected cell.
Editing Shortcuts in Excel
Editing cells, rows, columns, and comments can be very time consuming. Increase speed with the following keyboard shortcuts.
Ctrl+1Open the cell formatting dialog box. This shortcut will allow you to make changes to the appearance of a cell.Ctrl+KIf you select a cell or data entered in a cell and use this shortcut, a hyperlink box will open. Copy and paste the hyperlink into the box (using the copy/paste keyboard shortcuts for extra practice).F2This should be one of the most used Excel keyboard shortcuts as it will allow you to edit the cell . Use it to quickly make changes.F4The F4 key will repeat your last action. Whether it’s a formula or editing, this key will copy the action and save you a lot of time.Ctrl+Plus (+)Quickly insert new rows and columns with the Ctrl key shortcut. Ctrl+minus (-)Press Ctrl+- to delete a row or column.Shift+F2Insert a comment or edit an existing comment in the selected cell.
Formatting Shortcuts in Excel
Formatting Excel data makes it readable and presentable. But that doesn’t mean you have to waste time, so start using the keyboard shortcuts below.
Ctrl+Shift+&This Excel keyboard shortcut quickly applies borders to the selected cell. This is very useful if you want your spreadsheet to be neatly organized and look attractive.Ctrl+Shift+_To quickly remove borders, select the desired cells and press this keyboard shortcut. . Ctrl+Shift+~This keyboard shortcut will give the selected cell or group of cells a general format.
Keep in mind that the general format is the default format, meaning you get the numbers you enter and nothing else.Ctrl+Shift+^This command applies exponential format to the cell you select. Ctrl+Shift+!This keyboard shortcut applies the comma formatting style to the selected cell. For example, when a number in a cell is over 1000, this command will display it with a comma as 1000. Use this shortcut to visualize numbers.
Whether you’re a spreadsheet wizard or a one time blue moon user of Excel, knowing a few shortcuts will make your job a lot easier and take less time. Share your favorite Excel keyboard shortcuts and keyboard shortcuts in the comments below!
Top 40 Microsoft Excel Keyboard Shortcuts
Top 40 Microsoft Excel Keyboard Shortcuts