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

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 …

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:

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 …

When you change the size of cells on the worksheet, the size of the chart adjusts accordingly. You can change this positioning option if you don't want to move or resize the chart together …

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.

If you’re new to touch devices, learning a few gestures will help you take maximum advantage of the touch capabilities. Moving around in a file ... Making a Selection ... Working with Columns …