Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoFit not working properly
I have a cell formatted to wrap. I put in a value that is two words,
"Column plan". The row height is 25.50 so enough room for 2 lines in the cell. If I make the column very narrow and then either double click it or call a macro with Selection.Columns.AutoFit it only goes to 5.57 wide and loses the "n" in column to the second line: Colum n plan How can I get this to automatically size properly to look like: Column plan ? In other words I want to do an AutoFit that will be as wide as my widest word. Note I am using Excel 2003 but my users could have other versions. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoFit not working properly
Use two rows for the header data.
-or- Auto fit your columns then check that the width of each column is = a minimum width. -- Jim Cone Portland, Oregon USA Compare/List/Remove/Find: http://tinyurl.com/XLCompanion .. .. .. "zxcv" wrote in message I have a cell formatted to wrap. I put in a value that is two words, "Column plan". The row height is 25.50 so enough room for 2 lines in the cell. If I make the column very narrow and then either double click it or call a macro with Selection.Columns.AutoFit it only goes to 5.57 wide and loses the "n" in column to the second line: Colum n plan How can I get this to automatically size properly to look like: Column plan ? In other words I want to do an AutoFit that will be as wide as my widest word. Note I am using Excel 2003 but my users could have other versions. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoFit not working properly
Could this be a zoom issue?
I've noticed that most fonts fail to scale correctly when zooming in Excel. I think Excel's Autofit feature is designed to give best results at 100%. If your sheet isn't already set to 100% try doing that and then work from there. If that is the problem but you still need things to look right at various zoom levels then maybe you could write a routine that runs Autofit and then adds a fixed amount to the column width to compensate for this phenomenon - this would take some trial and error of course, to determine what that fixed amount should be depending on the font and font size used. HTH Nick |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoFit not working properly
I can't use two rows. This is part of a bigger issue. There could be
more than 2 words too. The minimum width try doesn't address the issue either and also is not foolproof. I want this to scale properly, not have an arbitrarily big cell. I don't want to waste space. On Aug 3, 7:36*pm, "Jim Cone" wrote: Use two rows for the header data. -or- Auto fit your columns then check that the width of each column is = a minimum width. -- Jim Cone Portland, Oregon *USA Compare/List/Remove/Find: *http://tinyurl.com/XLCompanion . . . "zxcv" wrote in message I have a cell formatted to wrap. *I put in a value that is two words, "Column plan". *The row height is 25.50 so enough room for 2 lines in the cell. *If I make the column very narrow and then either double click it or call a macro with Selection.Columns.AutoFit it only goes to 5.57 wide and loses the "n" in column to the second line: Colum n plan How can I get this to automatically size properly to look like: Column plan ? In other words I want to do an AutoFit that will be as wide as my widest word. Note I am using Excel 2003 but my users could have other versions. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoFit not working properly
On Aug 4, 7:12*am, Nick H wrote:
Could this be a zoom issue? I've noticed that most fonts fail to scale correctly when zooming in Excel. I think Excel's Autofit feature is designed to give best results at 100%. If your sheet isn't already set to 100% try doing that and then work from there. If that is the problem but you still need things to look right at various zoom levels then maybe you could write a routine that runs Autofit and then adds a fixed amount to the column width to compensate for this phenomenon - this would take some trial and error of course, to determine what that fixed amount should be depending on the font and font size used. HTH *Nick Yes. Zoom is set to 100%. Ironically if I zoom to 50% then it AutoFits correctly but I need to stay at 100%. Yes I could add some amount to the width that would work most of the time but I want to get this to work properly without wasted space. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoFit not working properly
Set all columns to a width wider than the maximum and then do the autofit. -- Jim Cone Portland, Oregon USA http://tinyurl.com/ExtrasXL .. .. .. "zxcv" wrote in message I can't use two rows. This is part of a bigger issue. There could be more than 2 words too. The minimum width try doesn't address the issue either and also is not foolproof. I want this to scale properly, not have an arbitrarily big cell. I don't want to waste space. On Aug 3, 7:36 pm, "Jim Cone" wrote: Use two rows for the header data. -or- Auto fit your columns then check that the width of each column is = a minimum width. -- Jim Cone Portland, Oregon USA Compare/List/Remove/Find: http://tinyurl.com/XLCompanion . . . "zxcv" wrote in message I have a cell formatted to wrap. I put in a value that is two words, "Column plan". The row height is 25.50 so enough room for 2 lines in the cell. If I make the column very narrow and then either double click it or call a macro with Selection.Columns.AutoFit it only goes to 5.57 wide and loses the "n" in column to the second line: Colum n plan How can I get this to automatically size properly to look like: Column plan ? In other words I want to do an AutoFit that will be as wide as my widest word. Note I am using Excel 2003 but my users could have other versions. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoFit not working properly
That will eliminate the wrap issue but it will make my columns too
wide. I want them to be only as wide as the widest word. On Aug 4, 9:39*am, "Jim Cone" wrote: Set all columns to a width wider than the maximum and then do the autofit.. -- Jim Cone Portland, Oregon *USAhttp://tinyurl.com/ExtrasXL . . . "zxcv" wrote in message I can't use two rows. *This is part of a bigger issue. *There could be more than 2 words too. The minimum width try doesn't address the issue either and also is not foolproof. *I want this to scale properly, not have an arbitrarily big cell. *I don't want to waste space. On Aug 3, 7:36 pm, "Jim Cone" wrote: Use two rows for the header data. -or- Auto fit your columns then check that the width of each column is = a minimum width. -- Jim Cone Portland, Oregon USA Compare/List/Remove/Find:http://tinyurl.com/XLCompanion . . . "zxcv" wrote in message I have a cell formatted to wrap. I put in a value that is two words, "Column plan". The row height is 25.50 so enough room for 2 lines in the cell. If I make the column very narrow and then either double click it or call a macro with Selection.Columns.AutoFit it only goes to 5.57 wide and loses the "n" in column to the second line: Colum n plan How can I get this to automatically size properly to look like: Column plan ? In other words I want to do an AutoFit that will be as wide as my widest word. Note I am using Excel 2003 but my users could have other versions. |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoFit not working properly
Yes. *Zoom is set to 100%. *Ironically if I zoom to 50% then it AutoFits correctly but I need to stay at 100%. *Yes I could add some amount to the width that would work most of the time but I want to get this to work properly without wasted space. In that case this is probably either a Font or printer driver problem. You could try experimenting by changing both of these things to try and get a 'fix'. The trouble is, getting it to look right on one system doesn't necessarily mean it will look right on all I'm afraid. Good luck, Nick. |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoFit not working properly
Tested it with my Excel, got exactly the same result:
Colum n plan Easy solution use a line feed + wrap: - manually: type "column", press alt + enter, type "plan" - formula: ="Column" & CHAR(10) & "plan" (or if u want to refer to cells: =A1 & CHAR(10) & B1) Best wishes Daniel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Yes No box no working properly | Excel Programming | |||
Autofit for row height is not working. Why? | Excel Discussion (Misc queries) | |||
But not working properly | Excel Discussion (Misc queries) | |||
AutoFit not working in vb.net when creating a xls | Excel Programming | |||
format-row-autofit not working | Excel Worksheet Functions |