F4 No Longer Changes Cell References

by Allen Wyatt
(last updated January 20, 2020)


Hazel recently bought a new computer that uses Windows 10. She has found that she can no longer use F4 as a method of toggling a cell reference through the absolute/relative settings. Instead, F4 opens a sidebar about projecting to a second monitor. As Hazel only has one monitor, but lots of requirements to set cell references to and from absolute, this is driving her crazy. She would like F4 to work as it traditionally did in Excel.

Testing on a Windows 10 system indicates that the F4 key still cycles through absolute/relative versions of references. There is a caveat, however: You need to make sure that you are in "edit mode" when it comes to using F4 with formulas. In other words, select the cell you want, press F2 to enter edit mode, use the left and right arrow keys to move through the formula, and press F4 whenever you want to cycle a reference through various permutations of absolute and relative notation.

If the F4 key still doesn't work as you expect, then it is a good bet that you are using a laptop computer or a super-duper, multi-function keyboard with your desktop system. On these types of keyboards the function keys typically do special things, such as adjust your volume, adjust screen brightness, etc. To get to the normal operation of a particular function key, look for a key labeled something like FN (short for "function"). Hold down that key as you press the F4 key, and it should work as you expect.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (13235) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, and Excel in Office 365.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company. ...


Resetting Excel Menus

Excel allows you to easily change what appears on its menus. If you later want to return to Excel's default menu ...

Discover More

Using AutoShape Connectors

If you add AutoShapes to the drawing canvas, you can use connector lines between those shapes. Here's how to add them to ...

Discover More

Creating a Hierarchy Map of Your Hard Drive

Want to see how the directories and subdirectories in your hard drive are organized? It's easy to do using the directions ...

Discover More

Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!

More ExcelTips (ribbon)

Displaying a Count of Zeros on the Status Bar

Excel allows you to display the results of several common worksheet functions on the status bar. The available functions ...

Discover More

Accessing Stock Information

Do you follow the stock market? If you do and you want to get stock information into a worksheet, there are some new ways ...

Discover More

Restoring the Analysis ToolPak

Add-ins for Excel, such as the Analysis ToolPak, are stored in files on your hard drive that can be deleted. If you ...

Discover More

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.


If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is five more than 5?

2020-10-22 03:30:43


thank you so much, you saved my day and project!!!

2020-10-01 09:58:44

Patricia Radenkovic

I wrote earlier on this topic. Thank you, I have just gotten back the use of my F4 function. I changed the keyboard and mouse back to the wireless ones which came with the computer but it was the F2 function and then F4 which got it back working.

2020-09-29 07:15:15

Patricia R

Dear Mr Wyatt,
I partake in an Excel class with a U3A Inc group in Australia and I have an All-in-One Asus computer (hope to get a new one after this pandemic) but I no longer use the wireless keyboard and mouse. The keyboard and mouse are both wired and old. The keyboard is an old Microsoft Digital Media Keyboard 1.0A and the F4 function key does not work. There is no fn key to hold in conjunction with the F4 key. How can I get back the F4 function, assuming it was there previously.
Other function keys do not work like they did on my work computers (before I retired). Are you able to advise.

2020-07-24 03:56:19

Bikash Debta

Very nice tip. After repeated trials, I thought that there's some issue with the F4 key of my newly purchased Dell Inspiron Laptop. It worked when used with the fn key.

2020-06-07 22:31:34


Thanks a lot

2020-05-18 15:50:37

Timothy Titiloye

Thanks. This helped.

2019-10-26 22:34:58

Lisa B

I cannot thank you enough!

2019-10-21 19:20:53


Thank you so so much!!!

2019-08-29 18:43:49


Thank you so much!

2019-06-05 18:16:12

Shelli Godfrey

Thank you! I was going crazy over this issue!!

2019-04-16 03:55:50


