sitespeedsrus.blogg.se

• EXCEL FOR MAC DIFFERENCES WINDOWS

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.

EXCEL FOR MAC DIFFERENCES WINDOWS

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.