Saturday, 10 December 2011

Changing Column Width and Row Height


pixel is a single point on a computer monitor or printout

The default column width is 8.38 standard-sized characters

Row heights are expressed in points or pixels, where a point is 1⁄72 of an inch

Autofitting eliminates any empty space by matching the column to the width of its longest cell entry or the row 
to the height of its tallest cell entry


Double-click the right border of a column heading or the bottom border of a row heading to AutoFit the 
column or row to the cell contents (or select one or more column or rows, click the Home tab on the Ribbon, 
click the Format button in the Cells group, and then click Auto Fit Column Width or AutoFit Row Height).

No comments:

Post a Comment