Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to paste data into multiple cells in Excel
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to paste data into multiple cells in Excel
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. "wrdennig" wrote: 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 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to paste data into multiple cells in Excel
It works!! Thanks. Much easier than finding a way to do a script.
g'day . . . "rajkohli" wrote: 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. "wrdennig" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get cell data in multiple Excel files into one summary fi | Excel Worksheet Functions | |||
consolidation of tables in excel with text and figures | Excel Worksheet Functions | |||
selecting multiple sheet tabs and open another workbook | Excel Discussion (Misc queries) | |||
Excel 2003, Convert EXISTING Worksheet Data to XML? | Excel Discussion (Misc queries) | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |