View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
MichaelRobert MichaelRobert is offline
external usenet poster
 
Posts: 64
Default How can I easily make cells in Excel that are square?

The underlying problem is that Excel measures Row Height in picas and Column
Width in number of standard characters.

There are 72 picas (vertical) to the inch, and 12 characters (horizontal) to
the inch. So for a square cell, the ratio of the NUMBERS for Row
Height/Column Width must be 1:6. As JEV wrote, for a 1 inch square cel,l set
RH = 72, CW =12.
For a 1/2 " square cell, set RH=36, CW=6.

Mike

"JEV" wrote:

select all;
format; row height set to 72 pts
column width set to 12 pts

displys cells 1" by 1"



"Todd" wrote:

Seems such a simple request, but I cannot find a simple answer.