The fastest way to resize a single cell or column
To change the width of a column, position your cursor on the border between two column letters at the top of the sheet — for example, between the A and B headers. Your cursor will turn into a resize arrow (a double-headed line). Click and drag left to make the column narrower or right to make it wider. Release when the column reaches the size you want.
To change the height of a row, do the same thing with the row numbers on the left side of the sheet. Position your cursor on the border between two row numbers, wait for the resize arrow, then drag up or down.
This method works for one column or row at a time. If you need to resize multiple columns or rows to the same width or height, select them first by clicking the first column letter, then holding Shift and clicking the last column letter you want to change. Then drag the border of any selected column to resize them all together.
Key Takeaways
- Double-click the border between column letters to auto-fit the column width to its content automatically.
- Right-click any column or row header and choose "Column Width" or "Row Height" to enter an exact measurement in inches or centimeters.
- Select multiple columns or rows by clicking the first, holding Shift, and clicking the last, then resize them all at once.
- The Format menu contains options to set optimal width or height based on the content in your cells.
Auto-fit: let Excel size the cell for you
Double-clicking the border between two column letters automatically adjusts the column width to fit the longest piece of text or number in that column. This is faster than dragging if you have many columns with different content lengths.
To auto-fit a row height, double-click the border between two row numbers on the left. Excel will expand or shrink the row to fit the tallest content in that row.
If you select multiple columns or rows first, you can auto-fit them all at once. Click the first column letter, hold Shift, click the last one, then double-click any border between the selected columns. All selected columns will resize to fit their content.
Setting exact measurements through the Format menu
For precise control, use the Format menu. Click the column letter or row number you want to resize, then go to Format in the menu bar. Select "Column Width" (for columns) or "Row Height" (for rows). A small dialog box will open where you can type an exact number.
Column width is measured in character units — the width needed to display a certain number of characters in the default font. Row height is measured in points (a printing unit where 72 points equals one inch). If you are not sure what number to enter, start with a guess and adjust it after you see the result.
You can also right-click directly on a column letter or row number and select "Column Width" or "Row Height" from the menu that appears. This is faster than using the Format menu if you only need to resize one or two columns or rows.
Resizing all columns or rows at once
To resize every column in your sheet to fit its content, click the select-all button — the small square in the top-left corner where the column letters and row numbers meet. Then double-click any border between column letters. All columns will auto-fit.
You can also select all cells and then use Format > Column > Optimal Width (or Format > Row > Optimal Height) to set all columns or rows to their best size based on content. This is useful when you paste data from another source and the columns are too narrow to read.
Hiding and unhiding columns and rows
If you want to temporarily hide a column or row instead of deleting it, right-click the column letter or row number and select "Hide". The column or row will disappear from view, but the data stays in your file.
To unhide a hidden column or row, select the columns or rows on either side of it, right-click, and choose "Unhide". If you have multiple hidden columns in a row, select from the first visible column before the hidden ones to the first visible column after them, then unhide.
Freezing column and row sizes
Once you have sized your columns and rows the way you want them, you can lock those sizes so they do not change when you add or edit content. Select all cells by clicking the select-all button, then go to Format > Cells. In the dialog that opens, click the Alignment tab and check the box for "Wrap text" if you want text to stay within the cell boundaries instead of spilling into adjacent cells.
If you want to prevent accidental resizing, you can also protect your sheet. Go to Format > Cells, click the Protection tab, check "Locked", then go to Tools > Protect Sheet. This locks all cell sizes and formatting until you unprotect the sheet.
Common reasons cells resize unexpectedly
Excel sometimes auto-fits column width when you paste data from another source or when you edit a cell and press Enter. If this happens, undo the action by pressing Ctrl+Z (or Cmd+Z on Mac), then manually set the column width to what you want.
If you have merged cells (cells combined into one larger cell), resizing works differently. You can only resize the entire merged cell as a unit, not individual parts of it. To resize a merged cell, click it once and drag its borders like you would a single cell.
Frequently Asked Questions
Can I set a minimum or maximum width for a column?
Excel does not have a built-in minimum or maximum width setting. You can set a specific width through Format > Column Width, but there is no way to lock a column to stay within a range. If you need to prevent columns from becoming too narrow, you can set a standard width and remind users not to resize below it.
Why does my column width keep changing when I type?
Excel does not auto-fit columns as you type by default. If your columns are changing size, you may have accidentally turned on auto-fit or you may be pasting content from another source. Check the Format menu to see if "Optimal Width" is selected, and turn it off if you want manual control.
How do I resize a column to match another column's width?
Select the column you want to match, note its width (right-click and select "Column Width" to see the number), then select the column you want to change and set it to the same width. There is no direct "match width" command, but this method takes only a few seconds.
What is the difference between column width and optimal width?
Column width is what you set manually — a specific measurement you choose. Optimal width is what Excel calculates based on the longest content in that column. Optimal width changes if you add longer text later, while manual width stays the same until you change it.
Can I resize cells in a table or pivot table the same way?
Yes. Tables and pivot tables use the same resize method as regular cells — drag the column or row borders, or use Format > Column Width. Some table features may auto-fit columns when you add data, but you can always resize manually afterward.