Integrity of Column Headers

[Leslie]

I have created a company form in Excel. The form has several columns and
each column has a one, two or three line column header. The form was
designed to be viewed at 100% Zoom (the viewing tool in the Standard
toolbar). Apparently some form users are viewing the form at 50% or 75%.
When viewed at less than 100%, the lines in the column headers break in odd
places, for example, when the view is reduced, the one-line header
"Quantity" breaks into two lines:
Quantit
y
and the two-line header
"Catalog
Page No." breaks into three lines:
Catalo
g Page
No.

Other than increasing the size of the cells the column headers are in, is
there a way to freeze the headers so this odd line breaking won't happen? I
tried un-selecting "Wrap Text" in the Format Cells/ Alignment/Text Control
menu and this made the headers be one line and the entire header wouldn't
display in the header cell, so that wasn't the answer I'm looking for.

Can someone help, please? Thank you for your help with my question. Leslie

 

[Jim Rech]

Excel is not always able to zoom fonts, shapes and charts to the exact view
percentage so you get these distortions. Your users will have to give up
zooming or adjust column widths, etc themselves.

 

[Leslie]

Thank you for your response, Jim. From past experience with Excel, I
suspected that when zooming smaller, controlling the line breaks in my column
headers was not going to be something I would be able to control in Excel.
Thanks for the information!
Leslie