How to change the column width and row height, including how to use the AutoFit feature, in your Excel worksheet.

To set the row height to a specific measurement, select a cell in the row that you want to resize. On the Layout tab, in the Cell Size group, click in the Table Row Height box, and then specify …

To change the height of a single row, drag the boundary below the row heading until the row is the height you want. To decrease the height, drag the bottom boundary up.

For example, you can see how a change that you make to the row height and column width affects the placement of the automatic page breaks. To override the automatic page breaks …

To automatically adjust the row height, select AutoFit Row Height. To specify a row height, select Row Height, and then type the row height that you want in the Row height box.

You can also choose the options in the Cell Size group to resize the rows and columns. On the Table Layout tab, in the Cell Size group, enter the size that you want in the Height and Width …

In the Scale to Fit group, in the Width dropdown list, select 1 page, and in the Height dropdown list, select Automatic. Columns will now appear on one page, but the rows may extend to more …

Tip: To set an exact height measurement, on the Format menu, point to Row, and then click Height. Change the height of all rows on a sheet Select all cells on the sheet by clicking the …

First, click in the row or select the rows you want to change, right-click, choose Table Properties, and then click the Row tab. Under Size, set the row's height by selecting Preferred height and …

Right-click inside the cell you want to change, and click Format Cells. On the Alignment tab, change Vertical to Top, Center, or Bottom, depending on where you want your text to be …