Excel Shortcuts for Evenly Sized Rows and Columns

Yes. In Excel for Microsoft 365 on Windows, select the columns or rows you want to make equal, then press Alt, H, O, W to enter one shared column width, or Alt, H, O, H to enter one shared row height. Excel has no single shortcut that automatically distributes cells evenly; these key sequences open the sizing commands so you can give a selection matching dimensions.

What Even Spacing Means in Excel

People often use even spacing to mean one of two things: making several columns the same width, or making several rows the same height. Both can make a table look orderly, but they are different operations. A cell’s visible size comes from its column width and row height, so setting only one of those dimensions does not make every cell a square or give every part of a worksheet identical spacing.

Excel also does not arrange cells like movable objects on a slide. Cells sit in a fixed grid. You adjust the grid by changing entire columns or rows, not by dragging an individual cell away from its neighbors. This is why the useful keyboard commands work on selected rows or columns.

If you mean adding blank spaces inside the text in a cell, that is a different task. You can edit the text or use alignment and indentation settings, but changing a column’s width does not insert spaces into its contents. The steps below cover equal row heights and column widths, which is the usual meaning of evenly spacing cells.

Keyboard Sequences for Equal Dimensions

The sequences below use Excel’s ribbon KeyTips. Press the keys one after another; do not hold them all down together. They apply to the Windows desktop version of Excel for Microsoft 365.

Set a common column width: select the target column or columns, then press Alt, H, O, W. Enter a width and press Enter.
Set a common row height: select the target row or rows, then press Alt, H, O, H. Enter a height and press Enter.
AutoFit column width: select the relevant columns and press Alt, H, O, I. Excel adjusts each column to fit its contents.
AutoFit row height: select the relevant rows and press Alt, H, O, A. Excel adjusts row heights to fit their contents.

These are ribbon sequences, not universal keyboard shortcuts that behave the same in every spreadsheet app. If a sequence does not open the expected command, check that you are using Excel desktop on Windows and that no cell is currently being edited. Press Esc to leave cell-edit mode, then try again.

Make Several Columns the Same Width

First select the columns you want to change. To choose a continuous group using the Name Box, click the box to the left of the formula bar, type a column range such as B:D, and press Enter. The three columns become selected. Then press Alt, H, O, W, type a width, and press Enter.

You can also select columns with the mouse by dragging across their column letters. To select columns that are not next to one another, hold Ctrl while clicking their headers, then use the same width command. Excel applies the entered width to each selected column, rather than adding the value to its previous width.

For example, setting columns B through D to a width of 15 gives all three the same width value. The unit is not a simple measurement in inches or pixels: Excel’s column-width scale is based on the character width of the workbook’s Normal style font. As a result, the on-screen pixel width can depend on font settings and display scaling. The important point is that entering one value applies a consistent width setting to the selected columns.

Make Several Rows the Same Height

To select a continuous set of rows, type a range such as 5:10 in the Name Box and press Enter. Then press Alt, H, O, H, enter a height, and press Enter. Every selected row receives that height. You can instead select the row numbers directly, or select nonadjacent row headers with Ctrl held down.

Row height is measured in points, a unit used for typography and page layout. A larger number creates a taller row. For instance, entering 24 makes each selected row 24 points high. A fixed height is useful for a clean table or form, but it may hide text if a cell contains wrapped lines that need more vertical space.

If you need both matching widths and matching heights, perform the two operations separately. Select the intended columns and set their width, then select the intended rows and set their height. Setting both to the same numeric value does not necessarily make cells visually square because column width and row height use different measurement systems.

Choose Between Fixed Size and AutoFit

Equal dimensions and AutoFit solve different problems. A fixed width or height gives a group of rows or columns matching measurements. AutoFit sizes each one according to its contents, so the resulting dimensions may differ. Choose based on whether visual consistency or showing all the content is more important.

