How to Change Cell Size in Excel — Width and Height

The fastest way to resize cells in Excel

To change cell size in Excel, you can drag the border between column or row headers, double-click to auto-fit, or use the Format menu. The method you choose depends on whether you want to resize one cell, a whole column or row, or multiple cells at once.

The quickest approach for a single adjustment is to position your cursor on the border between two column letters (or row numbers) at the top left of the spreadsheet, then drag left or right to make the column wider or narrower. The same works for row height — drag the border between row numbers up or down.

Key Takeaways

Dragging the border between column or row headers is the fastest way to resize a single column or row by eye.
Double-clicking the border between headers auto-fits the column or row to the content inside, so text is never cut off.
The Format menu lets you set exact measurements in inches or centimeters if you need precise sizing.
You can resize multiple columns or rows at once by selecting them first, then dragging or using Format.
Excel remembers your column widths and row heights when you save the file, so you only adjust once.

Dragging column borders to change width

Position your cursor at the top of the spreadsheet where the column letters are displayed (A, B, C, and so on). Move your cursor to the line between two column letters — for example, between C and D. Your cursor will change to a resize cursor (a double-headed arrow).

Click and hold, then drag to the right to make the column wider or to the left to make it narrower. Release the mouse button when the column reaches the size you want. The column width changes when ready, and any text in that column adjusts to fit the new space.

If you want to resize multiple columns at the same time, click on the first column letter, hold Shift, and click on the last column letter you want to resize. All columns between them are now selected. Then drag the border of any selected column, and all selected columns resize together by the same amount.

Dragging row borders to change height

The same dragging method works for row height. Look at the row numbers on the left side of the spreadsheet (1, 2, 3, and so on). Position your cursor on the line between two row numbers — for example, between row 5 and row 6. Your cursor will change to a resize cursor.

Click and hold, then drag down to make the row taller or up to make it shorter. Release when the row height is where you want it. This is useful when you have text that wraps to multiple lines within a cell, or when you want more space between rows for readability.

To resize multiple rows, click on the first row number, hold Shift, and click on the last row number you want to resize. Then drag the border of any selected row, and all selected rows resize by the same amount.

Auto-fit columns and rows to content

Double-clicking the border between column headers automatically sizes that column to fit the widest text or number in it. This saves time when you have text that is cut off or hidden. Position your cursor on the border between two column letters and double-click — the column when ready widens (or narrows) to show all content without extra space.

The same works for rows. Double-click the border between two row numbers, and that row height adjusts to fit the tallest content in it. This is especially useful when cells contain wrapped text or formulas that produce longer results than expected.

If you want to auto-fit all columns in your spreadsheet at once, 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 column border. All columns resize to fit their content.

Using the Format menu for exact measurements

For precise control, use the Format menu. Select the column or row you want to resize, then click the Format menu at the top. Look for "Column Width" (if you selected a column) or "Row Height" (if you selected a row). A dialog box opens where you can type an exact width or height in inches or centimeters, depending on your spreadsheet settings.

Type the measurement you want and click OK. The column or row resizes to that exact size. This method is useful when you need columns to match a specific width for printing or when you are creating a template that other people will use and you want consistent sizing.

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 opens the same dialog box without going through the Format menu.

Resizing multiple columns or rows to the same size

Select all the columns or rows you want to resize. Click on the first column letter or row number, hold Shift, and click on the last one. All columns or rows between them are now highlighted.

Then either drag the border of any selected header to resize them all together, or use the Format menu to set an exact width or height. When you drag, all selected columns or rows change by the same amount. When you use the Format menu, they all become exactly the same size.

This is faster than resizing each column or row individually, especially when you have many columns or rows to adjust.

Common mistakes to avoid

The most common mistake is clicking on the column or row itself instead of the border between headers. If you click on the letter or number, you select that column or row but do not resize it. Make sure your cursor changes to the resize cursor (double-headed arrow) before you drag.

Another mistake is dragging too far and making a column so narrow that text disappears. If this happens, straightforward drag the border back to the right to widen it again. You can also undo the change by pressing Ctrl+Z (or Command+Z on a Mac).

If you auto-fit a column and it becomes too wide because of a single long entry (like a long email address in one cell), you can manually drag it narrower afterward. Auto-fit is a starting point, not a lock.

Frequently Asked Questions

How do I make all columns the same width?

Select all columns by clicking the select-all button (top left corner), then use the Format menu and choose "Column Width". Type the width you want and click OK. All columns become that exact width. Alternatively, select the columns you want to match, then drag the border of any selected column header.

Can I set column width in pixels instead of inches?

Excel measures column width in character units by default, not pixels. The Format menu shows this measurement. If your spreadsheet is set to a different unit system, the Format menu will show that unit instead. You can type a number and Excel converts it to the current unit.

Why does my text still look cut off after I widened the column?

The text may be cut off because the row height is too short and text is wrapping to hidden lines below. Try double-clicking the border between row numbers to auto-fit the row height, or manually drag it taller. You can also check if the cell has text alignment set to hide overflow.

Does resizing a column affect the data in the cells?

No. Resizing columns and rows only changes how the data looks on screen and in print — it does not change the actual data. The numbers and text stay the same; only the display space changes.

How do I reset columns to their default width?

Select the columns you want to reset, then use the Format menu and choose "Column Width". Type 8.43 (the Excel default width) and click OK. For rows, the default height is 15 points — you can set this the same way using the "Row Height" option.

This guide is for general information only and is not medical, financial, legal, or other professional advice. For decisions specific to your situation, consult a qualified professional. See our Editorial Policy.