M
michalaw
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?
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?