The fastest way to resize cells in Excel

You can change cell width and height in Excel in three ways: drag the border between column or row headers, double-click to auto-fit, or use the Format menu. The drag method is quickest for one or two cells. Auto-fit works best when you want Excel to size cells based on their content. The Format menu gives you exact measurements if you need precision.

All three methods work the same way whether you use Excel on Windows, Mac, or the web version. The steps below cover the desktop versions, which are the most common.

Key Takeaways

  • Drag the border between column letters or row numbers to resize cells manually, and double-click that same border to auto-fit the cell to its content.
  • Select multiple columns or rows before dragging to resize them all at once to the same width or height.
  • Use Format > Column Width or Format > Row Height to enter exact measurements in inches or centimeters.
  • Auto-fit works best for text that is cut off; it sizes the cell to show all content without manual adjustment.

Resize a single column by dragging

Position your cursor on the border between two column letters at the top of the spreadsheet. The cursor will change to a resize arrow (a double-headed line). Click and drag to the right to make the column wider, or to the left to make it narrower. Release the mouse button when the column reaches the size you want.

This method works for any column width you choose. If you drag too far, you can drag back to adjust. The column stays at whatever width you set until you change it again.

Resize a single row by dragging

Position your cursor on the border between two row numbers on the left side of the spreadsheet. The cursor will change to a resize arrow. Click and drag down to make the row taller, or up to make it shorter. Release when the row is the height you want.

Row height is useful when you have text that wraps to multiple lines within a cell. Making the row taller lets you see all the wrapped text without opening the cell for editing.

Auto-fit a column or row to its content

Double-click the border between two column letters (or two row numbers) without dragging. Excel will measure the longest text or largest number in that column or row and resize it automatically to fit. This is the fastest way to fix columns where text is cut off.

Auto-fit works on one column or row at a time. If you want to auto-fit multiple columns at once, select all of them first by clicking the first column letter, holding Shift, and clicking the last column letter you want to resize. Then double-click any border between the selected columns.

Resize multiple columns or rows at the same time

Click the first column letter you want to resize, then hold Shift and click the last column letter. All columns between them will be highlighted. Now drag the border between any two of the selected column letters to the right or left. All selected columns will resize to the same width.

The same method works for rows. Click the first row number, hold Shift, click the last row number, then drag the border between any two selected rows up or down. All selected rows will become the same height.

Set exact cell dimensions using the Format menu

Right-click on a column letter and select Column Width from the menu. A box will appear where you can type a number. Excel measures column width in character units (the width of one character in the default font). Type the number you want and click OK.

For rows, right-click a row number and select Row Height. Type the height in points (a point is 1/72 of an inch). Click OK when you are done. This method is useful when you need the same dimensions across multiple spreadsheets or when you want to match a specific size.

You can also access these options through the menu bar. Click Format at the top, then choose Column or Row, then Width or Height.

Reset columns and rows to their default size

To return a column to its default width, right-click the column letter and select Column Width. Type 8.43 (the standard Excel column width) and click OK. For rows, right-click the row number, select Row Height, type 15, and click OK.

If you have resized many columns or rows and want to reset them all at once, click the select-all button (the box in the top-left corner where the row numbers and column letters meet). Then right-click any column letter or row number and choose the reset option. All cells will return to their default size.

Frequently Asked Questions

Why is my text cut off even after I made the column wider?

The column may be wide enough, but the text inside the cell may be set to wrap. Right-click the cell, select Format Cells, go to the Alignment tab, and check whether "Wrap text" is turned on. If it is, the text breaks into multiple lines within the cell, and you may need to make the row taller to see all of it. If wrap text is off, the column should be wide enough to show the full text.

Can I set the same width for all columns at once?

Yes. Click the select-all button in the top-left corner to highlight every cell. Then right-click any column letter, select Column Width, type the width you want, and click OK. Every column in the spreadsheet will become that width. You can undo this with Ctrl+Z if you change your mind.

What is the difference between column width and row height measurements?

Column width is measured in character units (how many characters fit across). Row height is measured in points, where 72 points equals one inch. The default column width is 8.43 characters, and the default row height is 15 points. You can use either measurement system depending on what you need.

Does resizing cells change the data inside them?

No. Resizing only changes how much space the cell takes up on the screen. The data itself stays the same. If you make a cell narrower and the text no longer fits, the text is still there — it is just hidden. Making the cell wider again will show it.