Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I stop cell contents from spilling into the next cell?
I'm working with a spreadsheet and I want to fix the column width more narrow
than my cell contents. If the next column is blank, i do NOT want extra characters to appear. I don't want them truncated, i just want to restrict to a set width what I see in that column. Does anyone know how to do that? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I stop cell contents from spilling into the next cell?
Hi infofam,
You could: 1. Format the cell to wrap text, then fix the line height so that anything over one line won't show; or 2. insert a space character into the adjacent cell. -- Cheers macropod [Microsoft MVP - Word] "infofam" wrote in message ... I'm working with a spreadsheet and I want to fix the column width more narrow than my cell contents. If the next column is blank, i do NOT want extra characters to appear. I don't want them truncated, i just want to restrict to a set width what I see in that column. Does anyone know how to do that? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I stop cell contents from spilling into the next cell?
Format the cells to Wrap Text.
Gord Dibben MS Excel MVP On Mon, 15 Feb 2010 08:15:01 -0800, infofam wrote: I'm working with a spreadsheet and I want to fix the column width more narrow than my cell contents. If the next column is blank, i do NOT want extra characters to appear. I don't want them truncated, i just want to restrict to a set width what I see in that column. Does anyone know how to do that? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I stop cell contents from spilling into the next cell?
Format - cell format - alignment - wrap text
This will however have the effect of increasing the height of the row. -- Russell Dawson Excel Student "infofam" wrote: I'm working with a spreadsheet and I want to fix the column width more narrow than my cell contents. If the next column is blank, i do NOT want extra characters to appear. I don't want them truncated, i just want to restrict to a set width what I see in that column. Does anyone know how to do that? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I stop cell contents from spilling into the next cell?
Both of these suggestions will work very nicely. Thank you. "macropod" wrote: Hi infofam, You could: 1. Format the cell to wrap text, then fix the line height so that anything over one line won't show; or 2. insert a space character into the adjacent cell. -- Cheers macropod [Microsoft MVP - Word] "infofam" wrote in message ... I'm working with a spreadsheet and I want to fix the column width more narrow than my cell contents. If the next column is blank, i do NOT want extra characters to appear. I don't want them truncated, i just want to restrict to a set width what I see in that column. Does anyone know how to do that? . |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I stop cell contents from spilling into the next cell?
That's helpful. Thank you. I had hoped to keep the entries one line high,
so I will make the height fixed as macropod suggest below. That will do it. "Russell Dawson" wrote: Format - cell format - alignment - wrap text This will however have the effect of increasing the height of the row. -- Russell Dawson Excel Student "infofam" wrote: I'm working with a spreadsheet and I want to fix the column width more narrow than my cell contents. If the next column is blank, i do NOT want extra characters to appear. I don't want them truncated, i just want to restrict to a set width what I see in that column. Does anyone know how to do that? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
'IF' Macro to insert cell contents to alternate cell if cell not e | Excel Worksheet Functions | |||
Return cell address of a cell based on contents of cell. | Excel Worksheet Functions | |||
Stop spilling the text to the adjoining cell | Excel Discussion (Misc queries) | |||
STOP auto format of cell contents | Excel Discussion (Misc queries) | |||
Returning Cell Contents of One Cell Based On Another Cell | Excel Worksheet Functions |