Chat with us, powered by LiveChat

AutoFit in Excel

How to Adjust Row Heights and Column Widths in Excel

When you begin working on a spreadsheet, all the rows and columns are the same size. As information is entered into the worksheet, some of the columns or rows may not be large enough to display the information they contain.

When you see ##### in a cell, it means the column width is not wide enough to show all the cell contents. Once the column width is adjusted, and the data will reappear.

Adjust Column Width

  1. Click and drag a column header’s right border to the left or right.
    Adjust Column Width

    When you position the cursor over a column heading's border, a two-headed black arrow appears. This needs to be showing before clicking and dragging.

Adjust Row Height

  1. Click and drag a row header’s bottom border up or down.
    Adjust Row Height

A line appears as you drag, showing you where the new row border will be.

AutoFit Columns or Rows

The AutoFit feature automatically resizes columns or rows to fit the cell in each column or row that has the widest or tallest contents.

  1. Double-click the column header’s right border (or the row header's bottom border).
    AutoFit Columns or Rows

Set a Row or Column Value

If you know exactly what size you want a column or row to be, you can set a precise value.

  1. Select a cell in the column or row you want to adjust.
  2. Click the Format button arrow on the Home tab.
  3. Select Row Height or Column Width.
  4. Type a row height or column width and click OK.
    Set a Row or Column Value