Why do different files have different sized column & row headings?

[JimJohnson]

Man, do I ever feel like a failure.

I have a bunch of files in which I size the total width and height of the worksheet to fit into PowerPoint slide without requiring any resizing. However, some of the files that I work with have differently formatted column & row headings which means the width of the row headers and the height of the column headers are slightly off. When alt-tabbing between workbooks to compare overall sheet sizes, this throws them off from the start. I haven't been able to figure out what causes this or how to modify it.

I'm sure this has a stupidly easy answer. A little help, please?

 

[JimJohnson]

Bumping, because someone must know the answer to this.

 

[Atroxell]

Perhaps try selecting all the sheets at once and re-sizing the columns all together?

 

[JimJohnson]

It's not the columns/rows themselves, its the header (is that even the right word?). A/B/C/1/2/3/etc are a different font and size, bumping the actual start of the worksheet just every so slightly down/right compared to sheets in other books. Let me whip up an image comparison.

 

[Taul]

Hi,
If you look in the bottom right corner, are all the pages set to the same zoom level

 

[JimJohnson]

So, I just compared two sheets that are sized exactly the same in terms of total number of pixels in each row and column.

I took a screenshot of each, blew them up, and measured that the column headings (not the first row, the actual letter headings of the column) of the first take up 3 more pixels of height than the other.

Zoom is the same, cell formats are the same. It MIGHT be something with the Styles, but I'm not well-versed in that area.

 

[Taul]

There is a possibility that the normal template is different in each workbook.
the link below will show how to check this, hopefully it will assist
http://blog.contextures.com/archives/2012/05/01/change-font-in-excel-column-headers/

 

[JimJohnson]

Thanks Taul, I think that was it.

I'm using Office 2013, so things are a little out of place, but when I went into Styles in the offending working, everything in the dropdown as all some variant of "20% Accent". There was no "Normal", "Good/Bad/Neutral", etc. So I actually merged the styles from one of my other workbooks into that one and it does now appear as the others do.

The selections in Styles are still the same, however. I think the most painless solution at this point is to just recreate the report on a clean new blank slate.

Thanks for the help!