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

Ask Your Question

Excel's Ctrl+Shift+" shortcuts equivalent in Calc [closed]

asked 2013-11-17 17:38:20 +0200

Zeki Bildirici gravatar image


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. - http://office.microsoft.com/en-001/excel-help/keyboard-shortcuts-in-excel-HA102772370.aspx?CTT=1

I did checked Calc's shortcut's list in help: https://help.libreoffice.org/Calc/Shortcut_Keys_for_Spreadsheets and couldn't find it.

Best regards, Zeki

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-11-14 19:39:51.535819


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

MQ-818 gravatar imageMQ-818 ( 2013-11-17 20:21:49 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2013-11-18 00:22:17 +0200

oweng gravatar image

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.

edit flag offensive delete link more


Thanks, i'll add myself to fdo#53602

Zeki Bildirici gravatar imageZeki Bildirici ( 2013-11-18 16:31:29 +0200 )edit

Question Tools

1 follower


Asked: 2013-11-17 17:38:20 +0200

Seen: 2,990 times

Last updated: Nov 19 '13