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 the height you …

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.

Add, adjust or remove page breaks in Excel using Page Break Preview. Also, learn how to reset and hide 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.

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 than one …

On the Table Layout tab, in the Cell Size group, enter the size that you want in the Height and Width boxes. There is a minimum cell height, which depends on the font size of the text in the table cell.

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 placed inside the cell.

After you create an Excel table in your worksheet, you can easily add or remove table rows and columns. You can use the Resize command in Excel to add rows and columns to a table:

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 Select All …