1

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 Aug 9 '18 at 23:34
  • No, simple text context. – Fabio Bracht Aug 9 '18 at 23:43
  • I mean "content". – Fabio Bracht Aug 9 '18 at 23:57
0

method 1:

  • select desired cell
  • press SHIFT + ARROW KEY
    • or SHIFT + CTRL + 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

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.