#1   Report Post  
Posted to microsoft.public.excel.setup
elika
 
Posts: n/a
Default square cells


I want to change the grid into a pattern of square cells. I want the hight
and width to be equal. Can this be done?

The reason is that I want to use the grid as a background for simple
drawings of products. Is there perhaps a better way to do this in an
office-program?
  #2   Report Post  
Posted to microsoft.public.excel.setup
Gord Dibben
 
Posts: n/a
Default square cells

elika

Row heights are measured in points or pixels. There are 72 points to an inch
and "maybe" 96 pixels to the inch.

The number that appears in the Standard column width box is the average number
of digits 0-9 of the standard font that fit in a cell.

For an interesting and enlightening discussion on this subject see

http://snipurl.com/dzz8

If you want to use VBA to set height and width in mm.

Ole Erlandson has code for setting row and column dimensions.

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


Gord Dibben Excel MVP

On Wed, 5 Apr 2006 07:45:01 -0700, elika
wrote:


I want to change the grid into a pattern of square cells. I want the hight
and width to be equal. Can this be done?

The reason is that I want to use the grid as a background for simple
drawings of products. Is there perhaps a better way to do this in an
office-program?


Gord Dibben MS Excel MVP
  #3   Report Post  
Posted to microsoft.public.excel.setup
Lowkey
 
Posts: n/a
Default square cells

Elika,

You will be better served to use a different application for your purpose.
You might even find it easier to simply use some 1/4" square lined paper, but
if you need to have your drawings in electronic format, then MS Visio might
be able to accommodate what you need; otherwise you could find a simple (but
less functional) design or floorplan software.

"elika" wrote:


I want to change the grid into a pattern of square cells. I want the hight
and width to be equal. Can this be done?

The reason is that I want to use the grid as a background for simple
drawings of products. Is there perhaps a better way to do this in an
office-program?

  #4   Report Post  
Posted to microsoft.public.excel.setup
elika
 
Posts: n/a
Default square cells

Thank you so much for your help! I think I got it!

"elika" skrev:


I want to change the grid into a pattern of square cells. I want the hight
and width to be equal. Can this be done?

The reason is that I want to use the grid as a background for simple
drawings of products. Is there perhaps a better way to do this in an
office-program?

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking Groups of cells between workbooks vnacj-joe Excel Discussion (Misc queries) 4 June 14th 07 05:18 PM
checking that cells have a value before the workbook will close kcdonaldson Excel Worksheet Functions 8 December 5th 05 04:57 PM
Counting empty cells within a range of cells Rosehill - ExcelForums.com New Users to Excel 0 April 7th 05 12:47 AM
Help adding text values Texas-DC_271 Excel Worksheet Functions 7 January 15th 05 11:14 PM
Convert data type of cells to Text,Number,Date and Time Kevin Excel Worksheet Functions 1 December 31st 04 12:57 PM


All times are GMT +1. The time now is 03:49 PM.

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"