Column width and row height

A pixel is a single point on a computer monitor or print out. 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. Auto fitting 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
Drag the right border of the column heading left to decrease the column width or right to increase the column width. Drag the bottom border of the row heading up to decrease the row height or down to increase the row height

or

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 AutoFit Column Width or AutoFit Row Height)

or

Select one or more columns or rows. Click the Home tab on the Ribbon, click the Format button in the Cells group, and then click Column Width or Row Height. Enter the column width or row height you want, and then click the OK button

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

*

code

clearPost Comment