Excel Column Width to Match Row Height?

Formulas & functions · Updated November 18, 2026

Excel has no built-in setting that makes a column’s width equal a row’s height: column width is measured in character-based units, while row height is measured in points. To make cells look square, set the row height, then adjust the column width until the cell’s on-screen width and height match; at 100% zoom, this is easiest to judge visually.

Why Excel Uses Different Units

Row height is a physical measure in points: 72 points equal one inch. Column width, by contrast, is based on the width of characters in the workbook’s Normal style font. That makes a column-width value such as 8.43 a character-based measurement, not a number of points or pixels. Excel also allows for internal cell padding, so the width is not simply the number of characters multiplied by a font size.

This difference is why entering the same number in the Row Height and Column Width boxes does not create a square cell. A row height of 20 means 20 points; a column width of 20 means a much wider column based on the font’s character metrics. Excel’s column-width calculation is also affected by the workbook font, and displayed dimensions can be affected by zoom and screen scaling.

There is no universal conversion such as “one point equals one column-width unit.” You can estimate a width in pixels, but the character-based unit must then be translated using the font’s maximum digit width and Excel’s padding and rounding. For practical work, visual adjustment or a small trial-and-correction is usually more dependable than treating the two dialog values as directly comparable.

Make Cells Look Square by Adjusting Them

For a regular grid, set a consistent row height first and then tune the column width to match it. In Excel for Microsoft 365 on Windows, select the relevant rows and use Home > Format > Row Height. Enter the height in points. Then select the columns and use Home > Format > Column Width to enter an initial width, or drag a column boundary to refine it.

  1. Set the worksheet zoom to 100% using the zoom control on the status bar. Keep the zoom constant while adjusting dimensions.
  2. Select the rows that need a uniform height. Choose Home > Format > Row Height, enter a value, and select OK.
  3. Select the columns and give them an initial width. If you do not know a suitable value, start with a modest width and adjust it by dragging a column boundary.
  4. Compare the height and width of a cell on the sheet. Increase or decrease the column width until the cell appears square, then check a few cells in the selected range.
  5. Repeat the adjustment if you change the font, zoom, or row height later.

For example, a row set to 30 points is about 40 screen pixels at 96 pixels per inch and 100% zoom, before display scaling and rendering details. If the workbook font’s widest digit is about 7 pixels, a rough column-width estimate is (40 − 5) ÷ 7, or about 5 character units. That is only a starting estimate: the font, padding, and rounding can shift the result. Use the worksheet itself to make the final adjustment.

Estimate the Conversion Instead of Guessing

It helps to understand the two stages of an estimate. First, convert the row height from points to a target pixel height: points × 96 ÷ 72 is a useful approximation at 100% zoom on a 96-pixel-per-inch display. For instance, 24 points corresponds to roughly 32 pixels. Next, estimate the column width from that target pixel width, allowing for the font’s widest digit and the small amount of space Excel reserves around cell contents.

That second stage is font-dependent, so the estimate is not a reliable universal formula. If you want a reproducible result for a particular workbook, note the Normal style font, establish a row height, and adjust the column width until the rendered cell matches. Record the resulting width if you will need to apply it to other columns in the same workbook. A different workbook font may require a different width value for the same visual cell size.

At zoom levels other than 100%, Excel scales the worksheet display. Both dimensions generally scale together, but small cells can appear uneven because of screen-pixel rounding. Therefore, 100% is a convenient setting for comparing dimensions, not a guarantee that a particular width value will print as a perfect square on every monitor.

Set Dimensions for a Whole Grid

To make a block of cells uniform, select the full target range or its complete rows and columns before changing dimensions. Setting the height for selected rows and the width for selected columns gives the grid consistent dimensions. If only a few cells are selected, remember that row height applies to the entire row and column width applies to the entire column; these are not independent cell-level settings.

For a square grid used in a calendar, pixel-art sketch, seating plan, or simple map, choose a size that suits the content before fine-tuning. Larger cells are easier to click and label but take more worksheet space. A 20-point row, for example, will need a narrower column than a 40-point row if the goal is to keep each cell square. Text may wrap or be clipped as you change the dimensions, so check the content after adjusting the grid.

