Yes. To make an Excel cell square, make its column width and row height occupy the same number of screen pixels. Excel measures row height in points but column width in units based on the workbook’s standard font, so equal numbers in the Row Height and Column Width boxes will not normally produce a square.
Why Excel uses different units
Excel’s two dimensions reflect different conventions. Row height is measured in points, the typographic unit used for text. At the standard screen scale of 96 pixels per inch, one point corresponds to about 1.33 pixels. A row height of 48 points therefore corresponds to about 64 pixels at that scale.
Column width, in contrast, is based on the width of characters in the workbook’s Normal style font. It is not a measurement in points, inches, or pixels. The same column-width number can therefore have a different pixel width if the standard font or its size changes. Excel also includes space for cell padding, so multiplying the width value by a character width is not an exact conversion.
In many familiar Excel workbooks, a column width of 8.43 is about 64 pixels at 100% zoom, while a row height of 48 points is about 64 pixels. Those settings make a roughly square cell in that configuration, but the column figure is not universal. Font settings, display scaling, zoom, and Excel version can affect what you see.
How to match the dimensions in Excel for Windows
The most dependable approach is to compare the pixel measurements Excel shows while you resize the row and column. This avoids guessing a character-to-pixel conversion.
- Select the column or columns you want to adjust. To select a column, click its letter at the top of the worksheet.
- On the Home tab, choose Format in the Cells group, then choose Column Width. Enter a width and select OK. Alternatively, drag the right edge of the column-letter heading. While resizing, Excel displays the width and its pixel equivalent.
- Drag the lower edge of the row number to adjust the row. Excel displays the row height and a pixel measurement while you drag.
- Match the pixel readings. For example, if the column is 64 pixels wide, set the row to 64 pixels as well. If resizing by dragging, use the displayed pixel value rather than trying to make the point value equal the column-width value.
To enter a precise row height rather than drag, select the row, choose Home > Format > Row Height, and enter the height in points. At 96 pixels per inch, 64 pixels is 48 points, so 48 is a useful starting value for a 64-pixel column. Check the result on the worksheet, since screen scaling and the column’s actual pixel width can make a small adjustment necessary. The ribbon labels and resize indicators can differ in Excel for Mac and Excel for the web; use the displayed dimensions where available, and verify the appearance in the grid.
A worked example: making a square grid
Suppose you want a grid for a simple pixel-art design and set a column to 8.43. In a workbook where that width renders as 64 pixels, use a row height of 48 points: at 96 pixels per inch, 48 points corresponds to 64 pixels. The cells should appear square at the worksheet’s current display scale. If Excel shows a different pixel width for the column, use that measurement instead of assuming 8.43 always means 64 pixels.
For a larger grid, select several column headings before setting Column Width, then select the corresponding row numbers and set their Row Height. Applying one width to a group of columns and one height to a group of rows is faster and more consistent than resizing each cell individually. If you need a rectangular selection rather than entire rows or columns, remember that row height applies to the whole row and column width applies to the whole column; Excel cannot give just one cell a separate physical width or height.
Choosing a useful square size
Square does not automatically mean usable. A 10-pixel cell may suit a dense visual grid but leave little room to read numbers. A 64-pixel cell is easier to click and can display short labels, but it takes up more worksheet space. Choose a size based on what the cells contain and how the sheet will be used.
- For a visual grid or pixel art: use a consistent, relatively small size and keep text out of the cells unless it is essential.
- For checkboxes or a manual tracker: allow enough room for the symbol and for comfortable clicking.
- For a diagram: make cells large enough to hold labels, and consider wrapping text or using shapes if the diagram needs more flexible sizing.
- For printing: check the print preview as well as the screen. Page scaling can change the printed size even when the worksheet cells look square on screen.
It can also help to select a zoom level before judging the result. Zoom changes how large the grid looks on screen, not the underlying row-height and column-width settings. At a uniform zoom level, both dimensions are scaled together, but pixel rounding can make very small cells look slightly uneven.
What affects whether cells look square?
The most important influence is the column’s actual pixel width. Because width is tied to the Normal style font, changing that font can alter how a column-width value is rendered. Excel’s display scaling and the monitor’s pixel density also influence the relationship between worksheet measurements and physical screen size. The useful comparison is the pixel size Excel reports in the current environment, not a remembered width value from another computer.
Zoom and pixel rounding matter too. Excel has to draw cell borders on whole screen pixels, so a dimension that falls between pixels may be rounded. At a high zoom level, a tiny difference can be easier to spot; at a low zoom level, borders and text may make the grid harder to judge. Gridlines are visual separators, not extra cell dimensions, and turning them off does not change the cell geometry.
Finally, content can make a square cell seem unsuitable even if its boundaries are square. A long entry may overflow into an empty neighboring cell, while a wrapped entry or a large font may require more height. AutoFit can change row height to accommodate content, so recheck the grid after using it. AutoFit adjusts for content; it does not try to preserve square cells.
Common mistakes and how to fix them
- Entering the same number twice: A row height of 10 and a column width of 10 use different units. Match their pixel dimensions instead.
- Assuming 8.43 is always 64 pixels: That is a common default example, not a guarantee across fonts and workbooks. Read the pixel indicator while resizing.
- Changing one cell and expecting its neighbors to stay independent: Excel dimensions belong to whole rows and columns. Changing one column affects every cell in that column.
- Using AutoFit as a square-cell tool: AutoFit responds to text and other content. Set a fixed row height afterward if the grid must remain uniform.
- Judging only from a printout or screenshot: Print scaling, image resizing, and display zoom can change apparent proportions. Check the worksheet itself and print preview separately.
If the grid becomes uneven after editing, select the affected rows and columns again and reapply consistent dimensions. Also check whether some rows have wrapped text or were resized individually. A uniform selection helps distinguish a measurement problem from a few rows that have been altered by content or manual formatting.
Square cells compared with other approaches
For an ordinary worksheet, setting row height and column width is the simplest option. It preserves normal spreadsheet behavior: cells remain editable, formulas work as usual, and you can still sort and filter data. Its limitation is that rows and columns cannot be resized independently for individual cells.
If you are building a visual layout, shapes may offer more control over individual objects, but they are not a substitute for a cell grid when you need spreadsheet data in each square. A chart or drawing can also be resized freely, though its contents and labels behave differently from cell values. For a table that needs both readable text and a square appearance, consider using square cells only in a designated area and ordinary column widths elsewhere.
There is no standard one-click Excel command that converts a selected range into square cells. A consistent pixel measurement is the practical method. If you repeat the same setup in many workbooks, you can save a formatted worksheet as a template; that retains the chosen row heights and column widths without requiring you to repeat the adjustments every time.
Frequently Asked Questions
What column width makes a square cell in Excel?
There is no universal column-width number because Excel’s column units depend on the Normal style font. A width of 8.43 is about 64 pixels in a common configuration; pair it with a row height of about 48 points at 96 pixels per inch, then verify Excel’s displayed pixel measurements.
Can I enter row height in pixels?
The Row Height dialog uses points, not pixels. You can use the pixel reading shown while dragging a row boundary to guide the adjustment, or convert approximately using 0.75 points per pixel at 96 pixels per inch. For example, 64 pixels is about 48 points.
Does changing zoom change the actual cell size?
No. Zoom changes how large the worksheet appears on screen; it does not rewrite the row-height or column-width settings. It can affect how easy it is to judge the proportions, so check at a practical zoom level and use Excel’s resize indicators when precision matters.
Can I make only one cell square?
Not by changing its row and column dimensions alone. Row height affects every cell in that row, and column width affects every cell in that column. You can make the intersecting cell square, but the other cells in those same rows and columns share the changed dimensions.
Why did AutoFit make my square cells uneven?
AutoFit changes a row’s height or a column’s width to suit its contents. It does not maintain equal pixel dimensions. After AutoFit, set the relevant dimensions again if you need a uniform square grid.
Related
- Conditional Formatting: Use More Than One Rule in Excel
- table() in RStudio: How It Counts and Displays Data
- Data Validation and Reconciliation in Excel Explained
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 Create Rules in Microsoft OutlookCreate an Outlook rule by choosing a condition, such as who sent a message or words in its…
- How to Open a Corrupted Excel File Online and Recover DataTo try opening a corrupted Excel file online, first save an untouched copy, upload a duplicate to OneDrive,…
- Insert Entire Row in Excel: Shortcut and AlternativesIn Excel for Microsoft 365 on Windows, select any cell in the row and press Shift+Space to select…
- Excel Import CSV With Headers: Steps, Options, and FixesTo import a CSV file with its first row as column headings in Excel for Microsoft 365 on…
- Clean Excel Data With Power Automate: A Practical GuideYes. Power Automate can clean Excel data by processing rows in a table, applying repeatable rules, and writing…
- How to Put a Timestamp in Google SheetsTo add a fixed timestamp in Google Sheets, select a cell and press Ctrl+; to insert the date,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.