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 measurement, or by using the auto-fit feature. The method you choose depends on whether you want to resize one cell, a whole column or row, or multiple cells at once. Most people find dragging the fastest for quick adjustments, but typing measurements gives you exact control when you need it.
Excel measures column width in character units (roughly how many letters fit across) and row height in points (a printing measurement). You do not need to understand these units to resize—Excel handles the math—but knowing they exist explains why the numbers look unfamiliar when you see them.
Key Takeaways
- Drag the border between column letters or row numbers to resize quickly by eye, or double-click that border to auto-fit content to the cell.
- Right-click a column or row header and select "Column Width" or "Row Height" to type an exact measurement.
- Select multiple columns or rows before resizing to change them all at once to the same size.
- Auto-fit works best when your text is complete; if you add more text later, the cell will not expand automatically.
Dragging the column or row border to resize by eye
Position your cursor on the line 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 arrow—a double-headed line pointing left and right. Click and drag to the right to make the column wider, or to the left to make it narrower. Release the mouse when the column reaches the size you want.
The same method works for rows. Position your cursor on the line between two row numbers on the left side of the spreadsheet, wait for the resize arrow to appear, then drag up or down. This is the fastest way to adjust cell size when you do not need an exact measurement.
Double-clicking the border to auto-fit content
Double-click the border between two column letters (or two row numbers) and Excel automatically widens or lengthens the cell to fit all the text inside. This saves time when you have text that is cut off and you want the cell to expand just enough to show it all.
Auto-fit looks at the content that is currently in the cell. If you add more text later, the cell will not expand again on its own—you will need to auto-fit a second time. If your column contains numbers that are too wide and display as #### symbols, auto-fit will fix that when ready.
Typing an exact column width or row height
Right-click on the column letter (or letters if you selected multiple columns) and choose Column Width from the menu. A small dialog box will appear with a text field. Type the width you want—the number represents character units, so a width of 20 means roughly 20 letters can fit across. Click OK.
For rows, right-click the row number and select Row Height. Type the height in points (a standard printing measurement). Most rows default to 15 points. If you want a row that is twice as tall, type 30. This method is useful when you need cells to match a specific size across multiple spreadsheets or when you are formatting a document for printing.
Resizing multiple columns or rows at once
Click on the first column letter, then hold Ctrl (or Cmd on a Mac) and click on each additional column you want to resize. All selected columns will highlight in blue. Now drag the border of any selected column, and all of them will resize together to the same width. The same technique works for rows—select them, then drag any row border.
If you want to resize all columns in your spreadsheet at once, click the box in the top-left corner (where the row numbers and column letters meet) to select the entire sheet. Then drag any column or row border to resize everything. This is helpful when you are starting a new spreadsheet and want uniform cell sizes from the start.
When cells show #### instead of numbers
The #### symbol means the column is too narrow to display the number or date inside. Double-click the border between the column letters to auto-fit, or drag the border to the right until the number appears. This is not an error—the data is still there, just hidden from view.
This happens most often with dates and times, which take up more space than they appear to. If you widen the column and the number still shows as ####, the problem is usually that the cell is formatted as a number but contains text, or the number itself is extremely long. Check the formula bar at the top to see what is actually in the cell.
Resizing cells in a frozen pane or filtered range
If you have frozen rows or columns (a feature that keeps headers visible while you scroll), you can still resize them the same way—drag the border or double-click to auto-fit. The frozen pane does not lock the cell size, only the position.
When you have filtered data (showing only certain rows), resizing works normally and affects all rows in the column, not just the visible ones. If you resize a column and the hidden rows seem to change size when you remove the filter, that is because they were already that size—the filter was just hiding them.
Frequently Asked Questions
Can I set a minimum or maximum cell size?
Excel does not have a built-in minimum or maximum size limit. You can make a cell as small as a single character or as large as the entire spreadsheet. If you need cells to stay within a certain range, you will have to resize them manually or use a macro (an advanced automation tool).
Does resizing a cell change the data inside it?
No. Resizing only changes how much space the cell takes up on screen. The actual data—the text, numbers, or formulas—stays exactly the same. If you make a cell very small, the content may be hidden or cut off visually, but it is still there and will reappear if you widen the cell again.
Why does my column width keep changing when I type?
If you have auto-fit turned on for that column, Excel may be adjusting the width as you type. You can turn this off by right-clicking the column and unchecking any auto-fit option, or by manually setting a specific column width. After that, the column will stay the size you set it to.
How do I make all cells in a spreadsheet the same size?
Click the select-all box (the corner where row numbers and column letters meet), then right-click and choose "Column Width" or "Row Height." Type the size you want and click OK. Every cell in the spreadsheet will resize to that measurement.
Can I resize cells on a Mac the same way as Windows?
Yes. Dragging borders, double-clicking to auto-fit, and right-clicking to type measurements all work the same way on Mac Excel. The only difference is that you use Cmd instead of Ctrl when selecting multiple non-adjacent columns or rows.