Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Buzzcut
 
Posts: n/a
Default Can I make column width and row height equal (a grid) in Excel?

I'd like to use a worksheet like a piece of graph paper. Is there any simple
way to set the column width and the row height to form perfect squares in a
worksheet?
  #2   Report Post  
Gord Dibben
 
Posts: n/a
Default

Buzz

MS Office Excel Template for graph paper........

http://office.microsoft.com/en-us/te...183751033.aspx

If you want to "roll your own".......

Assuming 96 pixels per inch you could approximate but at different resolutions
your approximation can be off.

If you want to use VBA to set height and width in mm which you then convert to
inches at 25.4 mm per inch..........

Ole Erlandson has code for setting row and column dimensions.

http://www.erlandsendata.no/english/...vbawssetrowcol


Gord Dibben Excel MVP


On Tue, 3 May 2005 08:17:16 -0700, "Buzzcut"
wrote:

I'd like to use a worksheet like a piece of graph paper. Is there any simple
way to set the column width and the row height to form perfect squares in a
worksheet?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 10:44 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"