Ask Your Question

absolute reference

asked 2015-01-11 00:25:33 +0100

dejayajay gravatar image

Does Calc have an F key short cut to change a cell reference to absolute?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2015-01-11 06:39:37 +0100

ROSt52 gravatar image

Should you be used to F4 without the shift, you can change the shortcut in:
Tools > Customize > keyboard

edit flag offensive delete link more


Cannot confirm this. Default for F4 is 'Toggle View Data Sources'. This setting was surely not changed by me.

Shift+F4 for 'Relative Reference' ---> 'Absolute Reference' ist taken from the offline help.

Lupp gravatar imageLupp ( 2015-01-11 14:00:33 +0100 )edit

@Lupp - F4 without shift is only my own customization of the keyboard shortcut. LibO(s default is shift+F4

ROSt52 gravatar imageROSt52 ( 2015-01-14 10:18:14 +0100 )edit

answered 2015-01-11 00:58:49 +0100

Lupp gravatar image

Shift+F4 will cycle through the 4 combinations for any cell reference in the cell.

Turning a completely relative reference into a completely absolute reference: 1 time Shift+F4

Reverse: 3 times Shift+F4

edit flag offensive delete link more


Thank you.

dejayajay gravatar imagedejayajay ( 2015-01-14 00:19:56 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-01-11 00:25:33 +0100

Seen: 424 times

Last updated: Jan 11 '15