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

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