Resize Cells in Excel: Keyboard Shortcuts That Work

How-to basics · Updated November 20, 2026

To resize cells in Excel quickly, resize their columns or rows: in Excel for Microsoft 365 on Windows, select the relevant columns and press Alt, H, O, I to AutoFit their width, or press Alt, H, O, A to AutoFit row height. For a specific size, use Alt, H, O, W for column width or Alt, H, O, H for row height. Excel sizes whole columns and rows, not one cell independently.

What You’ll Need

  • Excel for Microsoft 365 on Windows, with the worksheet open and editable.
  • A keyboard, if you want to use the ribbon shortcuts described below. These are sequential key presses, not keys held down together.
  • An idea of whether you want to fit the contents automatically or enter a particular width or height.

The shortcut sequences here use the English Windows ribbon. If Excel is running in another language, ribbon access keys may differ. On a Mac or in Excel for the web, use the ribbon instructions in the relevant step rather than assuming the Windows sequence will work.

Step-by-Step

  1. Choose what you need to resize. A column’s width applies to every cell in that column; a row’s height applies across the entire row. To adjust one visible cell, you therefore change its row, its column, or both. If you are trying to fit long text, decide whether widening the column, increasing row height, or wrapping the text is the best result.
  2. Select the relevant column or columns. Click a column letter, such as B, to select the whole column. To select adjacent columns, drag across their letters or click the first letter and Shift-click the last. To select separate columns, hold Ctrl while clicking each column letter. You can also click a cell in a column, then press Ctrl+Space to select that column. When selecting a range of cells instead, check that the range includes the columns you intend to adjust.
  3. AutoFit column width to the contents. With the column or columns selected, press Alt, H, O, I in sequence: press and release Alt, then H, then O, then I. Excel sets the selected column widths to fit their longest visible entries. This is useful for labels or values that are cut off, and it does not require you to guess a measurement. If multiple columns are selected, each column is fitted separately to its own contents.
  4. Enter an exact column width when needed. Select the columns, then press Alt, H, O, W in sequence. In the Column Width dialog box, type a number and press Enter. The value is measured in Excel’s column-width units, which are based on character width rather than inches or pixels. For example, entering 18 makes the selected columns the same width; it does not mean 18 pixels. If the result is too narrow or wide, reopen the dialog and adjust the number.
  5. Select the row or rows if you need to change height. Click a row number to select that row. For adjacent rows, drag over the row numbers or Shift-click the endpoints; for nonadjacent rows, use Ctrl-click. Another option is to select a cell in the row and press Shift+Space. As with columns, selecting a group of rows lets you apply one exact height or AutoFit each row to its own content.
  6. AutoFit row height to show the contents. With the rows selected, press Alt, H, O, A in sequence. Excel adjusts the selected row heights to accommodate their contents, including wrapped text when the column width and wrapping settings allow it. This is often the right choice when text appears clipped vertically. It may not produce the expected result for merged cells, which are a special case covered in Troubleshooting.
  7. Set a specific row height. Select the row or rows and press Alt, H, O, H in sequence. Enter a value in the Row Height dialog box and press Enter. Row height is measured in points. If you apply one height to several selected rows, all of them receive that same height; use AutoFit instead if each row should be sized to its own contents.
  8. Check the result and adjust the selection if necessary. Look at the longest entry in each affected column and the tallest wrapped entry in each affected row. If a particular item is still clipped, confirm that its column or row was included in the selection, and check whether text wrapping, merging, or a fixed size is affecting the result. You can undo an ordinary resize with Ctrl+Z.

On Windows, the sequences above are ribbon KeyTips: they activate Home, Format, and then the requested sizing command. Press them one at a time rather than holding Alt and typing the whole sequence as a single shortcut. If the letters shown by your ribbon differ, press Alt and follow the displayed KeyTips to Home and Format, then choose the matching AutoFit or size command.

For a mouse alternative on Windows, move the pointer to the boundary between two column letters or row numbers. When the pointer changes to a resize cursor, double-click the boundary to AutoFit that column or row. Drag the boundary to set a size by eye. To apply AutoFit to several adjacent columns or rows, select them first and double-click a boundary within the selection.

In Excel for Mac, Windows Alt-based KeyTips do not apply. Select the columns or rows, then use the Home tab’s Format controls to choose AutoFit Column Width, AutoFit Row Height, Column Width, or Row Height. The exact menu presentation can vary by Mac version and ribbon layout. Excel for the web also has a different shortcut environment; use its Home tab and Format controls if the Windows sequence is intercepted or unavailable.

