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. …

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 …

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. …

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.

When you change the size of cells on the worksheet, the size of the chart adjusts accordingly. You can change this positioning option if you don't want to move or resize the chart together …

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 …

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 shrink the contents of a cell so that they fit in the current column width, on the Home tab, click the Format button, click Format Cells, and then select Shrink to Fit.