The three ways to resize cells in Excel

You can change cell size in Excel by dragging the column or row border, by typing a specific width or height, or by using the auto-fit feature to match the content. The method you choose depends on whether you want to resize one cell, a whole column or row, or multiple cells at once.

Excel measures column width in character units (how many digits fit across) and row height in points (a printer measurement). You do not need to remember these units—Excel handles the math when you drag or type a number.

Key Takeaways

  • Drag the border between column letters or row numbers to resize cells by eye, and double-click that border to auto-fit the content.
  • Right-click a column or row header and select Column Width or Row Height to type an exact size.
  • Select multiple columns or rows and resize them all at once using the same methods.
  • Auto-fit works best when your text is short; for long text, you may need to manually widen the column or turn on text wrapping.

Dragging the column border to resize width

The fastest way to change column width is to position your cursor on the line between two column letters at the top of the sheet. The cursor will change to a resize arrow (a double-headed line). Click and drag left to make the column narrower or right to make it wider, then release.

This method resizes only the column you dragged. If you want to resize multiple columns at the same width, select all of them first by clicking the first column letter, holding Shift, and clicking the last column letter. Then drag the border of any selected column, and all of them will resize together.

If you drag too far and the column becomes too narrow to display the content, Excel shows a small triangle or the text overflows into the next cell. You can always drag again to fix it.

Double-clicking the border to auto-fit column width

Double-click the border between two column letters, and Excel automatically widens or narrows that column to fit the longest text or number inside it. This is the quickest way to make a column just wide enough for its content without guessing.

Auto-fit works on the column to the left of the border you double-click. If you have selected multiple columns, double-clicking the border of any selected column will auto-fit all of them at once.

Auto-fit does not account for text wrapping. If you have turned on wrap text in a cell, the column width may not change, because Excel considers the wrapped text to fit within the current width.

Typing an exact column width or row height

Right-click any column letter and select Column Width from the menu. A dialog box will appear where you can type a number. The default unit is character width—a value of 20 means the column is wide enough for about 20 characters. Click OK to explore it.

For row height, right-click any row number and select Row Height. Type a number in points (72 points equals one inch). A standard row is about 15 points tall. Click OK to explore the change.

This method is useful when you need the same width or height across multiple sheets or when you want to match a specific measurement. You can also select multiple columns or rows before right-clicking, and the width or height you enter will explore to all of them.

Resizing multiple columns or rows at once

Select the columns or rows you want to resize by clicking the first header, holding Shift, and clicking the last header. You can also click one header, hold Ctrl, and click others to select non-consecutive columns or rows.

Once selected, you can drag the border of any selected column or row to resize them all together, or right-click and choose Column Width or Row Height to type an exact size for all of them. Double-clicking the border will auto-fit all selected columns or rows to their content.

If you want to resize all columns or rows on the sheet at once, click the select-all button (the small square where the row numbers and column letters meet) to select the entire sheet, then drag any column or row border or use the right-click menu.

Using the Format menu for column and row options

Open the Format menu at the top of the screen. You will see options for Column and Row. Hover over Column to see choices like Width, Auto Fit Column Width, Hide, and Unhide. Hover over Row to see Height, Auto Fit Row Height, Hide, and Unhide.

This menu is another way to access the same resizing tools without right-clicking. It is useful if you prefer using the menu bar or if right-clicking does not work on your device.

When to call in help

If you are working with a spreadsheet that has many columns and rows and you need them all to fit on one printed page, you may want to use the Page Layout tools instead of resizing cells manually. Excel has print scaling options that shrink or enlarge the entire sheet to fit a page size.

If you are trying to resize cells in a shared workbook or a file that is locked for editing, you may not be able to change the size. Ask the file owner or manager whether the sheet is protected or read-only.

Frequently Asked Questions

How do I make all columns the same width?

Select all columns by clicking the select-all button, then right-click any column letter and choose Column Width. Type the width you want and click OK. All columns will resize to that width. Alternatively, drag the border of any column while all are selected, and they will all resize together.

Why does my text still not fit after I widen the column?

The column may be wide enough, but the text is wrapping to multiple lines within the cell. Right-click the cell and choose Format Cells, then go to the Alignment tab and turn off Wrap Text. Or, widen the column more. You can also increase the row height to show all the wrapped lines.

Can I resize a cell without resizing the whole column?

No. In Excel, a cell is part of a column and row, so resizing a cell always resizes the entire column or row. If you need different widths for different cells, you may need to split columns or use a different layout.

What is the difference between column width and row height?

Column width controls how far left to right a cell extends, measured in character units. Row height controls how far top to bottom a cell extends, measured in points. Both are independent—changing one does not affect the other.

How do I undo a resize if I made a mistake?

Press Ctrl+Z (or Cmd+Z on Mac) to undo the last resize. You can undo multiple times to go back further. If you have closed the file, you cannot undo—so save your work before making large changes.