Use a fixed width for repeated fields in a report, a form with aligned entry areas, or a table where consistent column proportions matter.
Use AutoFit when a heading or value is clipped and you want Excel to make room for the longest visible entry in each selected column.
Use a fixed row height when rows need a uniform appearance and the content is short enough to fit.
Use AutoFit Row Height when wrapped text spans multiple lines and the row should grow to show it.

AutoFit is not a command to make a group equal. If one column contains a long description and another contains short codes, AutoFit can produce very different widths. Conversely, giving every column a fixed width can cause long text to spill into an empty neighboring cell, appear clipped, or wrap if text wrapping is enabled.

Selection and Display Details That Matter

Selection determines what Excel changes. If you select whole columns, the width command affects those entire columns throughout the worksheet, not just the visible table cells. Selecting rows works the same way: row height is a property of the full row. If the worksheet contains other tables in those rows or columns, their layout will change too.

Hidden rows and columns can make it seem as though a sizing command did not work. They remain hidden after you change dimensions. To inspect them, select the surrounding row or column headers, right-click, and choose Unhide. Also check for filtered-out rows: filtering hides records temporarily, while changing row height does not remove the filter.

Wrapped text and merged cells are common sources of surprises. With Wrap Text enabled, a fixed row height may not be tall enough to display every line. AutoFit often helps with ordinary cells, but merged cells can prevent Excel from calculating the required row height as expected. For a more predictable layout, avoid merging cells in data tables; use alignment options such as Center Across Selection when suitable, or adjust the row height manually.

Using the Ribbon or Menus Instead

If you prefer to see the command before applying it, select the rows or columns and use the ribbon: Home > Format > Column Width or Home > Format > Row Height. The same Format menu includes AutoFit Column Width and AutoFit Row Height. The dialog makes it clear whether you are entering a fixed measurement or asking Excel to fit the contents.

On Excel for Mac, the Windows Alt KeyTip sequences are not the equivalent keyboard method. Use the ribbon or the Mac menu commands to set a column width or row height; the exact keyboard navigation can depend on macOS settings and the Excel version. Excel for the web also has a different interface and may not expose the same Windows KeyTip sequence. In either environment, selecting the rows or columns first and using the visible Format sizing command is the dependable approach.

Common Misconceptions and Quick Fixes

A frequent misconception is that double-clicking a column boundary makes multiple columns equal. Double-clicking the boundary of one selected column performs AutoFit for that column; it does not assign that column’s existing width to every other selected column. To make a group equal, enter one width in the Column Width dialog.

Another potential mix-up is confusing cell alignment with cell size. Horizontal or vertical alignment changes where the content sits inside the available cell area; it does not alter row height or column width. Likewise, indent commands move content inward but do not create uniformly sized cells.

If the result looks uneven, check these points:

Confirm that all intended row or column headers were selected before opening the sizing command.
Check whether some rows or columns are hidden, or whether the selection includes other worksheet content you did not intend to resize.
Look for merged cells, wrapped text, or unusually large font sizes that affect how content appears.
Remember that a common width value does not promise identical pixel measurements under different font or display conditions.

Frequently Asked Questions

Is there one Excel shortcut to distribute cells evenly?
There is no single shortcut that automatically distributes selected cells evenly. On Windows, use the Column Width or Row Height KeyTip sequence and enter a common value for the selected columns or rows.

What is the shortcut to make columns the same width?
Select the columns, then press Alt, H, O, W. Enter the width and press Enter.

What is the shortcut to make rows the same height?
Select the rows, then press Alt, H, O, H. Enter a height and press Enter.

Does AutoFit make columns or rows equal?
No. AutoFit sizes each selected column or row to fit its own contents. Use a fixed width or height when matching dimensions is the goal.

Can I make cells square with the same number for width and height?
Not reliably. Excel uses different units for column width and row height, and the displayed size also depends on font and scaling. Adjust the two dimensions visually if you need approximately square cells.

Do these Windows shortcuts work in Excel for Mac?
The Windows Alt KeyTip sequences are not the Mac equivalent. On Mac, select the target rows or columns and use the ribbon or menu sizing commands.

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.