3

In Microsoft Excel I frequently use the keyboard shortcut Ctrl+' (apostrophe) to copy the value from the cell above the current one. The same keystrokes in Google Sheets instead toggles the display of formula and I cannot find an equivalent shortcut to copy the value from the cell above. Any ideas please?

  • @krowe I can't see anything in that link that can do what Ctrl+' does in Excel. – Caltor Mar 1 '15 at 8:40
  • Which leads me to believe that it isn't possible. – krowe Mar 1 '15 at 9:05
  • Well I guess that's an answer then. 😂 – Caltor Mar 1 '15 at 9:06
3

Something that comes close is "Fill Down" (Ctrl+D).

If you highlight the cell with the formula you want as well as the cell below it, then use this shortcut, it'll be just like you used the fill handle, without having to do all that mousing.

In fact, this may be more useful, because you could just put the formula on the first row, add all the rest of your data, then do the fill-down at the end.

Not as convenient as Ctrl+', but I've found it pretty useful lately.

3

If you're trying to copy down a value that you just entered/typed into the cell above, then you can use F4.

(F4 in Excel and Google Sheets does something along the lines of "repeat the last thing I just did".)

You might want to adjust your keyboard settings if you want to use this frequently so you don't have to hit fn + F4 every time since on most new computers the function keys are assigned to system functions (e.g. volume, app switcher, etc.).

  • hmmm not bad. This only works if you have just typed the number above though, so won't work in all scenarios but it's pretty good. – Caltor Feb 13 at 14:28
1

First highlight the range where you are going fill with data, including the row/cell with the initial data. Enter the initial data, (on Windows) press Shift+Enter (to get to the last row in the range) then press Ctrl+D.

This will copy down all values by column.

1

There is no equivalent of Ctrl+' in Google Sheets however you can record a macro that does the same thing and save it to a Ctrl+Shift+Alt+Number keyboard shortcut. Thanks to CodeCamper for pointing out this is now possible.

  1. Click the Tools menu > Macros > Record Macro
  2. Click "Use relative references"
  3. Place your cursor somewhere on row 2 or below.
  4. Press the key on your keyboard
  5. Press Ctrl+C on your keyboard or select Edit > Copy from the menu
  6. Press Ctrl+V on your keyboard or select Edit > Paste from the menu
  7. Click Save
  8. Enter a name and shortcut number for the new macro when prompted.
  9. Click the Save button.

Note you will need to allow macros when prompted the first time you use the shortcut.

  • Sadly, there is no way to attach keyboard shortcuts to Apps scripts. – user79865 Jan 12 '16 at 2:41
  • @Normal I've just found that you can vote for the App Script Keyboard Shortcuts at code.google.com/p/google-apps-script-issues/issues/…. There is a SO question at stackoverflow.com/questions/13731589/… along with a possible workaround. – Caltor Jan 12 '16 at 13:00
  • 1
    This answer is not true anymore, macros are a thing which allows you to assign shortcuts, although the choices of key combinations may be limited you can always use in conjunction with something like autohotkey. – CodeCamper Nov 25 at 4:27
0
  1. Shade cell above,
  2. Hold Shift key and shade your target cell (or use the mouse to shade both cells),
  3. Type CTRL + D. You're done!
-1

Are you wanting to copy the value because you only want to paste values? If so, then copy works just as it always does (Ctrl + C) and then the shortcut for pasting values only is

Shift + Ctrl + V

  • The Asker presumably already knows about the "old fashioned" copy-paste. That's quite a few more keystrokes than Ctrl-', though. – ale Jan 8 '16 at 21:05
  • the only reason i mentioned that is because of specifically paste values only is slightly different than excel – Aurielle Perlmann Jan 8 '16 at 21:08
  • Yeah I know about copy and paste values thanks. I'm after a quicker way to copy the value from the cell above. In Excel this is only 2 keystrokes. – Caltor Jan 11 '16 at 11:25

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.