Regardless of having labored in Microsoft Excel for many years, I am at all times studying new methods to hurry up my workflow. Particularly, I’ve stumbled upon some keyboard shortcuts over the previous couple of years that I now use each day, and I want I might identified about them sooner!

1

F2: Enter a Cell’s Edit Mode

Whenever you enter a formulation into Excel and press Enter, the cell shows the consequence, and the formulation bar shows how you bought there. On this instance, cell C1 exhibits the results of a SUM formulation that provides the worth in cell A1 to the worth in cell B1, whereas the formulation bar reveals the formulation itself.

Let’s suppose you later notice that you simply truly wanted to multiply the values in cells A1 and B1 reasonably than add them collectively. To do that, you may edit the formulation within the formulation bar, or double-click cell C1 and amend the formulation there. Nevertheless, each of those strategies (which I beforehand believed had been the solely strategies!) require you to make use of your mouse, thus disrupting your workflow and requiring you to maneuver away out of your keyboard.

As an alternative, use the Arrow keys to navigate to the cell you need to edit, and press F2. This prompts the edit mode for that cell, which means you should utilize the Arrow keys once more to maneuver alongside the formulation, and make the required adjustments utilizing solely your keyboard.

Whenever you’ve completed making the mandatory adjustments, press Ctrl+Enter to finalize the consequence and hold that cell energetic, with the intention to double-check the formulation within the formulation bar.

2

Ctrl+Shift+V: Paste Values Solely

If you happen to use Ctrl+V when pasting information from one other supply—like an online web page, Phrase doc, electronic mail, or one other workbook or worksheet—into Excel, in addition to pasting the values, this system adopts the supply formatting, together with any background colours, textual content colours, fonts, daring, italics, and so forth.

On this instance, once I pasted the primary 5 rows of a desk from a Wikipedia page utilizing Ctrl+V, the cells had been formatted inconsistently, the nationwide flags lined the nation names, and a number of the textual content was hyperlinked. In consequence, I needed to take additional steps to take away this formatting and tidy up the info.

As an alternative, Excel permits you to paste the copied content material into your worksheet whereas preserving the vacation spot formatting. There are numerous old-school methods to do that, resembling clicking the “Paste” drop-down menu within the Dwelling tab on the ribbon and choosing “Values,” or utilizing the unique keyboard shortcut, Ctrl+Alt+V > V.

Nevertheless, in 2022, Microsoft launched an easier keyboard shortcut to stick the values solely: Ctrl+Shift+V. Discover how utilizing this shortcut pastes the Wikipedia information as unformatted values with out the nationwide flags.

In consequence, I solely have to make one or two small adjustments to tidy up the info.

Additionally, I can choose any cell within the information and press Ctrl+T to transform the main points right into a formatted Excel desk.

In addition to copying information from a web site and pasting it into Excel, you may also import online tables utilizing the Knowledge tab on the ribbon.

3

Ctrl+Shift+L: Filter Columns

Filters are a useful instrument in Excel to show solely the rows that meet sure standards you set, making information scouring and evaluation way more easy.

Whether or not you are working with information formatted as a desk or a sequence of contiguous information in unformatted cells, choose any cell within the vary, and press Ctrl+Shift+L so as to add filter buttons to the primary row of the info.

Then, press Ctrl+As much as soar to the header row containing the filters, use the Left and Proper Arrow keys to navigate to the column you need to filter, and press Alt+Right down to launch the filtering choices.

To reset all of the filters, choose any cell within the vary, and press Ctrl+Shift+L twice. The primary press removes the filter buttons and, thus, any filters utilized, and the second press re-adds the filter buttons to the primary row of your information.

4

F4: A Versatile Keyboard Shortcut

In all probability my favourite and most used Microsoft Excel keyboard shortcut is the impressively versatile F4.

Toggling Between Reference Sorts in Formulation

First, F4 permits you to toggle between relative, absolute, and combined references in a formulation to repair or unfix references to sure cells, columns, or rows. On this instance, I pressed F4 after typing the reference to cell A2 in my formulation so as to add the greenback symbols ($), forcing Excel to repair this reference once I finally copy the formulation to different cells.

