The fastest way to resize a cell in Excel
To change the width of a single column, position your cursor on the border between two column headers at the top of the sheet. When the cursor turns into a resize arrow (a double-headed line), click and drag left or right to make the column wider or narrower. Release the mouse when the column reaches the size you want.
To change the height of a single row, do the same thing on the border between row numbers on the left side of the sheet. Click and drag up or down to adjust how tall the row is.
If you want a column to automatically fit the width of its content, double-click the border between two column headers instead of dragging. Excel will measure the longest entry in that column and resize it to fit. The same double-click method works for row height.
Key Takeaways
- Double-clicking the border between column headers automatically resizes a column to fit its content without manual dragging.
- You can resize multiple columns or rows at once by selecting them first, then right-clicking and choosing a size option from the menu.
- The Format menu in the ribbon lets you set exact measurements for column width and row height if you need precise control.
- Dragging the border between headers works for single adjustments, but double-clicking is faster when you want content to determine the size.
Resizing multiple columns or rows at the same time
Click on the first column header you want to resize, then hold Shift and click on the last column in the range. All columns between them will be selected (they will appear highlighted). Now position your cursor on the border between any two of the selected column headers and drag to resize them all together.
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. All selected rows will resize to the same height.
If the columns or rows are not next to each other, hold Ctrl (or Cmd on Mac) and click each one individually to select them, then drag the border to resize all of them at once.
Using the Format menu for exact measurements
If you need a column to be exactly 2 inches wide or a row to be exactly 0.5 inches tall, the Format menu gives you that precision. Select the column or row you want to resize, then click the Format menu in the ribbon at the top.
For columns, click "Column Width" and type the exact width you want in inches or centimeters (depending on your Excel settings). For rows, click "Row Height" and enter the exact height. Click OK and Excel will resize to your specification.
You can also right-click on a selected column or row header and choose "Column Width" or "Row Height" from the menu that appears — this is faster than using the ribbon if you know exactly what size you want.
Making all columns the same width
Select all the columns you want to make uniform by clicking the first column header, holding Shift, and clicking the last one. Then right-click on any selected column header and choose "Optimal Width" (in some versions of Excel this is called "AutoFit Column Width").
Excel will resize each selected column to fit its own content, so they may not all end up exactly the same width — each one will be as wide as it needs to be for its data. If you want them all to be the exact same width regardless of content, select them, right-click, choose "Column Width," and enter a single number that will apply to all of them.
Hiding and unhiding columns or rows
If you want to temporarily remove a column or row from view without deleting it, right-click on the column or row header and select "Hide." The column or row will disappear from the sheet, but the data stays in the file.
To bring it back, select the columns or rows on either side of the hidden one (for example, if column C is hidden, click on column B header and drag to column D header). Right-click and choose "Unhide." The hidden column will reappear.
Resizing cells in a specific range
You can also resize cells by selecting a range first. Click on a cell and drag to select multiple cells, or click one cell and Shift-click another to select a rectangular range. Then right-click inside the selection and choose "Row Height" or "Column Width" to resize only those cells.
Keep in mind that when you resize a column, the entire column changes width — you cannot make just one cell in a column wider than the others. The same applies to rows: resizing affects the entire row, not individual cells within it.
Frequently Asked Questions
Why does my text still not fit after I resize the column?
The column may be as wide as it needs to be, but the text inside the cell may be set to wrap or the font size may be large. Check that the text wrapping is turned on (Format menu, then "Wrap Text") so long text breaks into multiple lines within the cell instead of running off the edge.
Can I set a minimum or maximum column width?
Excel does not have a built-in minimum or maximum width setting. You can resize columns manually or use the Format menu to set exact widths, but there is no rule that prevents someone from making a column narrower or wider than you set it.
Does resizing a column affect the data inside it?
No. Resizing only changes how the data looks on screen. The actual values in the cells stay the same, and resizing does not change formulas, calculations, or anything else about the data itself.
How do I resize all columns at once to fit their content?
Click the select-all button (the small box in the top-left corner where the row numbers and column letters meet), then double-click any border between two column headers. Excel will resize every column to fit its content automatically.