| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how paste w/o put in columns?
Thanks for any help.
I want to paste some help doc stuff from a program (Freedom, a program for making the annual statement for insurers) into Excel. When I paste it, each word goes into a different column. I would like it so that everything goes into just the first column. Is this possible? I've pasted different stuff before, and it seems that's how it normally goes, but this time it doesn't. I don't know if I have set any options or features related to this. Thanks again. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how paste w/o put in columns?
Highlist the cell you want to put the data into. Then paste the data into
the fx box on the top of the excel worksheet "Ian Elliott" wrote: Thanks for any help. I want to paste some help doc stuff from a program (Freedom, a program for making the annual statement for insurers) into Excel. When I paste it, each word goes into a different column. I would like it so that everything goes into just the first column. Is this possible? I've pasted different stuff before, and it seems that's how it normally goes, but this time it doesn't. I don't know if I have set any options or features related to this. Thanks again. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how paste w/o put in columns?
Thanks Joel!
Sorry, I should have mentioned, I would like each line to be on a different row too. Is that possible? Thanks. "Joel" wrote: Highlist the cell you want to put the data into. Then paste the data into the fx box on the top of the excel worksheet "Ian Elliott" wrote: Thanks for any help. I want to paste some help doc stuff from a program (Freedom, a program for making the annual statement for insurers) into Excel. When I paste it, each word goes into a different column. I would like it so that everything goes into just the first column. Is this possible? I've pasted different stuff before, and it seems that's how it normally goes, but this time it doesn't. I don't know if I have set any options or features related to this. Thanks again. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how paste w/o put in columns?
Make sure wrap cell is on for the cell you want to add new line. This is in
format Cell - Alignment. The to add new line hold down the ALT key and press enter. "Ian Elliott" wrote: Thanks Joel! Sorry, I should have mentioned, I would like each line to be on a different row too. Is that possible? Thanks. "Joel" wrote: Highlist the cell you want to put the data into. Then paste the data into the fx box on the top of the excel worksheet "Ian Elliott" wrote: Thanks for any help. I want to paste some help doc stuff from a program (Freedom, a program for making the annual statement for insurers) into Excel. When I paste it, each word goes into a different column. I would like it so that everything goes into just the first column. Is this possible? I've pasted different stuff before, and it seems that's how it normally goes, but this time it doesn't. I don't know if I have set any options or features related to this. Thanks again. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how paste w/o put in columns?
Thanks!
"Joel" wrote: Make sure wrap cell is on for the cell you want to add new line. This is in format Cell - Alignment. The to add new line hold down the ALT key and press enter. "Ian Elliott" wrote: Thanks Joel! Sorry, I should have mentioned, I would like each line to be on a different row too. Is that possible? Thanks. "Joel" wrote: Highlist the cell you want to put the data into. Then paste the data into the fx box on the top of the excel worksheet "Ian Elliott" wrote: Thanks for any help. I want to paste some help doc stuff from a program (Freedom, a program for making the annual statement for insurers) into Excel. When I paste it, each word goes into a different column. I would like it so that everything goes into just the first column. Is this possible? I've pasted different stuff before, and it seems that's how it normally goes, but this time it doesn't. I don't know if I have set any options or features related to this. Thanks again. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I CUT and paste to convert columns to rows? | Excel Worksheet Functions | |||
| How do I set up a copy and paste formula with ascending columns | New Users to Excel | |||
| copy and paste visible columns | Excel Discussion (Misc queries) | |||
| Why can't a copy and paste columns? | Excel Worksheet Functions | |||
| Copy/Paste of separated columns | Excel Discussion (Misc queries) | |||
Linear Mode
