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

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: Click …

Select the boundary of the column or row you want to move and drag it to the width or height you want. Select the rows or columns and then select Layout and choose your height and width.

On the Layout tab, in the Cell Size group, click in the Table Column Width box, and then specify the options you want. To make the columns in a table automatically fit the contents, select …

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.

If you can’t see all the data in a cell, changing the row height or column width can help: To increase the width of a single column, such as column B in the picture below, drag the …

To resize multiple columns at the same time, hold down the SHIFT key, select multiple adjacent columns, and then resize the selected columns. You can also select the entire datasheet and …

For more information about using the AutoFit command, click Microsoft Excel Help on the Help menu, type Change column width in the Office Assistant or the Answer Wizard, and then click …

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 …

Resize a chart 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 …