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

Question Tools



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

Seen: 61,335 times

Last updated: Jan 16 '13