Link to home
Start Free TrialLog in
Avatar of Sheldon Livingston
Sheldon LivingstonFlag for United States of America

asked on

Custom Excel column width?

I wish to make an Excel column of width 2.8mm. When I do this Excel snaps the width to 2.65mm.

It appears that we can only go from 2.65mm to 2.91mm... not the exact 2.8mm

Anyone know of a workaround?
Avatar of ☠ MASQ ☠
☠ MASQ ☠

You could always use a different monitor!
Excel sets row column widths based upon the minimum unit of 1 screen pixel. So when you specify a row height or column width it will be rounded to the nearest whole number of pixels. What that actually translates to in millimeters depends entirely on your display settings.
Will a fraction of a millimeter matter?  When you print you are not controlling the toner width that separates your columns.

On the Dell P2210 I'm writing this on Excel snaps from 2.80 to 2.86 if I try to do the same thing.
Avatar of Sheldon Livingston

ASKER

I should probably explain... at the end of the day I wish to print out a 2.8mm width column.
ASKER CERTIFIED SOLUTION
Avatar of ☠ MASQ ☠
☠ MASQ ☠

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thank you for the insight!