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.

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.

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 your table.

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 …

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 …

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 …

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 specific height or …

In the Columns dialog box, adjust the settings under Width and spacing to choose your column width and the spacing between columns. If you want columns of varying widths, deselect the checkbox …