How to paste data into multiple cells in Excel

[Guest]

I have data on the clipboard which I want to paste into multiple cells in a
column that is selected. When I Ctrl+V, it only pastes into the first cell.
How can I get it to paste into all the cells that I have selected?

Thanks . . . Walt

 

[Guest]

click on the cell > right-click > select Paste Special> Text
should break it up for you...

 

[Guest]

WHen I do that, the wizard sez the data on the clipboard is not the same size
and shape as the cells selected. If I click OK, it just pastes into the
first selected cell.

More help, please . . . TIA

 

[Guest]

I was trying to do this but no success. But I notice when thing that can be
useful for you. When you copy data within from excel then you can paste into
multiple cells without any problem.

So, you can use a trick, see if it works.

Paste Clipboard data into Excel in a cell then copy that cell and paste it
into multiple cells.

Let us know, if the information was in any use.

 

[Guest]

It works!! Thanks. Much easier than finding a way to do a script.

g'day . . .