Changing cell size in Excel means adjusting how wide your columns are or how tall your rows are

Excel cells come with default widths and heights that work for most text, but you often need to make them bigger so content fits without cutting off, or smaller to fit more on one page. You can resize a single cell, an entire column or row, or multiple columns and rows at once. The fastest methods use your mouse to drag the borders between column and row headers, or you can use the Format menu to set exact measurements.

The three main ways to resize are: dragging the border between column or row headers with your mouse, double-clicking that border to auto-fit the content, or using the Format menu to enter a specific width or height in inches or centimeters. Which you choose depends on whether you want to eyeball the size or be precise.

Key Takeaways

  • Drag the border between two column letters to widen or narrow that column, or drag the border between row numbers to change row height.
  • Double-click the border between column or row headers to auto-fit — Excel will size it to fit the longest content in that column or row.
  • Right-click a column or row header and choose Column Width or Row Height to enter an exact measurement.
  • Select multiple columns or rows by clicking one header, holding Shift, and clicking another, then resize them all at once.
  • The Format menu (under the Home tab) also contains Column Width and Row Height options if you prefer not to right-click.

Resizing a single column by dragging

Position your mouse on the border between two column letters at the top of the spreadsheet — for example, between the A and B headers. Your cursor will change to a resize cursor that looks like a line with arrows pointing left and right. Click and drag to the right to make column A wider, or to the left to make it narrower. Release the mouse when the column is the size you want.

This method is the fastest when you can see roughly how wide you need the column to be. If you drag too far, you can always drag back. The column will stay that width until you resize it again, even if you close and reopen the file.

Auto-fitting a column to its content

Double-click the border between two column letters. Excel will when ready resize the left column to fit the longest piece of text or number in that column. This is useful when you have text that is cut off and you do not want to guess at the right width.

If a column contains a long sentence in one cell and short text in others, auto-fit will make the column wide enough for that sentence. If you later add longer text to that column, you will need to auto-fit again — the column does not resize on its own.

Resizing a single row by dragging

Position your mouse on the border between two row numbers on the left side of the spreadsheet — for example, between rows 1 and 2. Your cursor will change to a resize cursor with arrows pointing up and down. Click and drag down to make row 1 taller, or up to make it shorter. Release when the row is the height you want.

Rows are usually resized less often than columns, but you may need to make a row taller if you have text that wraps to multiple lines within a cell. You can also auto-fit a row by double-clicking the border between row numbers, just as you do with columns.

Setting an exact width or height with the Format menu

Right-click on a column header and select Column Width from the menu. A small dialog box will appear asking for a width in inches. Type the number you want — for example, 1.5 for one and a half inches — and click OK. The column will resize to that exact width.

To set an exact row height, right-click a row number and select Row Height. Enter the height in inches and click OK. This method is useful when you need columns or rows to match a specific size, such as when you are formatting a document to print on a particular page size.

You can also access these options through the Home tab at the top of Excel. Click the Format button (it looks like a small grid), then select Column Width or Row Height from the dropdown menu.

Resizing multiple columns or rows at once

Click on the first column header you want to resize. Hold down Shift and click on the last column header in the range. All columns between them will be highlighted in blue. Now drag the border between any two of the selected column headers 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. You can also right-click any of the selected headers and choose Column Width or Row Height to set an exact size for all of them at once.

If you want to resize non-adjacent columns — for example, columns A and C but not B — click column A, then hold Ctrl (or Cmd on a Mac) and click column C. Both will highlight, and you can resize them together.

Undoing a resize if you change your mind

If you resize a column or row and decide you do not like the new size, press Ctrl+Z (or Cmd+Z on a Mac) to undo. You can undo multiple resize actions by pressing Ctrl+Z several times. This works as long as you have not closed the file — once you close and reopen, the undo history is gone.

If you want to return a column to its default width without undoing, right-click the column header, select Column Width, and type 0.89 (the Excel default). For rows, the default height is 0.19 inches, though this can vary slightly depending on your font size.

Frequently Asked Questions

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

The text may be wrapping to multiple lines within the cell. If you see text on two or three lines inside one cell, you need to make the row taller, not the column wider. Double-click the border between the row numbers to auto-fit the row height, or drag it down manually.

Can I make all columns the same width at once?

Yes. Click the select-all button (the small square in the top-left corner where the row numbers and column letters meet), then right-click any column header and choose Column Width. Enter the width you want, and all columns in the spreadsheet will resize to that width.

What is the difference between column width and the actual space on my screen?

Column width is measured in inches or centimeters, not pixels. The actual space it takes on your screen depends on your zoom level and monitor size. If you zoom in to 150%, a 1-inch column will look larger. The width measurement stays the same, but the visual size changes.

Does resizing a column affect the data in that column?

No. Resizing only changes how the column looks on screen and when printed. The actual data — the numbers, text, and formulas — stays exactly the same. You can resize columns as many times as you want without changing any content.

How do I make a column just wide enough to see the column letter?

Drag the border between column headers all the way to the left until the column is very narrow. You can make it so narrow that the content is completely hidden, though the data is still there. To see the content again, widen the column by dragging the border to the right.