I am running a report using an Excel macro template. One of the things that the macro does is an autoformat of the entire spreadsheet. The report has some column headings that are longer than the length of the data values for that column. When the macro does the auto format it formats based on the column values and not the column headings. Therefore, the column headings that are longer than the column values gets condensed to the length of the value which forces those column headings to go to the next line. See example below.

The column called "Bills" has a value of "11" which is shorter than the column heading. Therefore, when the autowidth formats the column heading looks like this:

Bil
ls

Can anything be done to prevent this from happening?

WF 761, Windows 7

This message has been edited. Last edited by: Michele Brooks,

Change wrap to squeeze (doesn't work in EXL07 7.7.03)...

The AutoFit Column Width in Excel is overriding the Squeeze in the WF stylesheet

You may need a slightly different macro that doesn't do the column fitting then...

quote:

Originally posted by J:
You may need a slightly different macro that doesn't do the column fitting then...

Exactly. Just autofit the data columns you want instead of the all of them.

When I have long column titles and short data, I embed line feeds in the title, the autofit the title instead of the data.

Hi Michele,

Add Cells.EntireColumn.AutoFit to your Macro and mark this topic as SOLVED.

Thanks,
Rifaz

[SOLVED] Thank you so much.

please edit in your first post and in the right most bottom there is an icon for "Edit or Delete.." , click & add [SOLVED] in the subject.

Thank you so much.