The three ways to change cell size 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 to let Excel size cells to their content. The method you choose depends on whether you want one cell, a whole column or row, or multiple cells at once.
The fastest way for a single adjustment is dragging. The most precise way is typing a number. Auto-fit is best when you have text that does not fit and you want Excel to figure out the right size without guessing.
Key Takeaways
- Drag the border between column letters or row numbers to resize cells by eye — position your cursor on the line until it becomes a resize arrow, then drag left or right for columns, up or down for rows.
- Right-click a column letter or row number, select Column Width or Row Height, and type a number to set an exact size in inches or points.
- Double-click the border between column letters to auto-fit the column width to the longest text in that column.
- Select multiple columns or rows before resizing to change them all at once.
- Excel measures column width in character units and row height in points — the exact pixel size depends on your screen resolution and zoom level.
Dragging column and row borders to resize by eye
Position your cursor on the line between two column letters at the top of the spreadsheet. When the cursor changes to a resize arrow (a double-headed arrow 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 button when the column is 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. When the cursor becomes a resize arrow (pointing up and down), click and drag down to make the row taller or up to make it shorter.
This method is quick but not precise — you are sizing by eye, so if you need an exact measurement, use the width or height dialog instead.
Setting exact column width or row height with numbers
Right-click the column letter you want to resize. A menu appears. Click Column Width. A dialog box opens asking for a number. Type the width you want and click OK. Excel measures column width in character units — the number represents how many characters of the default font fit in that column.
For rows, right-click the row number, click Row Height, type the height in points (a point is 1/72 of an inch), and click OK. If you want the row to fit the text inside it without extra space, use auto-fit instead.
If you do not know what number to use, start with 20 for a standard column width or 15 for a standard row height, then adjust from there. You can always change it again if it is not right.
Using auto-fit to size cells to their content
Double-click the border between two column letters. Excel automatically widens that column to fit the longest text or number in it. No dialog box appears — the resize happens when ready.
For rows, double-click the border between two row numbers. Excel automatically makes that row tall enough to display all the text in the tallest cell in that row.
Auto-fit is useful when you have text that is cut off or wrapped across multiple lines and you want Excel to handle the sizing for you. If a cell contains a formula that produces a very long result, auto-fit will make the column wide enough to show the whole result without wrapping.
Resizing multiple columns or rows at once
Click the first column letter, then hold Shift and click the last column letter in the range you want to resize. All columns between them are now selected (they appear highlighted). Right-click any of the selected column letters and click Column Width. Type the width and click OK. All selected columns become that width.
The same process works for rows. Click the first row number, hold Shift, click the last row number, right-click, select Row Height, type the height, and click OK.
You can also select all columns or all rows at once by clicking the button in the top-left corner of the spreadsheet (where the row numbers and column letters meet). Then right-click and set the width or height for the entire sheet.
Understanding column width units and why sizes look different on different screens
Excel measures column width in character units, not pixels or inches. One unit equals the width of one character in the default font (usually Calibri or Arial). This means a column width of 20 will hold about 20 characters, but the actual pixel width depends on your screen resolution, zoom level, and which font you are using.
Row height is measured in points. One point equals 1/72 of an inch. A row height of 15 points is about 0.2 inches tall. If you zoom in or out, the row height stays the same in points, but looks bigger or smaller on your screen.
This is why a spreadsheet can look different on someone else's computer even if you both have the same file open. If exact sizing matters for printing, test the print preview before you print.
What to do if a column is too narrow and text is hidden
If a cell contains text that does not fit in the column, Excel either cuts off the text (if the next cell is full) or hides it (if the next cell is empty). The text is still in the cell — it is just not visible. Double-click the border between the column letters to auto-fit the column width, or drag the border to make the column wider by hand.
If a cell contains a number that is too wide for the column, Excel displays #### instead of the number. This is Excel's way of telling you the column is too narrow. Widen the column the same way — double-click the border to auto-fit, or drag it wider.
Frequently Asked Questions
Can I change the size of just one cell without changing the whole column?
No. In Excel, column width applies to the entire column and row height applies to the entire row. If you change the width of column B, every cell in column B becomes that width. You cannot make one cell in column B wider than the others. You can, however, change the height of a single row without affecting other rows.
What is the default column width in Excel?
The default column width is 8.43 character units. The default row height is 15 points. These are the sizes Excel uses when you create a new spreadsheet, but you can change them for the entire sheet by right-clicking the select-all button and choosing Column Width or Row Height.
How do I make all columns the same width?
Click the select-all button (the box where the row numbers and column letters meet), then right-click and choose Column Width. Type the width you want and click OK. Every column in the sheet becomes that width. To do this for only some columns, select them first by clicking the first column letter, holding Shift, and clicking the last one.
Why does auto-fit sometimes make a column too wide?
Auto-fit sizes the column to fit the longest text or number in that column. If one cell contains a very long entry and the rest are short, auto-fit makes the whole column wide to fit that one cell. You can then manually drag the column narrower if you prefer, or edit the long entry to be shorter.
Can I set a minimum or maximum column width?
Excel does not have a built-in minimum or maximum width setting. You can manually set a width that works for your data, but if someone adds longer text to a cell, the column will not automatically expand. You would need to resize it again by hand or use auto-fit.