![]() ![]() 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |