The three ways to resize cells in Excel

You can change cell width and height in Excel by dragging the column or row border, by double-clicking to auto-fit the content, or by entering exact measurements in the Format menu. The method you choose depends on whether you want to fit content automatically, make a quick visual adjustment, or set a precise size.

The fastest method for most people is dragging: position your cursor on the border between two column letters (or row numbers) until it becomes a resize cursor, then drag left or right to widen or narrow. Double-clicking that same border auto-fits the column width to whatever text or numbers are inside, which saves time when you have varying content lengths.

If you need exact dimensions — say, all columns exactly 2 inches wide for a printed report — use the Format menu instead of dragging by eye. This approach also works when you want to change many cells at once without selecting them individually.

Key Takeaways

  • Drag the border between column letters to widen or narrow a column, or between row numbers to change row height.
  • Double-click the border between column letters to auto-fit the width to whatever content is inside that column.
  • Select multiple columns or rows, then use Format > Column Width or Format > Row Height to set exact measurements for all of them at once.
  • Excel remembers your column widths and row heights when you save the file, so you only need to resize once unless the content changes.

Dragging to resize a single column or row

Position your cursor on the vertical line between two column letters at the top of the spreadsheet. The cursor will change to a resize icon (a line with arrows pointing left and right). Click and drag to the right to widen the column, or to the left to narrow it. Release the mouse when the column reaches the width you want.

For row height, do the same thing with the horizontal line between two row numbers on the left side of the spreadsheet. Drag down to make the row taller, or up to make it shorter. This is useful when you have wrapped text that needs more vertical space, or when you want to make a header row visually prominent.

If you drag too far and want to undo, press Ctrl+Z (or Cmd+Z on Mac) to revert the change. You can also double-click the border to auto-fit instead of dragging — Excel will automatically set the width or height to fit the content inside.

Auto-fitting columns and rows to content

Double-click the border between two column letters, and Excel automatically widens that column to fit the longest entry inside it. This saves time when you have a mix of short and long text — you do not have to guess the right width.

To auto-fit multiple columns at once, select them first. Click on the column letter for the first column you want to resize, then hold Shift and click the last column letter. Now double-click any border between the selected columns, and all of them will auto-fit to their content.

The same method works for rows: select the rows you want to resize, then double-click the border between any two row numbers. Excel will adjust all selected rows to fit their content. This is especially useful after you paste data from another source and the rows are too narrow or too tall.

Setting exact column width or row height

Click on the column letter to select the entire column. Then go to the Format menu at the top, click Column Width, and type the exact width you want (measured in character units, where one unit is the width of the number 0 in the default font). Click OK.

For row height, select the row by clicking its number, then go to Format > Row Height and type the height in points (a point is 1/72 of an inch). This method is more precise than dragging and is useful when you need consistent sizing across a spreadsheet or when preparing a document for printing.

To change multiple columns or rows to the same size, select them all first. Click the first column letter, hold Shift, and click the last column letter you want to include. Then open Format > Column Width and enter your measurement — all selected columns will change to that width at once.

Resizing columns and rows for printed documents

When you plan to print your spreadsheet, column width and row height affect how the document looks on paper. Narrow columns save space but can make text hard to read; tall rows use more pages but give your data room to breathe. Adjust sizes before you print so the final document looks the way you want.

Use Format > Column Width to set all data columns to the same width, which creates a clean, uniform appearance. For headers or labels you want to stand out, make those rows taller using Format > Row Height. Test by going to File > Print Preview to see how your sizing choices look before you actually print.

If your spreadsheet is too wide to fit on one page, you can either narrow the columns or use File > Print > Scaling to shrink the entire document. Resizing individual cells is usually better than scaling, because scaling can make text too small to read.

Undoing and resetting cell sizes

If you resize a column or row and change your mind, press Ctrl+Z (Cmd+Z on Mac) when ready to undo. You can undo multiple resize actions by pressing Ctrl+Z several times. If you have already saved the file, you cannot undo — you will need to resize manually or close without saving and reopen the original.

To reset all columns to Excel's default width, select all cells by clicking the box in the top-left corner (where the column letters and row numbers meet). Then go to Format > Column Width and type 8.43, which is the standard default. For rows, use Format > Row Height and type 15.

If you only want to reset some columns or rows, select just those ones first, then use the same Format menu steps. This is useful if you have accidentally resized a few columns and want to return them to normal without affecting the rest of the spreadsheet.

Why your column widths change when you paste data

When you paste data from another spreadsheet or document into Excel, the new content might be wider or taller than your current column or row sizes. Excel does not automatically resize to fit — you have to do it manually. Double-clicking the column border to auto-fit is the quickest fix.

If you paste a large block of data and many columns need resizing, select all the columns at once (click the first column letter, hold Shift, click the last), then double-click any border between them. All selected columns will auto-fit to their content in one action.

To avoid this problem in the future, you can set your columns wider before you paste, or you can paste first and then auto-fit. Neither approach is wrong — choose whichever fits your workflow better.

Frequently Asked Questions

How do I make all columns the same width?

Select all columns by clicking the box in the top-left corner where the row numbers and column letters meet. Then go to Format > Column Width, type the width you want, and click OK. All columns will change to that width at once.

Can I resize a column by typing a number instead of dragging?

Yes. Select the column, go to Format > Column Width, and type the exact width you want in character units. Click OK. This is more precise than dragging and ensures all your columns are exactly the same size if you need them to be.

What does auto-fit do if my text is still cut off?

Auto-fit sets the column width to match the longest entry in that column. If text is still cut off, the entry itself may be longer than what is visible in the cell — check by clicking the cell and looking at the formula bar at the top. You may need to widen the column more by dragging or by entering a larger width in the Format menu.

Does Excel remember my column widths if I close and reopen the file?

Yes, as long as you save the file. Excel stores your column widths and row heights as part of the file. If you resize columns, close the file without saving, and reopen it, the columns will return to their previous size.

How do I make a row taller to fit wrapped text?

Double-click the border between the row numbers to auto-fit the row height to the wrapped text inside. If that does not work, select the row and go to Format > Row Height, then type a larger number (measured in points). You may need to try a few sizes to get it right.