Absolute cell reference shortcut key


I’m migrating to LibreOffice, from Excel. In Excel, there used to be a feature to flip through all possible absolute cell references while typing, such as from C6 to $C6 to C$6 to $C$6. You could do that by hitting F4.

Configuring shortcut keys in LibreOffice, I cannot find a corresponding command. Any hints?

Thank you.

information valuable and excellent design as share good stuff with good ideas and concepts lots of great information and inspiration both of which I need, thanks to offer such a helpful information here. ACCT 571 WEEK 3 ASSIGNMENT LATEST

As we mentioned earlier, there are many ways you could Buy Instagram Followers UK. The best way is to check out our website and see if you can find a package for you that suits your needs.

We are happy to discuss these options with you, and show you how you can make money with an Instagram account. Ahrefs Group Buy

Absolute reference is set to Shift+F4 (because F4 is set to Data Sources). This is quite annoying since F4 is the STANDARD key since Lotus 123…

You can change this by going to Tools, Customize, Keyboard tab.
On the Shortcut keys locate Shift+F4 and press the Delete button. Then navigate to the F4 shortcut and choose Category: Insert, Function: Relative/Absolute References and press the Modify button.

You can now set Shift+F4 to Data Source if you wish…

Don’t forget to press OK when finished!

@Pedro1 this is very good news. I will do so immediately!!!

i just placed an enhancement request.

Thanks a lot @Pedro1 !

@richbook, you are welcome :wink: I’m sure this answer will be useful to others (hopefully until the keys are changed in LO). If you can edit the first post, could you correct the spelling in Absolute?

this was really helpful. thanks a lot.


Thanks a lot Pedro. I’m newbie in Libre Office calc. Your answer saved my time :).

Since LO 5.1, the key to cycle through absolute and relative reference combinations is F4 by default. See this comment in the enhancement request: https://bugs.documentfoundation.org/show_bug.cgi?id=59418#c26