Ask Your Question

Absolute cell reference shortcut key [closed]

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

richbook gravatar image

updated 2013-01-16 22:01:13 +0200

manj_k 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

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:

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

An absolute turn and cellist formed for the repeated slots for the beings. The nomination of the dissertation assistance is approved for the modes. The structure is fit for the nodes of the modern-day and time for the recurring items for the fieldwork.

wowoq gravatar imagewowoq ( 2020-02-18 11:21:08 +0200 )edit

Testing on a Windows 10 system indicates that the F4 key still cycles through absolute/relative versions of references. There is a caveat, ... by

followersuk gravatar imagefollowersuk ( 2020-03-12 09:04:53 +0200 )edit

Question Tools



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

Seen: 62,945 times

Last updated: Jan 16 '13