How to Change Cell Size in Excel — Width, Height, and Auto-Fit

The three ways to resize cells 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.

Excel measures column width in character units (the width of the number 0 in the default font) and row height in points. You do not need to remember these units — you can drag to eyeball the size you want, or type a number and let Excel convert it.

Key Takeaways

Drag the border between column letters or row numbers to resize that column or row visually, and double-click the border to auto-fit the content.
Right-click a column letter or row number, select Column Width or Row Height, and type a number to set an exact size.
Select multiple columns or rows by clicking and dragging across their headers, then resize them all at once using the same methods.
Auto-fit adjusts column width or row height to fit the longest text or number in that column or row, and works on single or multiple columns and rows.
Merged cells cannot be resized individually — you must resize the entire merged range as a unit.

Dragging column and row borders to resize

The fastest way to resize a single column or row is to drag its border. Position your cursor on the line between two column letters at the top of the sheet (for example, between columns A and B). The cursor will change to a resize arrow — a double-headed line. Click and drag left to make the column narrower or right to make it wider.

The same method works for rows. Position your cursor on the line between two row numbers on the left side of the sheet, and drag up to make the row shorter or down to make it taller. Release the mouse when the column or row reaches the size you want.

If you want to resize multiple columns or rows at once, select them first by clicking one column letter or row number, then holding Shift and clicking another. All columns or rows between the two you clicked will be selected. Now drag the border of any selected column or row, and all selected columns or rows will resize together.

Double-clicking to auto-fit column width and row height

Double-clicking the border between two column letters automatically adjusts that column's width to fit the longest entry in the column. This saves you from guessing the right width. Position your cursor on the border between the two column letters and double-click — the column will snap to the width of its widest cell.

The same works for rows. Double-click the border between two row numbers, and the row height will adjust to fit the tallest entry in that row. This is especially useful when you have text that wraps across multiple lines within a cell.

To auto-fit multiple columns at once, select them by clicking one column letter, holding Shift, and clicking another. Then double-click any border between two selected column letters. All selected columns will auto-fit to their content. The same method works for rows.

Setting exact column width and row height with numbers

If you need a column or row to be a specific size, you can type the measurement directly. Right-click the column letter or row number you want to resize. A menu will appear. Click Column Width (for columns) or Row Height (for rows). A dialog box will open with a text field.

Type the number you want. For columns, the default unit is character width — a typical column width is between 8 and 20 characters. For rows, the unit is points — a typical row height is between 15 and 30 points. Type your number and click OK. The column or row will resize to exactly that size.

If you want to set the same width or height for multiple columns or rows, select them first. Click one column letter or row number, hold Shift, and click another to select the range. Then right-click any selected column or row and choose Column Width or Row Height. The size you enter will explore to all selected columns or rows.

Using the Format menu to resize cells

You can also resize columns and rows through the Format menu at the top of the screen. Click Format, then hover over Column or Row depending on what you want to resize. A submenu will appear with options including Width, Height, Auto Fit Column Width, and Auto Fit Row Height.

Click the option you want. If you choose Width or Height, a dialog box will open where you can type a number. If you choose Auto Fit, the column or row will resize when ready to fit its content. This method works the same way whether you have selected one column or row or multiple ones.

Resizing all columns or rows at once

To resize every column in your sheet to the same width, click the Select All button — the small rectangle in the top-left corner where the column letters and row numbers meet. Then right-click any column letter and choose Column Width. Type the width you want and click OK. Every column will resize to that width.

You can also select all columns and use auto-fit. Click Select All, then go to Format > Column > Auto Fit Column Width. Excel will resize each column to fit its own content, so columns with longer text will be wider than columns with short text.

The same methods work for rows. Click Select All, then right-click a row number and choose Row Height, or use Format > Row > Auto Fit Row Height.

What to do if your cells won't resize

If you try to resize a cell and nothing happens, the cell is likely part of a merged cell — two or more cells joined together. Merged cells resize as a single unit. You cannot make one part of a merged cell wider or taller than another part. To resize a merged cell, drag its border or right-click it and choose Column Width or Row Height, and the entire merged range will resize together.

If a column or row is hidden, you will not see it on the sheet, and you cannot resize it by dragging. To unhide a column, right-click the column letters on either side of the hidden column and choose Unhide. To unhide a row, right-click the row numbers on either side of the hidden row and choose Unhide. Once the column or row is visible, you can resize it normally.

Frequently Asked Questions

How do I make a column wider without dragging?

Right-click the column letter, click Column Width, type a number (typically 8 to 50 characters), and click OK. Or select the column and go to Format > Column > Width and enter your number there.

What is the difference between column width and row height measurements?

Column width is measured in character units — the width of the number 0 in your default font. Row height is measured in points, a unit used for font size. You do not need to convert between them; just type the number you want and Excel will explore it.

Can I auto-fit a column to a specific maximum width?

Excel's auto-fit feature sizes a column to its content with no maximum. If you want a column to be no wider than a certain size, drag the border to that width manually, or right-click and set Column Width to a specific number.

Why won't my row height change when I type a number?

If you have text that wraps across multiple lines in a cell, Excel may override your row height to fit all the text. Turn off text wrapping in that cell, or increase the row height further. Right-click the row, choose Row Height, and try a larger number.

How do I resize a column to fit its header text?

Double-click the border between that column letter and the next one. Excel will auto-fit the column to the longest entry in the entire column, including the header. If the header is longer than the data below it, the column will size to the header.

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.