Headings change when sent to email recipeint

J

johnf45

I have created a spreadsheet that uses vertical names in the colum
headings. When I send the spreadsheet to an email recipient, th
headings revert to a horizontal format and are unreadable because o
the narrow width of the columns. How can I prevent this from happening
 
B

Brod

John,

Your recipient would have to have the same settings as you. To overcome the
problem get your recipient to double click in the division line between the
columns. For example, if the unreadable text is in column A, then double
click on the line between A and B. That will expand the column A to the
widest entry in the column.
 
D

Dave Peterson

What is the format of the file that you're emailing?

Is it an .xls file or a .csv file.

If it's a .csv, then what's happening is normal. Try sharing a the .xls version
(saved as normal workbook).

If it's a .xls, then the only time I've seen people complain about not retaining
columnwidths is with xl97 and many say that upgrading to xl97SR2 fixes the
problem (some say that doesn't help, though).

When you click on Help|about, what version do you see?

If it's not xl97sr2, I'd install it.

the kb article has a link to this:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;151261
OFF97: How to Obtain and Install Office 97 SR-2

(and ask the same question to the recipient)
 
Top