Share via

Microsoft Excel Cell Size

Anonymous
2016-07-05T09:24:32+00:00

How to make perfectly or approximate "Square" Cell in Excel Work book by entering Row Height and Column width?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-07-05T14:03:25+00:00

    Hi,

    To make a square, you can try this:

    1. Highlight the squares you want to format.
    2. Go to the 'Format' section, under 'Home' tab.
    3. Format the column width at 12.43
    4. Then format the row height to 75.

    You may refer to the article below to set the column and row for excel and check if it helps.

    https://support.office.com/en-us/article/Change-the-column-width-and-row-height-486cd65a-cb26-478a-a937-20e12003e8ec

    Hope this information helps. Please let me know if you need further assistance.

    3 people found this answer helpful.
    0 comments
  2. Anonymous
    2016-07-05T15:44:58+00:00

    If you want to see a workbook with a routine for creating square cells download from this site

    https://onedrive.live.com/?cid=863B7DD7364138EC&id=863b7dd7364138ec!113

    Filename is Create_Squares.xlsm

    Gord

    0 comments
  3. Anonymous
    2016-07-05T15:32:20+00:00

    Very difficult to create square cells due to how Excel measures row heights and column widths.

    Screen resolution also has a bearing on the cell sizes.

    If you want to use VBA to set height and width in

    mm(25.4mm/inch) for a perfect square under any conditions. . . . .

    Ole Erlandson has code for setting row and column dimensions.

    http://www.erlandsendata.no/

    Gord

    0 comments