1
A couple of weeks ago, I was working in Microsoft Excel 2016 for Mac, using an Office 365 subscription in the standard channel. When I would select a column and then "Column Width", my recollection is that I would be able to specify the width of the column in inches.
However, I am now working in Excel—version 15.33 (170409)
, though I also see it on another computer that's on 15.32 (170309)
—and when I select "Column Width", I now am getting the same sorts of numbers like I'd see in Excel for Windows; e.g., the default column width is "10".
I can find absolutely no documentation of this change.
Is my memory faulty, or did this change, and where is that documented?
Furthermore, is there a way I can change it back at will?
EDIT: I installed an old version of Excel (15.31 (170216)
) and it does, in fact, still give me inches:
But here is a screenshot from 15.32 (170309)
:
So the change appears to be in the March release. Where is the documentation/rationale for this?
I don't have 2016, but did you try File>Options>Advanced>Display>Ruler Units ? – Tetsujin – 2017-04-16T07:32:43.900
On the Excel menu, click Preferences.Under Authoring, click General Preferences button .On the Ruler units pop-up menu, click the unit of measurement that you want to use. – yass – 2017-04-16T21:07:37.943
The Ruler Units are and have been Inches this whole time. My only other options are "Centimeters" and "Millimeters". Changing that (just to make sure) does not make a difference to the number in Column Width; the default column width steadfastly remains "10".
Prior to this, the default column width was something like
0.87"
. – Kate Bertelsen – 2017-04-18T03:44:25.827@Tetsujin: This is on macOS; there is no
Options
item underFile
. – Kate Bertelsen – 2017-04-18T03:49:43.680