| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
some text shows in merged cells but not all
I am inputting text to a spread sheet that has previously been formated by
somebody else. The cells have been merged and set to wrap text. Only an amount of the text shows in the merged cells, even if I expand them. Double clicking on the cells shows all the text but as soon as I come out it reverts to show only part of the text. The whole text also shows in the formula bar. Please help |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
some text shows in merged cells but not all
Change formatting in the cell from 'text' to 'general'.
-- -Kaman The IT dept people call before they call the real IT dept. "Jon" wrote: I am inputting text to a spread sheet that has previously been formated by somebody else. The cells have been merged and set to wrap text. Only an amount of the text shows in the merged cells, even if I expand them. Double clicking on the cells shows all the text but as soon as I come out it reverts to show only part of the text. The whole text also shows in the formula bar. Please help |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
some text shows in merged cells but not all
Try adding alt-enters (to force new lines within the cell) every 80-100
characters. You should be able to see more. Jon wrote: I am inputting text to a spread sheet that has previously been formated by somebody else. The cells have been merged and set to wrap text. Only an amount of the text shows in the merged cells, even if I expand them. Double clicking on the cells shows all the text but as soon as I come out it reverts to show only part of the text. The whole text also shows in the formula bar. Please help -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Wrapping text in merged cells | Excel Discussion (Misc queries) | |||
| Merged cells/wrap text | Excel Discussion (Misc queries) | |||
| Excel; shows a line of # instead of my text in a merged cell. | Excel Discussion (Misc queries) | |||
| how to see the whole text in merged cells? | New Users to Excel | |||
| merged cells into one text cell, size varies dependant on text dat | Excel Discussion (Misc queries) | |||
Linear Mode
