Making excel cells an accurate size
I posted a similar question in the publisher forum. I have been trying to set excel cells to an exact size so I can print onto a passport style form with separate boxes for each character.
If I set column width to 1.65 it defaults to 1.71 which it too wide. The next lowest value is 1.57. I cannot set it to any value between these 2.
I read it can be done with VBA but alas not. If I set it to 1.65 in vba it again defaults to 1.71.
I then thought I would play around with PageSetup.Zoom. 97% is slightly too large so I tried 96.9%. Again it seems to default to some specific lower value as 96.7% is exactly the same.
Playing around with these setting when they don't work as expected is going to be a faff. Is there any way to increase the accuracy available when specifying cell size so I can get it exactly right?
|