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

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.

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. Change the height of …

Select the cell or cell range that has the text or number you want to format. Click the arrow next to Font and pick another font. To change font size, click the arrow next to the default Font Size and pick the …

Right-click over the cells you've chosen and select Format Cells and, in the popup window, click the Border tab. For a continuous line, choose one of the thicker styles from the Line box.

Change column width or row height to make data more visible by dragging the column or row headers.

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 …

You can change the default units for column widths, row heights, and the graduations of the horizontal and vertical sheet rulers.

Fix data that is cut off in cells by having the text wrap automatically, changing the alignment, decreasing the font size to fit data in a cell, or rotating the text so everything fits inside a cell.

Adjust row and column size in tables when you need to fit text, make all rows or columns a uniform size, or simply make the table look how you want. Change column and row width