| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Wrap text creates an extra line
I have a notes column with the wrap text format on. I find that when I have
a line of text that reaches 2-3 characters from the end of the cell, Excel expands the row and adds a blank line below it. However, there are no characters on this line so I have a bunch of entries with an extra line of space below them. I could just go through and manually shorten the width of these lines, but it will take me all day and the minute I select all the lines and autosize I will be back where I started. Is there any way to get Excel to only expand the width when there is actually a word or character to carry over? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| WRAP a text line over several columns without merging cells | Excel Worksheet Functions | |||
| WRAP a text line over several columns without merging cells | Excel Worksheet Functions | |||
| Cell set to wrap text and blank line -- fix? | Excel Discussion (Misc queries) | |||
| In Excel, using line wrap with text, some cells will appear as ##. | Excel Discussion (Misc queries) | |||
| how can I wrap text from one line to another? | Excel Worksheet Functions | |||
Threaded Mode
