Excel Cell Size: Adjust Row Height and Column Width

To format cell size in Excel for Microsoft 365 on Windows, adjust the row height, the column width, or both: select the relevant row or column, then choose Home > Cells > Format and enter a size, or drag the boundary of its heading. Use AutoFit when you want Excel to size rows or columns to their contents. Excel does not give each cell an independent height or width; cells in the same row share a height, and cells in the same column share a width.

What You’ll Need

An Excel workbook you can edit. If it is read-only or protected, you may need permission to change its layout.
A rough idea of whether the issue is horizontal space (column width), vertical space (row height), or both. If the goal is to make text larger, use font size instead; changing cell dimensions does not change the text size.
Optional: the desired measurements. Row height is measured in points, while column width uses a character-based unit related to the workbook’s default font. These values are not interchangeable.

Step-by-Step

Open the worksheet and identify what needs changing. Look at the headings and cell contents. Text cut off at the right edge usually needs a wider column, while text hidden at the bottom may need a taller row or text wrapping. If several adjacent columns or rows need the same dimensions, you can select them together before changing the size.
Select the rows or columns to format. Click a row number on the left to select that entire row, or click a column letter at the top to select the entire column. Drag across row numbers or column letters to select a consecutive group. To select nonadjacent rows or columns, hold Ctrl while clicking each heading on Windows. Selecting ordinary cells instead is also possible: a row-height change applies to the row or rows containing the selection, and a column-width change applies to its column or columns.
Enter an exact row height. With the target row or rows selected, go to Home > Cells > Format > Row Height. Type a number in the dialog and choose OK. The number is in points; for example, entering 30 sets the selected rows to 30 points high. A larger number creates more vertical room. Excel applies one height to every selected row, so select rows separately if they need different heights.
Enter an exact column width. Select the target column or columns and choose Home > Cells > Format > Column Width. Enter a value and choose OK. For example, a width of 18 is a character-based measurement, not 18 pixels or 18 points. The on-screen pixel width can vary with the workbook’s font and display scaling. If the result is too wide or narrow, reopen the dialog and adjust the value.
Set size by dragging when precision is not essential. Move the pointer to the boundary between two row numbers or two column letters. When it changes to a resize indicator, drag the boundary until the row or column looks right. To resize several neighboring columns to a common width, select their headings first and drag one selected column’s boundary. The same approach works for selected rows. Watch the worksheet as you drag, and release when the displayed contents fit.
Use AutoFit to match the contents. Select the relevant row or column headings, then choose Home > Cells > Format > AutoFit Row Height or AutoFit Column Width. You can also double-click the boundary below a row number to AutoFit its height, or to the right of a column letter to AutoFit its width. AutoFit bases its result on the visible contents and current formatting; it may not produce the compact layout you want if the column contains a long entry.
Check the result in context. Review the neighboring cells and any headings, wrapped text, borders, or merged cells. Resize again if the change makes the sheet harder to scan. If a cell should display multiple lines, select it and choose Home > Alignment > Wrap Text before adjusting or autofitting the row height. Save the workbook after confirming that the layout works at the zoom level and print scale you use.

For a quick whole-sheet adjustment, click the Select All triangle at the intersection of the row numbers and column letters, then enter a row height or column width. This changes the dimensions throughout that worksheet, so use it only when a uniform layout is intended. It does not automatically change every worksheet in the workbook.

These ribbon paths describe Excel for Microsoft 365 on Windows. Excel for Mac offers the same row-height and column-width controls through its Home ribbon, though keyboard navigation differs. The Windows Alt key sequences are Alt+H, O, H for Row Height; Alt+H, O, W for Column Width; Alt+H, O, A for AutoFit Row Height; and Alt+H, O, I for AutoFit Column Width. On Mac, use the ribbon or drag the heading boundaries rather than relying on those Windows sequences. Excel for the web also allows heading-boundary resizing; if the Format commands are available in its Home ribbon, use them for numeric sizing, otherwise use the drag controls.

Common Mistakes

