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

Change column width or row height to make data more visible by dragging the column or row headers.

In the Standard toolbar, click Copy . Select any cell in the column where you want to copy the width. On the Edit menu, click Paste Special, select Column Widths, and then click OK. …

Change column width or row height to make data more visible by dragging the column or row headers.

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 …

On the Layout tab, in the Cell Size group, click in the Table Row Height box, and then specify the height you want. To use the ruler, select a cell in the table, and then drag the markers on the …

You can change the default units for column widths, row heights, and the graduations of the horizontal and vertical sheet rulers.

Select the rows or columns and then select Layout and choose your height and width. Select View > Ruler checkbox, select the cell you want, and then drag the markers on the ruler.

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.

To change the size manually, click the chart, and then drag the sizing handles to the size that you want. To use specific height and width measurements, on the Format tab, in the Size group, …