View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
wrdennig
 
Posts: n/a
Default How to paste data into multiple cells in Excel

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

"ufo_pilot" wrote:

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

"wrdennig" wrote:

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