We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Absolute cell reference shortcut key [closed]

asked 2013-01-15 12:44:07 +0200

richbook gravatar image

updated 2021-06-01 15:10:06 +0200

Alex Kemp gravatar image


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.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-20 00:49:09.098736


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.

devrycourses gravatar imagedevrycourses ( 2020-09-03 14:14:12 +0200 )edit

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.

shahid gravatar imageshahid ( 2021-03-25 20:15:14 +0200 )edit

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

shahid gravatar imageshahid ( 2021-03-25 20:17:17 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2013-01-15 13:15:44 +0200

Pedro gravatar image

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!

edit flag offensive delete link more


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

ROSt52 gravatar imageROSt52 ( 2013-01-15 13:30:30 +0200 )edit
ROSt52 gravatar imageROSt52 ( 2013-01-15 13:58:46 +0200 )edit

Thanks a lot @Pedro !

richbook gravatar imagerichbook ( 2013-01-16 11:52:25 +0200 )edit

@richbook, you are welcome ;) 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?

Pedro gravatar imagePedro ( 2013-01-16 14:52:07 +0200 )edit

this was really helpful. thanks a lot.

Surajit gravatar imageSurajit ( 2013-11-04 11:21:28 +0200 )edit

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

Alice Mark BB gravatar imageAlice Mark BB ( 2015-03-20 16:02:04 +0200 )edit

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/s...

chtfn gravatar imagechtfn ( 2017-09-06 07:29:59 +0200 )edit

Question Tools



Asked: 2013-01-15 12:44:07 +0200

Seen: 64,643 times

Last updated: Jan 16 '13