When applying dimensions to a large worksheet, select only the intended rows and columns. Selecting the whole sheet and setting a narrow square-cell width can make ordinary tables difficult to read and may substantially increase the number of visible rows and columns without improving the workbook’s usefulness.

Use the Ribbon, Dragging, or AutoFit

The Row Height and Column Width dialogs are useful when you need to repeat a particular setting. The values are entered in different units, but Excel can apply them consistently to selected rows or columns. Dragging is more useful when the goal is visual: you can compare a cell’s two sides directly and make small corrections without calculating a font-dependent conversion.

AutoFit is a different tool. Home > Format > AutoFit Row Height adjusts row height to fit cell contents; AutoFit Column Width adjusts column width to fit the widest relevant content. Neither command makes a cell square. AutoFit can also undo the uniform dimensions you chose, so avoid applying it to a carefully sized grid unless fitting the content is more important than keeping the cells square.

On Excel for Mac, the same basic approach applies: select the rows or columns and use the Home tab’s formatting controls, or drag their boundaries. Ribbon arrangement and dialog wording can vary slightly by release. Excel for the web also provides row-height and column-width controls, but its interface and rendering can differ from the desktop app. If exact visual alignment matters, make the final comparison in the version where the workbook will be used.

Common Problems and What They Mean

  • The same number gives different-looking dimensions. This is expected because points and character-based column units are different measurements.
  • Cells look square at one zoom but not another. Zoom changes screen rendering, and small dimensions may be rounded to whole display pixels. Check at a consistent zoom.
  • A width that worked in another workbook looks wrong. The other workbook may use a different Normal style font, which changes the relationship between character units and pixels.
  • Row height changes after typing or wrapping text. AutoFit or wrapped content can expand a row. Reapply a fixed height if uniformity matters, and check whether some text is cut off.
  • Only one row or column seems to change. Row height and column width apply to entire rows and columns. Confirm that you selected all the intended row or column headers before entering a value.

Another common misconception is that “square cells” means the row-height and column-width numbers should match. It does not. The relevant comparison is the displayed width and height of the cell, not the two numbers in Excel’s dialogs. Likewise, a cell that looks square on a monitor is not necessarily a square printed area unless the print scaling, page setup, and output device preserve that appearance.

Choose Between Visual and Repeatable Sizing

Use visual adjustment when you need cells to look square on a particular screen, such as for a diagram or a manually drawn grid. It is quick and does not require knowing the exact font metrics. Keep zoom fixed and use the same workbook and display while comparing.

Use dialog values when you need consistent dimensions across a sheet or want to reproduce a layout. First find a visually acceptable column width for the chosen row height, then apply that same width to the other target columns. If you later change the font or design the workbook for another display or print layout, verify the result again rather than assuming the old values still produce squares.

If visual precision is important for printing, use a test print or print preview. The worksheet’s on-screen grid is not a physical measuring tool: printer scaling, margins, paper size, and page fitting can change the printed proportions. For screen-based grids, however, consistent row heights and column widths with a final visual check are usually sufficient.

Frequently Asked Questions

Can I enter the same value for row height and column width?
No. Row height is in points, while column width is based on character width. Matching the numbers does not make the cell square.

What column width makes a 20-point row square?
There is no single exact width for every workbook because the column unit depends on the Normal style font and Excel’s rendering. Use 20 × 96 ÷ 72, or about 27 pixels, as a rough target at 100% zoom, then adjust the column visually.

Does changing the font change column width?
It can change how a given column-width value appears because Excel bases that unit on character metrics. Recheck square cells if you change the workbook’s Normal style font.

Can AutoFit make cells square?
No. AutoFit sizes rows or columns to fit content. It does not compare row height with column width, so use fixed dimensions and adjust the column width separately.

Will square cells stay square when I print?
Not necessarily. Print scaling and page settings can change the proportions. Check Print Preview or a test page if the printed grid must look square.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

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

Spotted an error in this guide? Let us know.