| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy & Paste cell that has alt + enter
I am trying to copy and paste a cell where I've used alt + enter to put text
on the next line. When I paste, the data after each instance of alt + enter is placed in a new row in the same column rather than copying it into one cell as it appears in the original. How can I paste the data into one cell? -- DME |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy & Paste cell that has alt + enter
Paste into the formula bar.
-- David Biddulph "DME777" wrote in message ... I am trying to copy and paste a cell where I've used alt + enter to put text on the next line. When I paste, the data after each instance of alt + enter is placed in a new row in the same column rather than copying it into one cell as it appears in the original. How can I paste the data into one cell? -- DME |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy & Paste cell that has alt + enter
Try Paste Special - Select All.
Regards, Emece.- "DME777" wrote: I am trying to copy and paste a cell where I've used alt + enter to put text on the next line. When I paste, the data after each instance of alt + enter is placed in a new row in the same column rather than copying it into one cell as it appears in the original. How can I paste the data into one cell? -- DME |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy & Paste cell that has alt + enter
Excel 2003 and 2007.
If I copy a cell and paste all contents go into one cell. BUT................... If I copy the contents from the formula bar, select a cell and paste, the contents go into separate cells. Which of these operations are you doing? Gord Dibben MS Excel MVP On Mon, 7 Dec 2009 10:28:01 -0800, DME777 wrote: I am trying to copy and paste a cell where I've used alt + enter to put text on the next line. When I paste, the data after each instance of alt + enter is placed in a new row in the same column rather than copying it into one cell as it appears in the original. How can I paste the data into one cell? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Word cell containing Shift/Enter to Excel.Keep it as 1 cell | Excel Discussion (Misc queries) | |||
| copy and paste according to cell value | Excel Discussion (Misc queries) | |||
| enter formula to copy characters in a cell less last one | Excel Discussion (Misc queries) | |||
| Copy/Paste from once cell to another | Excel Worksheet Functions | |||
| Select cell, Copy it, Paste it, Return to Previous cell | Excel Discussion (Misc queries) | |||
Linear Mode