We're currently using MS Office 365 ProPlus - I believe it's basically Excel 2013. The F4 key applies the same formatting that was previously applied to another cell so if I change the back fill colour to yellow, move to another cell and press F4, the current cell back fill is also changed to yellow.
Note that this does not apply multiple formats so if I set backfill to yellow, font style to italic and font colour to red (in that order), F4 on another cell just changes the font to red.

2018-12-04 09:54:20


Good Tips and thanks for the help !! i like it so much

2018-11-30 08:15:10


You just saved me another hour of trying to figure out how this keyboard works!
Thank you good sir

2018-11-21 02:32:27

Saskia Jacobsen

Problem F4: I had the same problem during a trainin where one of the participants had a HP laptop. He had to use Fn+F4 to let F4 funtcion normally.
In the setup of the laptop he could change this: so now F4 is F4 again.

2018-11-21 02:02:03

Md Ruhul Amin

When i click mojilafirefox, open my compute. I face this poblm. When click f4 then infront project link second displa. Then click second display i solve my poblm.
But again and again faceing this ponlm. How to solve this ponlm

2018-02-25 05:36:04


When iclick f2 the brightness decreases

2017-11-02 04:29:03


Thank you very much, it was really helpful.

2017-06-24 09:07:54


Very helpful...Thanks!!!

2017-06-02 15:36:11

sydney scelza

You are a magician - thank you! F4 was my go to key for "repeat last action" action and it drove me nuts that I couldn't use it. Now I can!

2017-04-24 09:51:31


Thanks so much; this has been driving me crazy since i recently got a new work computer (Dell Inspiron)

2017-04-05 09:37:39


Thank you been driving me mad since I got this windows 10 PC

2017-03-23 17:13:27

Jarod Rollins

My keyboard has a function lock that was on, I pressed the function lock key that looks like an F in a square box followed by the word lock, and then F4 worked for changing cell references

2017-03-16 05:10:24


Thank you so much. Longer time problem solved

2017-02-21 10:44:51


Adolfo Gonzalez, that did the trick for me! Thanks! That explains why it used to work and then quit. I didn't know what that key did.

2017-02-20 20:16:12

Hippy Powers

Hi Wyatt, I ran into this in class the other day. Apparently you can also use the Windows button instead of FN. However, the point is, MS has ruined a perfectly normal shortcut that has been with us for about two decades. Who the hell decides these things??? Certainly not us. Bill

2017-01-18 10:56:02


Nice one. Pressing the FN and F4 key simultaneously solved the trick. :-)

2016-10-03 08:49:15


I kept searching after my last post (03 Oct 07:12) and found a solution.
The setting is not Windows related, it is PC related. Need to update BIOS.
Found instruction here, https://www.youtube.com/watch?v=ssg0TlGCtu4

2016-10-03 07:12:56


Just bought a new HP running Windows 10 and Office 2016. I have the same problem as the original article. I press f4 to repeat last action or cycle through absolute cell refs, yet all I get is the projector/dual screen option. The same with F2 - instead of editing, my screen dims.
By holding the Fn key before pressing the keys, returns to the expected functionality, which is a part solution. BUT I DON'T WANT TO HAVE TO HOLD THE FN BUTTON DOWN EVERY TIME. I use these functions all the time. I'd rather hold down Fn if I want to switch display (like almost never!). Anyone have any idea? I've searched extensively and this is the closest I've come, without solution.

2016-07-29 03:46:15

David Smith

Professor Brian Revell and Charley thank you for your suggestion for those using MS Excel 2016 with MS Windows 10 operating system and MS Microsoft ergonomic keyboard.

2016-07-08 06:51:34



I do indeed have a Toshiba Laptop with Windows 8.1.

If I try to use F2 first, it indeed allows (only) to readjust brightness.

Using FN&F4 removes the original formula (in this case with absolute references to another page in the same workbook) and replaces it with a relative ref. formula on the same page, actually to the cell next to right of the original...

And if I try to do again in an other cell, the same procedure affects nothing whatsoever. Weird, isn't it?

