which is the smallest unit of a worksheet? where can we see its address? in MS Excel?
Answers
Answered by
8
Hello,
Is there a way to modify the smallest units for column width in Excel (2010) without changing the default font? What I mean is probably most easily explained by going directly to an example:
When Excel's default font is set to Calibri, the column width settings in the narrowest range are limited to the following:
0.00 > 0.08 > 0.17 > 0.25 > 0.33 > 0.42 > ...
In other words, if you try to set the column width to say, 0.16, it will actually set to 0.17 as the precise value 0.16 is not allowed.
On the other hand, when the default font is set to Comic Sans MS, the column width settings in the narrowest range are limited to:
0.00 > 0.08 > 0.15 > 0.23 > 0.31 > 0.38 > ...
If a column width of 0.16 is entered in this case, it is again not accepted exactly but in this case will come out as 0.15.
Is there a way to modify the smallest units for column width in Excel (2010) without changing the default font? What I mean is probably most easily explained by going directly to an example:
When Excel's default font is set to Calibri, the column width settings in the narrowest range are limited to the following:
0.00 > 0.08 > 0.17 > 0.25 > 0.33 > 0.42 > ...
In other words, if you try to set the column width to say, 0.16, it will actually set to 0.17 as the precise value 0.16 is not allowed.
On the other hand, when the default font is set to Comic Sans MS, the column width settings in the narrowest range are limited to:
0.00 > 0.08 > 0.15 > 0.23 > 0.31 > 0.38 > ...
If a column width of 0.16 is entered in this case, it is again not accepted exactly but in this case will come out as 0.15.
Answered by
24
small unit of worksheet is cell.
it's address can be seen at the left of formula bar in address box.
it's address can be seen at the left of formula bar in address box.
Similar questions