Common Mistakes

  • Trying to resize one cell by itself. Excel does not allow a single cell to have a different width from the other cells in its column or a different height from other cells in its row. Change its whole column or row, wrap its text, or consider a layout change if only that cell needs more room.
  • Holding all the shortcut keys together. Alt, H, O, I is a sequence of ribbon access keys, not a four-key chord. Press and release each key in order. If you hold them all down, Excel may not recognize the command.
  • Using the wrong final letter. In the Windows sequence, I means AutoFit Column Width, A means AutoFit Row Height, W opens Column Width, and H opens Row Height. Check the last key before pressing Enter, especially when switching between row and column adjustments.
  • Assuming AutoFit makes every selected column the same width. AutoFit calculates the width separately for each column. If a consistent layout matters, use the Column Width dialog and enter one shared value instead.
  • Expecting width numbers to be pixels. The Column Width dialog uses character-based units; the Row Height dialog uses points. A value of 20 in the column dialog is not the same as 20 pixels or 20 points.
  • Forgetting that hidden columns or rows may be in the selection. A resize command can affect selected hidden items, but their contents may remain out of sight. Unhide the relevant rows or columns to inspect the outcome.

Tips

  • Use AutoFit for changing data. If entries are still being added or updated, AutoFit is a fast way to fit current content. It does not create a permanent rule that automatically resizes the column every time a value changes, so rerun it when necessary.
  • Use a fixed width for a tidy table. If a report has many columns, setting a shared width can make it easier to scan. Select the columns together and enter the same width with the Column Width command. Long entries may then be cut off or wrapped, so review the display afterward.
  • Wrap long text before adjusting row height. Select the relevant cells and choose Home > Wrap Text. Then use AutoFit Row Height so wrapped lines can show. Wrapping changes how text is displayed; it does not change the column width.
  • Resize several items at once. Select a group of column letters or row numbers before using AutoFit or entering a measurement. For separate selections, Ctrl-click the headings on Windows. Confirm the selection carefully so unrelated parts of the worksheet do not get changed.
  • Use the boundary for a quick visual adjustment. Dragging a heading boundary is handy when you want a column to occupy a particular amount of screen space rather than a specific numeric width. Double-clicking that boundary is faster when the goal is to fit the contents.
  • Keep readability in mind. Making a column extremely wide can force horizontal scrolling, while making rows very tall can push useful information off-screen. If a long description dominates a table, wrapping it in a moderately sized column may be more practical than AutoFitting the entire column to one long sentence.

Troubleshooting

The shortcut appears to do nothing. Make sure the worksheet is active and that you are pressing the keys in sequence. Tap Alt once and watch for KeyTips; then follow the letters shown for Home and Format. If a cell is being edited, press Esc or Enter to leave edit mode before trying again. On a Mac or in a browser, use the ribbon commands because Windows KeyTips may not be available.

The text is still cut off after AutoFit. Check that the correct column was selected and that the cell does not contain a line break or merged cells. Also check the number format: a column displaying dates, currency, or other formatted values may need more space than the underlying entry suggests. Try widening the column slightly beyond AutoFit if the display remains cramped.

AutoFit row height does not reveal all wrapped lines. First confirm that Wrap Text is enabled and that the row is not given an unsuitable fixed height. Select the affected row and run AutoFit Row Height again. Merged cells can prevent Excel from calculating an appropriate height automatically; unmerge the cells if practical, or set the row height manually and inspect the result.

The size command is unavailable or has no effect. The worksheet may be protected, or the selected rows or columns may be hidden or part of a restricted range. Check the Review tab for sheet protection and ask the workbook owner before changing protection settings. If the sheet is protected, you may need permission to unprotect it or to resize rows and columns.

The resized column still looks different from nearby columns. AutoFit gives each column its own width based on content, so a different width is normal. To make columns match, select them together and enter one value in Column Width. If the widths look different only on screen, consider zoom level and display scaling; those affect appearance but do not change the worksheet’s stored width.

Frequently Asked Questions

What is the fastest shortcut to resize a column to fit its contents?
On Excel for Microsoft 365 on Windows, select the column and press Alt, H, O, I in sequence. It AutoFits the selected column or columns.

What is the shortcut to AutoFit row height?
Select the relevant rows and press Alt, H, O, A in sequence on Windows. If text should occupy multiple lines, turn on Wrap Text first.

Can I use one keyboard shortcut to resize both rows and columns?
There is no single Windows sequence here that AutoFits both dimensions at once. Run the column command and the row command separately, selecting the appropriate headings each time.

Can I resize only one cell without changing its row or column?
No. Excel applies width to an entire column and height to an entire row. To make a single entry easier to read, wrap its text, adjust its row or column, or change the layout.

Do these shortcuts work in Excel for Mac?
The Alt-based Windows KeyTips are not the Mac equivalent. On a Mac, select the rows or columns and use the Home tab’s Format controls to AutoFit or enter a size. Available keyboard shortcuts can depend on the Mac version and settings.

Will AutoFit keep resizing cells when I edit them later?
No. AutoFit sizes the selection to the contents at the moment you run it. If later edits make a value too long or add wrapped lines, run AutoFit again or adjust the width or height manually.

Related

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.