Excel's Ctrl+Shift+" shortcuts equivalent in Calc


Do you know if there is an alternative for Excel’s shortcut:

Ctrl+Shift+" Copies the value from the cell above the active cell into the cell or the Formula Bar. -

I did checked Calc’s shortcut’s list in help: Shortcut Keys for Spreadsheets - LibreOffice Help and couldn’t find it.

Best regards,

I am not sure if this is what you are looking for…

I use CTL+X to cut any cell and Paste it to CTL+V

It will cut and paste formula also, Last time that I checked it even updated

a simple formula to work at the destination

This particular hotkey function (copy value from cell above) is not implemented in Calc at present. There is no equivalent function available under Tools > Customize… > Keyboard tab. Under the Category of “Edit” a new entry like “Copy value above” would seem to be required. The Edit Function “Fill Down” (CTRL+D) is similar but rather clunky as the cell references are adapted and the new cell value / selection is initially hidden (under v4.1.3.2), requiring subsequent cursor movement to then edit the new value.

Bug fdo#53602 appears to be the related enhancement request. I will comment in the bug to provide an update for clarity. Thanks.

Thanks, i’ll add myself to fdo#53602