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?
Pivot Charts for Excel 2016 for Mac. Pivot Charts have finally made their way into the Mac version of Excel. This means you can now create interactive dashboards with pivot tables, charts, and slicers on the Mac. Great video Jon. I just upgraded to Mac Excel 15.39 as part of Office 365. The pivot chart feature that you.
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? The current behavior seems to be documented here: 'The standard column width in Microsoft Excel 2000 is 8.43 characters' etc. But I can confirm that in the previous version of Excel (2011) that I have installed on another machine it was indeed shown in cm (the rule unit configured).
Now in 15.33 this setting does not seem to have any effect for me, either. Also, you can still enter the width you want explicitly. When I enter '5 cm' that's what I will get, even though after revisiting the dialog box again it will display '27,4'.