Sheldon Livingston
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?
It appears that we can only go from 2.65mm to 2.91mm... not the exact 2.8mm
Anyone know of a workaround?
ASKER
I should probably explain... at the end of the day I wish to print out a 2.8mm width column.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you for the insight!
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.