Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell length
I'm having a bit of trouble getting my data into a cell or row. It consists of up to about 600 characters and as I try to read it, the horizontal scrollbar jumps and makes it very difficult. The largest cell width of 256 isn't enough, so should I merge two cells? Will doing this lose any data? Thanks - Kirk |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell length
Can you use a textbox? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell length
Make the text use additional lines. Try typing this in a cell
Mary had a little lamb (now type ALT+ENTER) Its fleece was white as snow (ALT+ENTER) And everywhere...... This is call 'text wrapping' best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email <kirkm wrote in message ... I'm having a bit of trouble getting my data into a cell or row. It consists of up to about 600 characters and as I try to read it, the horizontal scrollbar jumps and makes it very difficult. The largest cell width of 256 isn't enough, so should I merge two cells? Will doing this lose any data? Thanks - Kirk |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell length
Maybe you could turn on wrap text and increase the rowheight.
kirkm wrote: I'm having a bit of trouble getting my data into a cell or row. It consists of up to about 600 characters and as I try to read it, the horizontal scrollbar jumps and makes it very difficult. The largest cell width of 256 isn't enough, so should I merge two cells? Will doing this lose any data? Thanks - Kirk -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell length
On Thu, 26 Feb 2009 09:13:10 -0400, "Bernard Liengme"
wrote: Make the text use additional lines. Try typing this in a cell Mary had a little lamb (now type ALT+ENTER) Its fleece was white as snow (ALT+ENTER) And everywhere...... This is call 'text wrapping' best wishes Thanks Bernard. I can see how that works... but I'd like to keep the row height to single. I did figure out part of the problem, I had no end cell and the scroll bar was jumping rather than scrolling. By making a dummy end column that now behaves a lot better. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell length
On Thu, 26 Feb 2009 03:47:02 -0800, Davesexcel
wrote: Can you use a textbox? On a cell in a worksheet? That's a new concept I've never considered. Is there any way to have more than one text colour per cell ? Thanks - Kirk |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Length that falls within a length interval? | Excel Worksheet Functions | |||
exact length of the cell | Excel Discussion (Misc queries) | |||
Validation length, Range length | Excel Discussion (Misc queries) | |||
Excel Cell Length | Excel Discussion (Misc queries) | |||
Length limitation of cell formulas | Excel Programming |