To align cells evenly in Excel, select the range, go to the Home tab, and in the Alignment group click Format > Row Height (or Column Width) and enter a uniform value. For automatic even distribution, select the rows or columns, then double-click the boundary between two selected headers, or use Home > Format > AutoFit Row Height / AutoFit Column Width. This makes every cell in the selection the same size, which is the core of even alignment.
What “Even Alignment” Actually Means in Excel
People usually mean one of two things when they ask about aligning cells evenly. The first is uniform cell dimensions – making all rows the same height and all columns the same width so the grid looks tidy and symmetrical. The second is text alignment within cells – centering, left-aligning, or justifying content so it lines up consistently across a range. Both are common tasks, and Excel handles them with different tools. This article covers both, but the phrase “align cells evenly” almost always refers to the first: getting the row heights and column widths to match.
How to Set Even Row Height and Column Width
The most direct method is to specify exact numbers. Select the rows or columns you want to adjust (click the row numbers or column letters, or drag across them). Then:
- For rows: Home > Format > Row Height… and type a value (default is 15 points).
- For columns: Home > Format > Column Width… and type a value (default is 8.43 characters).
This sets every selected row or column to the same size. If you want cells to size themselves to fit content, select the rows/columns and double-click the boundary between any two selected headers. Excel will auto-fit each row to its tallest content and each column to its widest content, but note that auto-fit does not guarantee all rows are the same height – it makes each row fit its own content, so rows with more text will be taller. For perfectly even rows, you must set a fixed number.
Using the Ribbon for Even Alignment
For text alignment within cells, the tools live in the Alignment group on the Home tab. You’ll see buttons for top, middle, and bottom vertical alignment, and left, center, and right horizontal alignment. To apply the same alignment to a whole range, select the cells and click the appropriate button. For example, to center all headers in a table:
- Select the header row (e.g., A1:D1).
- Click the Center button (the one with centered lines) in the Alignment group.
- Click the Middle Align button (the one with the text centered vertically) to also center top-to-bottom.
This gives every header cell the same internal alignment, which visually makes the table look even even if the column widths differ.
Keyboard Shortcuts and the Format Cells Dialog
For power users, keyboard shortcuts are faster. To open the Format Cells dialog with the Alignment tab active, press Ctrl+1 (Windows) or Cmd+1 (Mac), then press Ctrl+Tab or click the Alignment tab. From there you can set horizontal and vertical alignment, text wrap, and indents. For row height and column width, there are no direct shortcuts, but you can use Alt+H then O then R (Row Height) or Alt+H then O then C (Column Width) on Windows. On Mac, the ribbon shortcuts work differently – you’ll use the menu bar: Format > Row Height or Column Width.
Common Problems and Fixes
A frequent issue is that setting a column width doesn’t affect merged cells. If you have merged cells across multiple columns, the width applies to the merged range as a whole, and you can’t set individual column widths within that merge. To fix, unmerge (select the merged cell, go to Home > Merge & Center to toggle it off), adjust columns, then re-merge if needed. Another problem: when you auto-fit a column, it may not shrink – auto-fit only expands to fit content, it never reduces width below the current setting. To force a narrower width, set a specific number. Also, row height does not auto-fit when the row is set to a custom height – you must double-click the boundary or use AutoFit Row Height to override.
Even Alignment for Printing and Presentation
When printing a worksheet, even cell sizes matter for a professional look. To ensure all columns fit on one page, go to Page Layout > Scale to Fit and set Width to 1 page. This shrinks columns proportionally, but it does not make them uniform – it scales the whole sheet. For truly even columns on print, set each column width to the same number before printing. Similarly, for row heights, set them uniformly. A common trick is to select all cells (Ctrl+A), then set row height to 15 and column width to 10 – this gives a clean grid. But remember, this will cut off any text that doesn’t fit; enable Wrap Text (Home > Alignment > Wrap Text) to keep content visible.
Alternatives: Tables and Styles
If you want even alignment without manual sizing, consider converting your data to an Excel Table. Select the data and press Ctrl+T (Windows) or Cmd+T (Mac). Tables automatically apply consistent formatting, and when you resize a column, the table adjusts. However, tables do not force equal column widths – you still need to set them manually. Another alternative is using Cell Styles (Home > Styles) which apply consistent font and alignment but not size. For a one-click even grid, you can use the Format as Table option and then set a uniform row height and column width once; the table will remember those settings for new rows you add.
Frequently Asked Questions
How do I make all rows the same height in Excel?
Select the rows by clicking and dragging over the row numbers, then go to Home > Format > Row Height and enter a number like 20. All selected rows will become that height. If you want them to auto-fit to content, double-click the boundary between any two selected row numbers, but that may result in different heights.
Why does my column width not change when I type a number?
This usually happens when the column is part of a merged range. Merged cells span multiple columns, so changing one column’s width won’t work until you unmerge. Also, check if the worksheet is protected – if so, you need to unprotect it (Review > Unprotect Sheet) before resizing.
Can I align cells evenly without changing the size?
Yes, if you mean text alignment. Use the alignment buttons in the Home tab to center or left-align text within cells. This makes the content look even without changing row heights or column widths. To align text vertically, use the top, middle, or bottom align buttons.
What is the default row height and column width in Excel?
For Excel for Microsoft 365 on Windows, the default row height is 15 points, and the default column width is 8.43 characters (about 64 pixels). These defaults vary slightly with font size and display scaling, but those are the standard values.
How do I make all columns the same width quickly?
Select all columns by clicking the triangle at the top-left corner (where row numbers and column letters meet), then drag the boundary of any column header to the desired width, or use Home > Format > Column Width and enter a value. All selected columns will match.
Does Excel have a “distribute rows evenly” feature?
No, Excel does not have a one-click “distribute evenly” command like some word processors. You must set row heights or column widths manually, or use the AutoFit feature which sizes to content, not to equal distribution. For a workaround, you can write a simple macro to set all selected rows to the same height, but that requires VBA.
Related
- Train-Test Split: Purpose, Methods, and Common Mistakes
- PostgreSQL: How to Execute a SQL String
- MS Access Split Form: Put the Datasheet on the Bottom
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Open Find and Replace in Excel: Shortcuts and StepsIn Excel for Microsoft 365 on Windows, press Ctrl+H to open Find and Replace directly on the Replace…
- Excel Data Validation Colour Change: Rules and OptionsExcel data validation cannot change a cell’s colour by itself. To colour cells according to a validated value—or…
- How Replace Works in Excel: Find and ReplaceIn Excel, “replace” can mean the REPLACE function, which swaps characters at a specified position in text, or…
- How to Create Inbox Folder Rules in OutlookTo create an Outlook inbox rule that sorts messages into a folder, open the Rules settings for your…
- Ungroup in Excel: How to Bring Back the Ungroup CommandTo bring up Ungroup in Excel for Microsoft 365 on Windows, select the grouped rows or columns, then…
- Jupyter Notebook Split Cell Shortcut and How to Use ItTo split a cell in Jupyter Notebook, place the cursor where you want the break and press Ctrl+Shift+-…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.