Someone sent me a spreadsheet with a formatting trick applied that I would
like to figure out how to apply myself. In this spreadsheet, column N
contained a character string. Somehow, the person who created this
spreadsheet fomatted column so that the zoom changed according to the column
width. The entire spreadsheet was formatted so that the font was Arial 10
pt. But in column N, some cells appeared to have smaller characters, even
though the font was consistently Arial 10 pt. So, the characters in cell N1,
containing the string "Assitant Director to the Managing Editor of Regional
Operations" appeared to be much smaller than cell N2, which contained the
string "Dog Catcher".
When I manually widened the column, the characters in the cells containing
longer strings appeared to get bigger, until finally the entire column
appeared to be the same size. I'm assuming that somehow the zoom level of
that one column was being manipulated based on the column width.
Does anybody know how the person who created the spreadsheet acheived this?

Select Column N

FormatCellsAlignmentText ControlShrink to Fit


Gord Dibben MS Excel MVP

On Tue, 11 Aug 2009 13:07:01 -0700, michalaw
wrote:

Someone sent me a spreadsheet with a formatting trick applied that I would
like to figure out how to apply myself. In this spreadsheet, column N
contained a character string. Somehow, the person who created this
spreadsheet fomatted column so that the zoom changed according to the column
width. The entire spreadsheet was formatted so that the font was Arial 10
pt. But in column N, some cells appeared to have smaller characters, even
though the font was consistently Arial 10 pt. So, the characters in cell N1,
containing the string "Assitant Director to the Managing Editor of Regional
Operations" appeared to be much smaller than cell N2, which contained the
string "Dog Catcher".
When I manually widened the column, the characters in the cells containing
longer strings appeared to get bigger, until finally the entire column
appeared to be the same size. I'm assuming that somehow the zoom level of
that one column was being manipulated based on the column width.
Does anybody know how the person who created the spreadsheet acheived this?

Wow, that was easy! Thanks!

"Gord Dibben" wrote:

Select Column N

FormatCellsAlignmentText ControlShrink to Fit


Gord Dibben MS Excel MVP

On Tue, 11 Aug 2009 13:07:01 -0700, michalaw
wrote:

Someone sent me a spreadsheet with a formatting trick applied that I would
like to figure out how to apply myself. In this spreadsheet, column N
contained a character string. Somehow, the person who created this
spreadsheet fomatted column so that the zoom changed according to the column
width. The entire spreadsheet was formatted so that the font was Arial 10
pt. But in column N, some cells appeared to have smaller characters, even
though the font was consistently Arial 10 pt. So, the characters in cell N1,
containing the string "Assitant Director to the Managing Editor of Regional
Operations" appeared to be much smaller than cell N2, which contained the
string "Dog Catcher".
When I manually widened the column, the characters in the cells containing
longer strings appeared to get bigger, until finally the entire column
appeared to be the same size. I'm assuming that somehow the zoom level of
that one column was being manipulated based on the column width.
Does anybody know how the person who created the spreadsheet acheived this?