Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I paste a paragraph of text into a merged cell?
I have created a collection of merged cells in a worksheet, and users want to
cut and paste a paragraph into a merged cell. An error occurs, then when entering editing mode you can eventually paste in the content, however it is missing all formating and comes up as a single, long line of text. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I paste a paragraph of text into a merged cell?
TCPohlman:
Did you get an answer to your question? I am having the same problem. -- Lee "TCPohlman" wrote: I have created a collection of merged cells in a worksheet, and users want to cut and paste a paragraph into a merged cell. An error occurs, then when entering editing mode you can eventually paste in the content, however it is missing all formating and comes up as a single, long line of text. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I paste a paragraph of text into a merged cell?
Maybe you can paste into the formula bar?
lee wrote: TCPohlman: Did you get an answer to your question? I am having the same problem. -- Lee "TCPohlman" wrote: I have created a collection of merged cells in a worksheet, and users want to cut and paste a paragraph into a merged cell. An error occurs, then when entering editing mode you can eventually paste in the content, however it is missing all formating and comes up as a single, long line of text. -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I paste a paragraph of text into a merged cell?
If you read further down you'll see that the group generally discourages use
of merged cells. I have not found a solution, in the end I recreated the template I was working on in Word with much better success. "Dave Peterson" wrote: Maybe you can paste into the formula bar? lee wrote: TCPohlman: Did you get an answer to your question? I am having the same problem. -- Lee "TCPohlman" wrote: I have created a collection of merged cells in a worksheet, and users want to cut and paste a paragraph into a merged cell. An error occurs, then when entering editing mode you can eventually paste in the content, however it is missing all formating and comes up as a single, long line of text. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
insert a paragraph break within text in a singel cell? | Excel Discussion (Misc queries) | |||
How do I get the a large amount of text to show in merged cell? | Excel Discussion (Misc queries) | |||
Text in merged cells - not printing all words within the cell | Excel Discussion (Misc queries) | |||
Paste text into a locked or hidden cell | Excel Discussion (Misc queries) | |||
Excel merged cell - can it automatically expand as text is typed? | New Users to Excel |