For a better experience, please enable JavaScript in your browser before proceeding.

However, I found the width and height of Excel does not make sense at all.

For example, default Width is 8.38 while height is 14.25 But the width of the cells on screen and print out is much longer than the height in length.

How to make all cells in the whole spreadsheet real squares I tried changing width and height to the same number but it does not work.

Set Default Column Width In Excel Software That Can

Im sure that there must be map creation software that can be found on the marketinternet that would probably serve you needs better.

I cant imagine how you would begin to draw a map in Excel anyway, as map lines are rarely all horizontal and vertical.

If you set the Row height and column width in VBA for the area you want, then they will look square ( in VBA both items are set in the same unit ).

So, setting a row height of 72 would print out to a meaurable height of one inch.

The hard part is column width, because that depends on the font size and type you have formatted for that cell.

You can come close but maybe never get it exactly right for the column width to be one inch.

Look at Application.CentimetersToPoints (one point being.035 centimeters) and multiply that by the average of characters for your font.

The following macro sets a cell at 1 inch tall by 1 inch wide.

It is not perfect, using D4 as the target cell, but it comes close.

Tweaking it from here might be more trouble than it is worth, so how much further you take it from here is up to you.

Sub Test1() With Range(D4) Dim ColWidth As Integer ColWidth 100.ColumnWidth 1 Do While Abs(72 -.Width).

MSPaint can do gridlines, and you can size things fairly easily, and it is more user friendly with drawing tools, etc.

You might do a Google search for Freeware for making maps also.

In cell A2 if the value A then allow both positive and negative integers.

I have attached sample data, i need someone to help me convert the left side to how the data looks on the right.

Set Default Column Width In Excel For Mac