#1
|
|||
|
|||
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? |
#2
|
||||
|
||||
Not even VBA will let you change the cell widths in smaller increments (as far as I know).
Consider a monospaced (aka nonproportional or fixed-width) font. The TrueType fonts can also have their font-size changed in increments of less than 1, but there aren't many TrueType monospaced fonts (Courier New, Lucida Console, Lucida Sans Typewriter, although you can download new fonts easily from the web (even design your own!)). There are lots of non-TrueType fonts which are monospaced too. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Fixing the size of cells in a table | village | PowerPoint | 2 | 11-06-2019 04:56 AM |
Making blank cells | aysherryan | Excel | 1 | 08-31-2018 03:31 AM |
Review Compare of docs not accurate? | ark53 | Word | 1 | 11-13-2017 09:59 PM |
making text (size/font) non editable in CONTROLS box....possible? | bjsa06 | Word | 2 | 09-22-2013 09:58 PM |