View Single Post
 
Old 08-14-2020, 01:33 PM
TheDuckOfDeath TheDuckOfDeath is offline Windows 10 Office 2019
Novice
 
Join Date: Aug 2020
Posts: 2
TheDuckOfDeath is on a distinguished road
Default 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?
Reply With Quote