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.

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

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 …

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.

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:

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 …

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 Search to …

To make all rows in the table the same height, select Layout > Distribute Rows. To make all the columns in the table the same height, select Layout > Distribute Columns.

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.