View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.programming
GS[_6_] GS[_6_] is offline
external usenet poster
 
Posts: 1,182
Default Worksheet for designing a garden

Using Font = Arial, to get square cells:

the row height must = 23
the column width must = 4.56

There should be an easier way to compute those numbers than
"experimenting" with various numbers until square cells result.


Not a prerequisite for a spreadsheet to be able to automatically
convert to cell sizes representative of graph paper! Thus "should not"
be an easier way to 'compute' those numbers.

I just drag a col width until it looks right for the row height, then
set the whole sheet that way OR just a specific area.

On my Dell portable workstation..,

Arial 8 at 1920x1200 res requires a col width of approximately 2 for
a default row height of 10.20 to produce square cells.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion