LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default Cell Height & Width Equal

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 MS Excel MVP


On Thu, 12 Jan 2006 07:09:02 -0800, CCW wrote:

I often need to draw Items and it would be useful to make the spread sheet
look and print like graph paper. Is there a way to make both heigth and
width the same for each cell?


 
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
File name equal cell contents cxlough41 Excel Discussion (Misc queries) 0 January 3rd 06 10:47 PM
What does the 8.43 and 12.75 represent in height and width of cell ljfrantz40 Excel Discussion (Misc queries) 2 October 17th 05 02:25 AM
How do i change the height and width of a single cell in Excel? lotus1107 Charts and Charting in Excel 1 August 8th 05 02:36 AM
how do I assign a cell equal to another cell yl Excel Discussion (Misc queries) 2 March 16th 05 11:19 AM
make cell contents equal to null value - not blank, but empty mpierre Excel Worksheet Functions 1 December 29th 04 06:57 AM


All times are GMT +1. The time now is 02:18 AM.

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

About Us

"It's about Microsoft Excel"