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

Select Table Design > Resize Table. Select the entire range of cells you want your table to include, starting with the upper-most cell. In the example shown below, the original table …

Select the rows or columns and then select Layout and choose your height and width. Select View > Ruler checkbox, select the cell you want, and then drag the markers on the ruler.

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 …

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.

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 …

On the Layout tab, in the Cell Size group, select AutoFit, and then select AutoFit Contents. To use the ruler, select a cell in the table, and then drag the markers on the ruler.

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 …

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 …

When you change the size of cells on the sheet, 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 with the …