How to Align Cell Size in Excel for a Neater Sheet

How-to basics · Updated November 20, 2026

To align cell sizes in Excel, select the rows and columns you want to match, then use Home > Format to enter the same row height and column width, or use AutoFit to size them to their contents. In Excel for Microsoft 365 on Windows, these options change the size of entire rows or columns, not just individual cells. You will need an open workbook and a clear idea of whether you want uniform dimensions or sizes that fit the text.

What You’ll Need

  • An Excel workbook with the cells, rows, or columns you want to resize.
  • A choice between matching sizes exactly and letting Excel fit the contents.
  • If you are setting an exact size, the measurement you want to use. Row height is measured in points; column width is based on the character width of the workbook’s default font.

Step-by-Step

  1. Decide what should match. A cell’s dimensions come from its row height and column width. To make a rectangular area uniform, you generally need to set the heights of its rows and the widths of its columns separately. For example, matching three rows does not automatically make the columns in those rows the same width.
  2. Select the rows you want to make the same height. Click and drag across their row numbers at the left edge of the worksheet. To select rows that are not next to each other, hold Ctrl on Windows while clicking each row number. You can also select a cell range; setting row height then affects every row intersecting the selection.
  3. Enter a precise row height. Go to Home > Format > Row Height, type a value, and select OK. Excel measures row height in points. Applying the same value to several selected rows gives those rows the same height. If the value is too small for the font or wrapped text, some content may not be visible.
  4. Select the columns you want to make the same width. Click and drag over their column letters at the top of the worksheet. Selecting cells in those columns also works: the width command applies to the full selected columns. Use Ctrl-click on Windows to select nonadjacent columns, taking care not to replace your selection before opening the command.
  5. Enter a precise column width. Choose Home > Format > Column Width, type the width, and click OK. Column width is not a measurement in inches or pixels: it is calculated using the width of characters in the workbook’s default font. A width of 12 is therefore a character-based setting, not a promise that every cell will display exactly 12 letters.
  6. Use the same values wherever you want matching dimensions. Repeat the row-height command for each group of rows that should match, and the column-width command for each group of columns. For example, to create evenly sized cells across B2:E8, set rows 2 through 8 to one height and columns B through E to one width. The resulting cells are consistent within the worksheet, although the cells may not be perfect squares because row height and column width use different measurement systems.
  7. AutoFit columns when the contents should determine the width. Select the columns, then choose Home > Format > AutoFit Column Width. You can also point to the boundary on the right side of a selected column letter and double-click it. Excel adjusts the selected columns to accommodate their contents. If you want several columns to match one another, AutoFit is not the right choice when their contents have different lengths; use a fixed width instead.
  8. AutoFit rows when the contents should determine the height. Select the rows and choose Home > Format > AutoFit Row Height, or double-click the boundary below a selected row number. This is especially useful after turning on Home > Wrap Text. Review the result because AutoFit can make rows different heights when their contents need different amounts of space.
  9. Check the worksheet after resizing. Look for clipped text, unwanted blank space, and rows or columns that were left out of the selection. If the sheet is for printing, use File > Print to preview it; a size that looks good on screen may still cause extra pages or cramped print output.

The ribbon labels are the same in Excel for Microsoft 365 on Windows. The keyboard access keys can speed up the process: press Alt, H, O, H in sequence 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. These are sequential key presses, not keys to hold down together. In Excel for Mac and Excel for the web, use the Home tab’s Format menu or the column and row boundaries; Windows Alt sequences do not apply in the same way.

Common Mistakes

  • Expecting one setting to make cells square. Row height and column width use different units, so entering the same number in both boxes does not necessarily produce a square. Adjust both dimensions and judge the result visually, or use a consistent layout rather than relying on equal numbers.
  • Resizing only the visible cells. A width setting applies to whole columns, and a height setting applies to whole rows. If you select cells B2:D5 and change the width, columns B through D change above and below that range too. Check whether that will affect other parts of the sheet.
  • Using AutoFit when identical sizes are the goal. AutoFit evaluates content. One long label can make one column wider than the rest, while different amounts of wrapped text can produce different row heights. Set a shared fixed measurement for a uniform grid.
  • Trying to make merged cells AutoFit normally. AutoFit may not calculate the height or width correctly for merged cells. If a merged heading is clipped, adjust the row height or column width manually, or consider unmerging the cells and using another alignment approach.
  • Ignoring hidden rows or columns. A hidden row or column can be easy to miss in a selection and may remain hidden after you resize nearby items. Check for gaps in row numbers or column letters, and unhide the relevant rows or columns if needed.
  • Assuming the same width looks identical in every workbook. Column width depends on the default font, and displayed text also depends on each cell’s font and formatting. If a workbook uses a different default font, the same width number may appear different on screen.