So I am stuck with my original problem!


2016-07-07 15:23:34


You can hold the windows key down and then press the F4 key as you did before and it will lock your formula...

2016-06-23 10:06:34

Sananda sarkar

Thanks..I was not able to use f4 keys in excel...but now i can by pressing fn keys.Thanks again sir.

2016-04-30 00:25:32

Roman Buchanan

My laptop still lacks the ability to utilize F4 even whilst holding the FN key, nor does it possess this valuable FLock everyone seems fond of. Any other suggestions?

2016-04-26 17:22:46

Adolfo Gonzalez

Thanks. I have a Dvorak keyboard and it's been puzzling me for a very long time. On my keyboard the special key that you suggested as "FN" is labeled "f LOCK" with the "f" inside a box. It unlocked the special function keys and returned them to normal use.

Thanks again!

2016-03-01 12:41:18


Thanks have to use FN now for freeze always....

2016-02-09 05:06:21


Thank you. This solved the problem I was having with excel. I'm taking an excel class and I could not figure out what I was doing wrong. But now I know I just needed to activate the Function Key.

2015-11-24 11:12:18

Professor Brian Revell

I am running Office 16 under Windows 10. Whilst the F4 key worked perfectly under windows 8.1 on my Samsung laptop, it does not do so now.

nor does holding the Fn key down with F4 or F2 enter edit mode.

However, by initally pressing th Fn Lock key, the F4 produces the absolute cell referencing in the formula.

2015-07-20 04:58:55


While I like Willy's tip (which I didn't know), if you want more control - for instance because you've got a lot of references and only some are absolute, you can press F4 after entering each reference and only that reference will be affected. This has always been my habit as I build up a formula.

2015-07-18 06:35:08

Willy Vanhaelen

Simply highlight the entire formula before pressing F4. You can also add the $ signs manually.

2015-07-17 11:31:57


This is great, except when I have a calculation of two cells, and I want both set as absolute cell reference.

For example, A1*B1. When I set absolute cell reference, it only sets B1, so the formula is A1*$B$1. If I copy that cell to, say, I10, it changes the A1 reference to G10, and I get zero since there is nothing in G10.

Any suggestions to set all components of the calculation to absolute cells?

2015-03-02 16:54:19


I don't have a FN on my computer. im using a gateway computer with windows 8.1

2015-02-28 13:12:02

Jim Conlon

I have a problem with the F keys, F5 in particular. This was my edit key in Windows Vista. Now I have Windows 8.1 where the F keys do not have the same function as in Vista. The Fn function does work in different circumstances. However, it does not let me edit a cell in excel like I used to do. I have to retype the contents of the cell in its entirety. That is a pain.

2015-02-17 03:04:12


Thanks for sharing your knowledge, the FN plus F4 key did the trick for me. Couldn't find this anywhere. Cheers

2015-01-11 10:09:13

Gadi Bizinyan

Good article. I have Dell Inspiron 3542 and the Escape key has a symbol of a lock with the letters "Fn" within. This is toggling the usage of the Fn key with the functionality of the F buttons.

2014-09-10 10:28:17


The key for enabling the function keys may also be labled "F Lock" (Microsoft ergonomic keyboard).

2014-09-08 05:43:58


Many laptops which use the Fn key as indicated to trigger alternative meanings for the F-keys also have an option somewhere which toggles the behaviour when the Fn key *isn't pressed* between "use the F-key meaning" and "use the computeer control meaning".

You can use that to set you preferred default for the keys and this may be Hazel's long-term answer.

Unfortunately, where this option is found probably varies depending on your hardware manufacturer. And it may be a BIOS setting without a user-friendly switch within Windows itself.

2014-09-07 19:18:53


I have a similar thing when using my partner's Mac. A lot of my usual shortcuts are completely different and it makes work just that little bit more tedious.

2014-09-06 05:06:50


Thanks I found this very helpful.

This Site

Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.

Newest Tips

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.