self-adjusting column widths (and sheet, kindof)
Posted by Kiran. K on October 05, 2001 2:28 AM
I was wondering if anyone knows how to get EXcel
to create self-adjusting column widths. That is,
if I type text in a cell, and it exceeds the width,
the text "outside" the width of the cell gets hidden
when I'm done typing. If I have many cells whose
text columns are varying, I'd have to manually
adjust the width every single time.
So, is there a way where I can select a whole sheet
and say "adjust column width according to max width
of text typed in all cells" ?
Along the saame lines, if I have a sheet with more
columns than I can see on screen, is there a way to
have excel adjust the font size automatically to
adjust the display to fit the screen ?