Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel autofit and word wrap
We are having difficulty getting automatically generated excel documents to
format correctly with respect to column headings. When using the column autofit feature along with word wrap, Excel is actually breaking multiple word headings in the middle of words. For example, SHAREHOLDERS' EQUITY is appearing as SHAREHOLD ERS' EQUITY The headings may be translated to other languages, so we don't know the appropriate widths ahead of time. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel autofit and word wrap
That's what Excel does, might help a little to use mixed case
and bold font for your column headers, if that is not what you are doing. Once you drag the column line to modify the column width (or double click), or use Format, column, width, hen Excel figures you know the column width that you want and if Excel can't fit whole words in the width it will spit the word. Since you have already done that you might make the column wider, because Excel will not widen the column after you have forced a width. If you force the height of a row, you may start losing display of the bottom lines. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Janine" wrote in message ... We are having difficulty getting automatically generated excel documents to format correctly with respect to column headings. When using the column autofit feature along with word wrap, Excel is actually breaking multiple word headings in the middle of words. For example, SHAREHOLDERS' EQUITY is appearing as SHAREHOLD ERS' EQUITY The headings may be translated to other languages, so we don't know the appropriate widths ahead of time. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy from Word to Excel, and retain indent, plus word wrap | Excel Discussion (Misc queries) | |||
Autofit and word wrap don't work? | Excel Discussion (Misc queries) | |||
Wrap text and row autofit not working in Excel | Excel Discussion (Misc queries) | |||
when I wrap text in excel it disappears? autofit does not work | Excel Worksheet Functions | |||
How do I "Wrap Text" & "Autofit" within Merged Cells in Excel? | Excel Worksheet Functions |