Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 08-14-2020, 01:33 PM
TheDuckOfDeath TheDuckOfDeath is offline Making excel cells an accurate size Windows 10 Making excel cells an accurate size Office 2019
Novice
Making excel cells an accurate size
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Making excel cells an accurate size Review Compare of docs not accurate? ark53 Word 2 06-02-2024 01:05 AM
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
making text (size/font) non editable in CONTROLS box....possible? bjsa06 Word 2 09-22-2013 09:58 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:52 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft