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.

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.

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

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.

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 …

Data in the cell wraps to fit the column width, so if you change the column width, data wrapping adjusts automatically. If all wrapped text is not visible, it may be because the row is set to a …

Depending on the fonts you use, column widths and row heights may appear differently when you print or view a worksheet in print preview. This behavior occurs when you use proportionally …

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 …