Why are Pixels Different with Same Column Width?

[emilyanne]

Hello,

While working in Excel 2010 on the same computer, I have two workbooks open side-by-side. In File A, my Column Width is set on 14.00 and the Pixel count equals 89; however in File B, my Column Width is also set on 14.00 but the Pixel count instead equals 103.

Why is there a difference in Pixel count? As minor as this seems, it's actually driving me slightly nutty! I have my "favored" column widths memorized and that's how all of my work templates are structured. Can someone please give some insight on this and a possible solution for the Pixel count to be the same (p.s. preferred Pixel count for 14.00 Column Width would be 89).

Thanks!
Emily

 

[oldbrewer]

check that zoom on both is set to the same value

 

[emilyanne]

Yes, both set on 100% Zoom. Same font, size, formatting, etc. for the files as well. Working in Excel all day for my job and I've never come across this before.

 

[oldbrewer]

create 2 more new workbooks, set each to column width = 14, save and close them. open each one in turn check pixels, close

now open both and put side by side - check pixels

report back