Excel Column Widths

[Orangearium]

Help!

Does anyone know how to fix a problem with column widths?

When the columns are "click to fit", they look fine in worksheet view, but when the sheet is printed or opened in print preview, the colums are too small, resulting in cropped/wrapped text, and lines of "#########" in numerical fields.

I've tried everything I can think of - someone must have run into this before. Any ideas?

 

[mobyduck]

I've come across something similar when printing to a postscript printer using scaleable fonts on a spreadsheet that prints elsewhere with no problems. - I think it's an issue in the actual driver.

Do you have a different printer you could try, or failing that you may have to manually tweak the column widths until it previews OK.

MD

 

[SilentAiche]

What is the nature of the data in your effected columns? If dates, check Tools/Add Ins and check both "ToolPak" options.

Hope this helps!

Tim

[blue]______________________________________________________________
I love logging onto Tek-Tips. It's always so exciting to see what the hell I
said yesterday. [/blue]