Column Width in Inches, Want Pixels

[Brian D. Smith]

When I select the menu [Format | Column | Width...] the size is listed in
inches instead of pixels/points, as it used to be.

I don't know how I switched this. How do I switch it back?

 

[JE McGimpsey]

When I select the menu [Format | Column | Width...] the size is listed in
inches instead of pixels/points, as it used to be.

I don't know how I switched this. How do I switch it back?

Column width has never been in pixels/points. In previous MacXL versions
it was set in units which were equivalent to the width of the number
characters for the default font (e.g., if the width was set to 10, then
10 number characters would fit in the cell).

MacXL04 changed this to inches/cm (depending on your preferences). You
can still see the number of units if you click on the divider between
columns in the column header.

To reliably set the column width in pixels or points requires using VBA.