What I need to do is to first copy a cell (or the value of the cell), then select a number of other cells (not necessarily in a continuous range), then I want to paste that cell or value into all the selected cells at once.

What happens is the value gets pasted only into the first selected cell, and not to any of the others.

How can I do this?

I'm not super familiar with the intricacies of this product. I've tried searching, but maybe I'm not very good at it because I couldn't find anyone with the same problem exactly.

  • you want to repaste formulas?
    – user0
    Commented Aug 9, 2018 at 23:34
  • No, simple text context. Commented Aug 9, 2018 at 23:43
  • I mean "content". Commented Aug 9, 2018 at 23:57

1 Answer 1


method 1:

  • select desired cell
  • press SHIFT + ARROW KEY
  • and then CTRL + ENTER

method 2:

  • select desired cell
  • press CTRL + C
  • then select multiple cells where you want to paste by holding CTRL
  • press CTRL + V
    • or CTRL + SHIFT + V for values only
    • or CTRL + ALT + V for format only
    • for more options see image

  • There should be more upvotes on this answer. It worked for me on July 18, 2020, on Ubuntu 16, Chromium 81.0,4044.138. So it should work for almost anyone on Windows, probably Mac too. Unless you're using IE or Netscape classic, or maybe Opera? (something really rarely used) . Please upvote unless it didn't work for you! Commented Jul 18, 2020 at 5:23
  • For Method 1, Command-Enter worked for me on OS X (instead of Ctrl-Enter)
    – davejagoda
    Commented Feb 15, 2022 at 4:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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