Expecting to size one cell by itself. Excel dimensions belong to complete rows and columns. If just one cell needs more room, increasing its row height affects all cells in that row; increasing its column width affects all cells in that column. Consider wrapping the text, shortening a label, or placing the content in another column if changing the shared dimension would disrupt the sheet.
Mixing up the measurement units. Row height is entered in points, but column width is based on character width. Typing 20 into both dialogs does not make a square cell, and a column width of 20 does not mean 20 pixels. Use the visual result as a guide for column width, or drag the boundary when a specific pixel measurement is not important.
Using AutoFit without checking wrapped or merged text. AutoFit is convenient, but it can behave unexpectedly when cells are merged, when text wrapping is enabled, or when content includes unusual formatting. A row may remain too short or become taller than expected. For merged cells in particular, set the row height manually and check the complete text after the change.
Changing font size when the problem is cell size. A larger font can make text more readable, but it also changes how much content fits and may cause rows to expand. If the text is already the right size, adjust the row height or column width instead. Conversely, if the cell fits but the text is hard to read, change the font size rather than enlarging the whole layout.
Forgetting that selection matters. If only one heading is selected, only its row or column changes. Check that all intended headings are highlighted before entering a measurement. Also note that selecting the whole worksheet and applying a size can alter areas that were already formatted correctly.

Tips

Use AutoFit first, then fine-tune. AutoFit provides a useful starting size for ordinary data. If a column becomes too wide because of one long note or identifier, set a practical width manually and use Wrap Text for entries that should continue on a new line.
Keep related columns consistent. If several columns hold similar kinds of data, select them together and set one width. Consistent widths make tables easier to scan and reduce visual clutter. For columns with different purposes, prioritize the values readers need to see without opening or editing a cell.
Use the boundary shortcut carefully. Double-clicking a column boundary AutoFits that column, and double-clicking a row boundary AutoFits that row. It is a fast alternative to opening the Format menu, but it may create an unexpectedly large dimension if one cell contains a long value.
Consider the worksheet’s default font. Column width is tied to character units and the default font, so the same numeric width can look different if the workbook’s font changes. If a carefully adjusted sheet will be opened on another device, check its appearance there too.
Leave room for filters and headings. When a table has filter arrows or long column labels, size the headings for readability as well as the data. Wrapping a heading and increasing its row height can be preferable to making every column excessively wide.
Check print layout when printing matters. A width that looks comfortable on screen may cause a printed sheet to span extra pages. Use File > Print to preview the result, and adjust dimensions or print scaling as needed. Avoid shrinking the printout so much that the text becomes difficult to read.

Troubleshooting

The text is still cut off after resizing. Confirm that you changed the correct row or column and selected all relevant headings. If it is a column issue, widen the column or use Wrap Text. If it is a row issue, increase its height or use AutoFit Row Height. Check whether the cell contains a long unbroken string, which may not wrap as expected.
AutoFit does not make a row tall enough. Turn on Wrap Text from Home > Alignment > Wrap Text, then try AutoFit Row Height again. If the cell is merged, set the row height manually; AutoFit may not calculate the merged content as expected. Inspect neighboring rows too, as the text may be in a different row than the one you changed.
The size will not change. The sheet may be protected, or the workbook may be opened with restricted editing. Look for a protection notice or check the Review tab for sheet-protection controls. If you do not have permission to unprotect it, ask the workbook owner for access. Also verify that the row or column is not hidden: select the surrounding headings and use Home > Cells > Format > Hide & Unhide to unhide rows or columns if appropriate.
The column width looks different on another computer. Column width depends on the workbook’s font and can appear different with another display scale or font rendering. Recheck the setting in Column Width, verify the font, and preview the worksheet on the intended device. For printed output, use File > Print rather than judging the final size only from the worksheet view.
The result seems too large or too small. Reopen Home > Cells > Format > Row Height or Column Width and confirm the number and unit. Remember that the two measurements use different scales. You can also undo the last change with Ctrl+Z on Windows or Command+Z on Mac, then apply a smaller adjustment.

Frequently Asked Questions

Can I change the size of just one cell in Excel?
No. A cell shares its height with the rest of its row and its width with the rest of its column. You can make its contents fit by wrapping text, adjusting the shared row or column, or reorganizing the data.

What is the difference between row height and column width?
Row height controls vertical space and is measured in points. Column width controls horizontal space and uses a character-based unit related to the default font. Their numeric values cannot be compared directly.

How do I make all columns the same width?
Select the columns by dragging across their letter headings, then choose Home > Cells > Format > Column Width and enter a value. To apply a common width to all columns in one worksheet, select the whole sheet first.

Why does AutoFit make a column much wider than expected?
Excel may be sizing the column to fit its longest visible entry, including a long note, URL, or identifier. Set a smaller width manually and use Wrap Text where appropriate, or move lengthy notes out of the main data table.

Can I enter column width in pixels?
The Column Width dialog uses character-based units, not pixels. Dragging a column boundary lets you adjust its visible width by eye, but the dialog does not directly accept a pixel value.

Will changing a row height or column width alter the cell’s font?
No. Dimensions affect the space available for content, not the font itself. Change font size separately from the Home tab if the text needs to be larger or smaller.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.