![microsoft excel 2011 mac training microsoft excel 2011 mac training](https://www.techonthenet.com/excel/macros/images/visual_basic_editor2011_001.gif)
The amount of padding used is slightly different between Excel 2011 and later versions of Excel for Mac. Some padding (empty space) is added to the row height to fit the given font and font size. Regarding the difference in row height between Excel 2011 and later versions of Excel for Mac, Excel will automatically adjust the row height to fit the font and font size for values in any given row, unless the row height is specified manually by the user.
![microsoft excel 2011 mac training microsoft excel 2011 mac training](https://images-na.ssl-images-amazon.com/images/I/51Jq54JiZBL.jpg)
![microsoft excel 2011 mac training microsoft excel 2011 mac training](https://www.austinexcelclasses.com/wp-content/uploads/2015/03/excel_for_mac_2011_icon1-420x375.jpg)
The macOS API used by Excel to find the character width for a given font was changed due to deprecation of the API used by Excel 2011. The replacement API in some cases reports a different character width than the legacy API, which could cause differences that are unavoidable by Excel.Ĭolumn widths are shown as the number of characters or in physical units (inch or cm) which in turn is computed as a whole number of pixels. The actual column width may be rounded so that it becomes a whole number of pixels. For example, if the user adjusts a column width from 0.08” to 0.09”, the column width may not change, since both values may round to the same whole number of pixels. For this reason, columns widths set in physical units may not fit exactly in the expected physical page width. For example, if you set column widths to 1 inch, it may not result in exactly 7 columns fitting on a page that is 7 inches wide. For more information about how Excel determines column widths, go to Description of how column widths are determined in Excel. It is possible that rounding combined with the slight difference in column width calculation can lead to noticeable differences. However, there are scenarios where the differences are more noticeable, such as when you have a large number of columns to fit on a printed page. In many sheets, these differences are insignificant.
MICROSOFT EXCEL 2011 MAC TRAINING FOR MAC
For font sizes where the value is rounded down by Excel 2016 and later, the column widths will be different.įor example, if a font character width is reported as 6.48 pixels by the operating system, Excel 2011 would use 7 pixels as the character width, but later versions of Excel for Mac and Excel for Windows would use 6 pixels as the character width. If a column is 10 characters wide, it would be 10 pixels wider in Excel 2011 than in later versions of Excel for Mac and Excel for Windows. If the given font width (in pixels) is not a whole number, it is adjusted to a whole number by Excel, since partial pixels cannot be displayed. Excel 2011 adjusts to the next higher integer, but later versions of Excel round to the nearest integer, which aligns with Excel for Windows. Why is there a difference between Excel 2011 and later versions of Excel for Mac? The character width in pixels is reported to Excel by the operating system. By adjusting the size or the font in the "Normal" cell style, the widths of all columns will be recalculated and adjusted accordingly. If the font is narrow or set to a small font size, then a default column will appear narrower than if the font is wider and/or set to a larger font size. Note: The same layout differences are no longer an issue between Excel for Windows compared to more recent versions of Excel for Mac than Excel 2011.Įxcel determines the width of columns based on the character width of the font used in the “Normal” cell style, and the units for column width are "character width". A "character width" is dependent on the font and font size specified in the "Normal" cell style.