Photo: Kam Pratt

What is Shift F4 for?

When Shift + F4 is used, it will use whatever qualifiers (values, formatting, etc.) were last entered into the Find and Replace Window to find the next cell with those criteria. Adding Ctrl to Shift + F4 will make the find go in reverse to locate the previous cell.

excelcampus.com - 5 Keyboard Shortcuts for the F4 Key in Excel

What happens if you hit Alt F4?

Pressing the Alt and F4 keys together is a keyboard shortcut to close the currently active window. For example, if you press this keyboard shortcut...

Last updated Feb 14, 2021

What is the price of a flute?

Beginner flutes usually range in cost from $500 to $1000. Intermediate, or step-up flutes usually cost $1,400 to $2,500 and entry level pro flutes...

Last updated Feb 4, 2021

Join almost HALF A MILLION Happy Students Worldwide

Promotion

Bottom Line: Learn 5 different shortcuts that use the F4 key in both the Windows & Mac versions of Excel.

Skill Level: Beginner

Video Tutorial

Download the Excel File

The Excel workbook that I use in the video can be downloaded here:

Using F4 for a Variety of Shortcuts

The F4 key has a lot of different uses in Excel. All of these shortcuts can save you time with common daily tasks. So make sure to share them with your friends & co-workers as well. Before we dive into the five shortcuts that use the F4 key, I want to mention that if you are using a laptop, you might have to hold down the Function key, often abbreviated Fn , in conjunction with the F4 key since those F keys can double for other purposes on your keyboard. Here's a post on the best keyboards for Excel shortcuts that explains what to look for in both a laptop and regular keyboard.

1. Repeat Last Action

Windows: F4 (or Ctrl + Y )

Mac: Cmd + Y

When you select a cell and hit F4 , your last action will be repeated. That includes formatting, inserting or deleting rows, and making changes to shapes. In the image below, I highlighted cell A6 in yellow, then selected cell A8 and hit F4 . The cell immediately was changed to yellow because it repeated the last thing I did. It's important to note that F4 only repeats the last single action you took. If you made multiple formatting changes to a cell like fill color, font color, and borders, and wanted to apply those changes to other cells, then the Format Painter is a good alternative. I explain how to use the Format Painter in point #11 in this post.

2. Toggle Absolute/Relative References

Windows: F4

Mac: Cmd + T

When writing formulas, any portion of the formula that denotes a cell or range of cells can be made absolute by hitting the F4 key while your cursor is on that cell reference. This means you can use F4 to add $ dollar symbols in front of the column letters and row numbers, $A$12. By continuing to hit the F4 key, you can toggle or cycle through mixed references (column absolute while row relative, or row absolute while column relative), and then back again to a completely relative reference. Starting with the reference A17, here are the references that will be created each time you hit F4:

$A$17 A$17 $A17 A17

If you have a range reference (A4:D12), you can first select the text of the entire range reference, then press F4 to apply the absolute/relative references to the entire reference. Or just select the text in one of the cell references to apply it to that portion of the range reference only. The formula being used in the above example is a VLOOKUP formula. If you're interested in learning more about VLOOKUP, you can use this tutorial: VLOOKUP Example Explained at Starbucks or our VLOOKUP Tutorial on YouTube.

Which is better bleach or hydrogen peroxide?

Bleach is an economical, all-round disinfectant, but it requires careful handling and dilution for effective use. Hydrogen peroxide has a kinder...

Last updated May 10, 2020

How do I claim key protection?

Key Replacement Cover: How to Claim? Inform the insurance company. ... In case of theft, a Police FIR is necessary to register the claim. You can...

Last updated Dec 4, 2019

Promotion

Windows: Shift + F4 for next and Ctrl + Shift + F4 for previous Mac: Cmd + G for next and Cmd + Shift + G for previous When Shift + F4 is used, it will use whatever qualifiers (values, formatting, etc.) were last entered into the Find and Replace Window to find the next cell with those criteria. Adding Ctrl to Shift + F4 will make the find go in reverse to locate the previous cell.

Click to enlarge

This means that you can close the Find Window and use these shortcuts to find and select the next/previous match on the sheet or workbook. It saves you from having to click back to the Find Window to navigate to each matching cell. Checkout the video above to see it in action.

4. Close Current Workbook

Windows: Ctrl + F4 (or Ctrl + W )

Mac: Cmd + W

If you'd like to use your keyboard instead of your mouse to close out the workbook you are using, you can hit Ctrl + F4 . You may be prompted to save your workbook if you haven't done so recently. Excel and any other open workbooks will remain open.

5. Close Excel

Windows: Alt + F4

Mac: Cmd + Q

If you want to close out of Excel completely, including any open workbooks, this is the shortcut to use. It's the same as clicking on the X in the upper right corner. Again, you may be prompted to save your work before it closes. On a related note, here are 3 Tips to Save and Close All Open Excel Workbook Files + Macro.

Conclusion

There are five shortcuts that should definitely save some time with common Excel tasks. Did you know all of these? Did you learn something new? Please leave a comment below to let us know and/or any additional tips you have for F4. And feel free to share this post with a friend or co-worker if you feel like getting a virtual high-five. 🙂

excelcampus.com - 5 Keyboard Shortcuts for the F4 Key in Excel

Which is better to learn piano or keyboard?

If they are interested in playing modern music at a variety of locations, then a keyboard might be the better choice. Alternatively, if they are...

Last updated May 8, 2019

What were Turkish bows made of?

Turkish bow The construction is similar to that of other classic Asiatic composite bows, with a wooden core (maple was most desirable), animal horn...

Last updated Sep 9, 2019

Promotion

Why is Steinway so popular?

Theodore Steinway's technical skills ensured that the growing company was in good hands. Having high caliber pianists choose your piano over others...

Last updated Nov 29, 2020

Promotion

What is the hardest classical instrument to learn?

The 7 hardest instruments to learn, play, and master Oboe. Even if you don't think you know what an oboe sounds like, you've heard it more than you...

Last updated Dec 26, 2020