Tips

  • Use Format Painter or copy formatting carefully. These tools can transfer formatting, but they are not the clearest way to make row heights and column widths consistent. For predictable results, select the target rows or columns and set the dimensions directly.
  • Use the Select All button for a whole-sheet adjustment. Click the small triangle at the top-left corner of the worksheet, where row numbers and column letters meet, then set a column width or row height. This affects the entire worksheet, so avoid it if only one table should change. You can also press Ctrl+A on Windows when the selection context allows it; inside an Excel table, the first press may select table data rather than the entire sheet.
  • Format wrapped text before setting row heights. Select the relevant cells and turn on Home > Wrap Text before using AutoFit Row Height. This lets the row height reflect multiple lines. If you later change the font, column width, or text, run AutoFit again because the required height may have changed.
  • Use one standard size for repeated sections. For a schedule or data-entry form, pick a row height and column width that suit the typical entry, then apply them to each section. This gives the sheet a consistent appearance while leaving enough room for common labels and values.
  • Keep headings and data readable. A very narrow column can hide values or show number signs for values that do not fit; widening the column or changing the number format can help. For long headings, wrapping text or using a wider heading column is often clearer than making every column unusually wide.

Troubleshooting

Text is still cut off after AutoFit. First check whether the cell is merged, because merged cells can prevent AutoFit from working as expected. Also check for Wrap Text, a manually set row height, and unusually large fonts. Try selecting the full affected row and choosing Home > Format > AutoFit Row Height. If that does not solve it, set the row height manually or adjust the column width.

AutoFit makes one column much wider than the others. Excel is responding to the longest visible entry in that column. If uniform widths matter more than showing every entry on one line, select the columns and enter one fixed value through Home > Format > Column Width. You can keep long text readable with Wrap Text or by widening only the columns meant for descriptions.

The sizing command is unavailable or has no effect. Check whether the worksheet is protected. A protection setting may prevent formatting rows or columns; if you have permission, use Review > Unprotect Sheet, then resize the selection. Also confirm that the intended rows or columns are selected and are not hidden. If the workbook is in a restricted or read-only state, you may need an editable copy or permission from its owner.

Only some rows or columns changed. Re-select the row numbers or column letters, including any nonadjacent items you meant to include, and apply the same setting again. When selecting cells rather than headers, remember that the command affects the entire rows or columns intersecting the selection. If cells are in different worksheet sections, verify the result in each section.

The worksheet looks right but prints poorly. Open Print Preview and check page breaks, scaling, and the print area. A wide set of columns may spill onto extra pages, while scaling the sheet to fit can make text too small. Consider adjusting the print area or page orientation rather than shrinking cell sizes until the content becomes difficult to read.

Frequently Asked Questions

Can I make all cells the same size at once?
Select the whole worksheet using the top-left Select All button, set a row height, and then set a column width. This makes the rows and columns uniform across that sheet, but the resulting cells will not necessarily be square.

Can I make cells exactly square in Excel?
There is no single square-cell setting. Row height is measured in points, while column width is based on the default font’s character width. Adjust both settings and compare the on-screen shape; the apparent result can also vary with display scaling and font.

What is the difference between AutoFit and a fixed size?
AutoFit chooses a size based on the contents, so different rows or columns may end up with different dimensions. A fixed row height or column width applies the same specified dimension to the selected rows or columns, which is better for a uniform layout.

Does changing a cell’s size affect the whole row or column?
Yes. Excel does not let you give one ordinary cell a separate height or width from the rest of its row or column. A row-height change affects that entire row, and a column-width change affects that entire column.

Why does my column width look different on another computer?
Column width is tied to the workbook’s default font and character measurements, and the screen may use different scaling or display settings. The stored width remains a worksheet setting, but the visible result can vary slightly across environments.

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.