The three ways to change cell size in Excel
You can change how wide or tall a cell is in three ways: drag the border between column or row headers with your mouse, double-click that border to auto-fit the content, or right-click and enter a specific measurement. The method you choose depends on whether you want one cell, a whole column or row, or multiple cells at once.
Excel measures column width in character units (roughly how many letters fit) and row height in points (a printing measurement). You do not need to remember these numbers — dragging is usually faster — but knowing they exist helps when you see them in dialog boxes.
Key Takeaways
- Drag the border between column letters (or row numbers) to resize that column or row, and the cells inside it resize with it.
- Double-click the border between column or row headers to auto-fit, which makes the column or row just wide or tall enough for the longest content inside.
- Right-click a column or row header and select "Column Width" or "Row Height" to enter an exact measurement if you need precise sizing.
- Select multiple columns or rows first if you want to resize several at once — they will all become the same width or height.
Resizing a single column by dragging
Click on the column letter at the top (A, B, C, and so on) to select the entire column. Move your mouse to the right edge of that column header — the border between your column and the next one — until 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 when the column is the width you want. The cells in that column now match the new width. If you drag too far and the column becomes too narrow to show the content, Excel displays a small triangle or the text overflows into the next cell — you can always drag again to fix it.
Resizing a single row by dragging
The process for rows is identical to columns. Click on the row number on the left side (1, 2, 3, and so on) to select the entire row. Move your mouse to the bottom edge of that row header — the border between your row and the one below — until the cursor becomes a resize arrow (pointing up and down). Click and drag downward to make the row taller, or upward to make it shorter.
Release when the row height matches what you need. Text in cells will wrap to multiple lines if the row is tall enough and the column is narrow, so changing row height sometimes reveals text that was hidden before.
Auto-fitting columns and rows to content
Double-click the border between two column headers (the same border you would drag) and Excel automatically makes that column just wide enough to show the longest text or number in it. This saves time when you have pasted data and do not want to measure manually.
The same works for rows: double-click the border between two row numbers and the row height adjusts to fit the tallest content. If a cell contains wrapped text, auto-fit will make the row tall enough to show all the lines. If you auto-fit and the result is still too narrow or too short, you can always drag to adjust further.
Resizing multiple columns or rows at once
Select the columns or rows you want to resize together. Click on the first column letter, then hold Shift and click on the last column letter to select a range (for example, Shift-click from A to D selects columns A, B, C, and D). You can also click one column, hold Ctrl, and click others to select non-consecutive columns.
Once multiple columns are selected, drag the border of any selected column header to the right or left. All selected columns will resize to the same width. The same method works for rows: select them, then drag the border of any selected row number up or down, and all selected rows become the same height.
Setting exact column width or row height
Right-click on a column header and select "Column Width" from the menu. A small dialog box appears where you can type a number — this is the width in character units. Type a number and click OK. The column becomes exactly that width.
For rows, right-click a row number and select "Row Height". Type the height in points (a standard printing measurement where 72 points equals one inch). Click OK and the row becomes that height. If you want to return a column or row to its default size, right-click and select "Optimal Width" or "Optimal Height" instead — this is the same as double-clicking the border.
When cells show # or text overflows
If a column is too narrow to display a number, Excel shows a series of hash marks (####) instead of the number itself. This does not mean the data is lost — it just means the column is too narrow. Widen the column by dragging or double-clicking the border, and the number reappears.
Text in a cell will overflow into the next cell if that next cell is empty. If the next cell has content, the text gets cut off at the cell border (though the full text is still stored in the cell — you can see it in the formula bar at the top). Widening the column or making the row taller with wrapped text will show the hidden content.
Frequently Asked Questions
Can I resize all columns at once to the same width?
Yes. Click the select-all button (the small square where the row numbers and column letters meet, in the top-left corner) to select every cell. Then drag the border between any two column headers, and all columns become that width. Double-clicking that border auto-fits all columns to their content at once.
Why does my column width keep changing when I paste data?
Excel does not automatically resize columns when you paste. If the pasted text is wider than the current column, it overflows or gets cut off. After pasting, select the columns and double-click the border between any two headers to auto-fit them to the new content.
What is the difference between column width and row height measurements?
Column width is measured in character units (how many average letters fit across). Row height is measured in points, a printing standard where 72 points equals one inch. You do not need to memorize these — dragging is usually faster than typing numbers.
Can I hide a column or row instead of making it very small?
Yes. Right-click a column header or row number and select "Hide". The column or row disappears from view but the data stays in the file. Right-click the headers on either side of the hidden column or row and select "Unhide" to bring it back.
Does resizing a cell change the font size?
No. Resizing a cell only changes the cell's width or height, not the text inside it. The font size stays the same. If text does not fit, it either wraps to multiple lines (if the row is tall enough) or gets cut off at the cell border.