Repeating the Earlier Motion

Second, you should utilize F4 to repeat the final motion you carried out in your worksheet. Within the screenshot under, after manually lowering the width of column B by clicking and dragging the fitting aspect of the column header to the left, I chosen cell D1 and pressed F4, and repeated this course of for the opposite clean columns to verify they had been all resized constantly.

You need to use F4 to repeat any motion in Excel, like pasting information, formatting a cell, deleting rows or columns, and lots of extra.

Repeating a Search

Third, Shift+F4 permits you to repeat the final search you carried out. Begin by urgent Ctrl+F to open the Discover tab of the Discover and Exchange dialog field.

Then, after typing the related search standards within the Discover What subject, you’ll be able to press Enter repeatedly to seek out every cell that matches these standards.

Nevertheless, if you have to make guide adjustments to your spreadsheet between every consequence utilizing solely your keyboard, you will have to press Esc to shut the dialog field, make your adjustments, after which press Ctrl+F to launch it once more.

As an alternative, as soon as you have typed the search question, press Esc to shut the dialog field, then press Shift+F4 to repeat the search to seek out the subsequent cell that meets the factors. Every time you press Shift+F4 thereafter, the search continues as if the dialog field had been nonetheless open, even when you make important adjustments to your spreadsheet. Alternatively, press Ctrl+Shift+F4 to maneuver again to the earlier search consequence.

Closing the Excel Workbook or Window

A fourth and remaining use of F4 turns out to be useful on the finish of the workday, once you’re prepared to modify off and go dwelling:

• Ctrl+F4 closes the energetic workbook, however leaves the Excel window open. If the workbook is not saved, you will see the Save As dialog field first.
• Alt+F4 closes the energetic Excel window altogether.

5

Ctrl+1: Format Cells

Ctrl+1 in Microsoft Excel launches the Format Cells dialog field, which is the place you’ll be able to change the quantity format, alignment, font, border, fill, and safety properties of a single cell or vary of cells.

The choice routes to the identical end result are to right-click a cell and choose “Format Cells,” or search the ribbon for the formatting instrument you need to apply—each of which take considerably extra time than this easy-to-remember keyboard shortcut.

After choosing the cell or cells you need to format and urgent Ctrl+1, use the Left and Proper Arrow keys to leap between the tabs within the Format Cells dialog field.

Then, as soon as you have landed on the related tab, press Tab to leap between the choices. On this case, I need to format the chosen cells in order that their values are currencies, so after navigating to the Quantity tab and urgent Tab, I am going to use the Down Arrow key to pick out “Foreign money.” Then, I am going to press Tab once more to navigate via and regulate the forex choices.

Then, as soon as I’ve chosen all of the related formatting for these cells, I can press Enter to avoid wasting the adjustments and shut the dialog field.

6

Spacebar: Test and Uncheck Checkboxes

The ultimate keyboard shortcut that I could not reside with out in the present day—having found it simply over a yr in the past—is the Spacebar.

You might need come to this text on the lookout for groundbreaking keyboard shortcuts you have by no means seen earlier than—however bear with me: the Spacebar is an actual time-saver for anybody utilizing checkboxes of their spreadsheet.

Somewhat than utilizing your mouse to laboriously examine and uncheck checkboxes in Excel, use the Arrow keys to navigate a cell containing a checkbox, and press Spacebar so as to add or take away the checkmark.

Likewise, if you choose a number of cells containing a checkbox (utilizing Shift+Arrow keys) and press the Spacebar, they will all be checked and unchecked on the identical time.

To delete a checkbox out of your worksheet, choose the cell the place the checkbox is positioned, and press Delete. In case your checkbox is checked, urgent Delete will first uncheck the checkbox, and urgent it once more will take away it altogether.

---

The shortcuts I’ve mentioned on this information are only a few of the various Microsoft Excel keyboard shortcuts you’ll be able to be taught to finish your work extra rapidly and transfer one step nearer to being an influence person. You may also obtain, print, and pin our printable cheat sheet to your discover board, with the intention to entry them at any time when you have to!