Question

How do you resize your worksheet columns or rows?

Answer 1

Answer:

Select the column or columns that you want to change. On the Home tab, in the Cells group, click Format. Under Cell Size, click AutoFit Column Width. Note: To quickly autofit all columns on the worksheet, click the Select All button, and then double-click any boundary between two column headings.

Answer 2

Explanation:

There's a better way.

1. Open Excel and choose a document to load. ...
2. Place the mouse pointer inside a cell and click to select it.
3. Click the Format icon in the ribbon (on the right side) and select Column Width (or Row height if you want to change the height of a Row instead).
4. Enter the desired width, and press OK.