Custom Excel column width?

Sheldon Livingston
Sheldon Livingston used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2013

Commented:
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.
Sheldon LivingstonConsultant

Author

Commented:
I should probably explain... at the end of the day I wish to print out a 2.8mm width column.
Most Valuable Expert 2013
Commented:
Then you're going to need to practice with your selected printer.

Printer DPI have the same effect, you can't print "half a dot" in much the same way you can't display "half a pixel" but printer DPI values are much higher than screen values so Excel will be able to get much closer to the value you need.
Sheldon LivingstonConsultant

Author

Commented:
Thank you for the insight!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial