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

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 boundary on the right side …

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 boundary on the right side …

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.

Change the width of columns Click and drag across the column headings for the columns that you want to change. Column separator Column headings Note: If you have to change the width of only one …

On the Excel menu, click Preferences. Under Authoring, click General . On the Ruler units menu, click the unit of measurement that you want to use. Tip: You can also see the column width by dragging …

To change the width to a specific measurement, select a cell in the column that you want to resize. On the Layout tab, in the Cell Size group, click in the Table Column Width box, and then specify the …

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.

First, click in the column or select the columns you want to change, right-click, choose Table Properties, and then click the Column tab. Under Size, set the column's width by selecting Preferred width and …

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 spaced fonts, …