Remember Me?

#1
September 20th 05, 07:59 PM
 ChessNut Posts: n/a
How to make row height to exactly equal column width?

I want to make all rows and all columns the exact same size. How do I do that?

#2
September 20th 05, 08:50 PM
 Gord Dibben Posts: n/a

Chess

Assuming 96 pixels per inch you could approximate but at different resolutions

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, 20 Sep 2005 11:59:07 -0700, "ChessNut"
wrote:

I want to make all rows and all columns the exact same size. How do I do that?

#3
September 20th 05, 08:58 PM
 Gary''s Student Posts: n/a

Height is measured in points (72 points to the inch)
Width is measured in points (12 points to the inch)

To make a chess board with 1 inch squares, select the entire worksheet and
set all the row heights to 72 and column widths to 12
--
Gary''s Student

"ChessNut" wrote:

I want to make all rows and all columns the exact same size. How do I do that?

#4
September 20th 05, 10:20 PM
 bill kuunders Posts: n/a

Or to do it in pixels
17 pixels high and 20 wide will give you the smallest possible square
--
greetings from New Zealand
Bill Kuunders

"Gary''s Student" wrote:

Height is measured in points (72 points to the inch)
Width is measured in points (12 points to the inch)

To make a chess board with 1 inch squares, select the entire worksheet and
set all the row heights to 72 and column widths to 12
--
Gary''s Student

"ChessNut" wrote:

I want to make all rows and all columns the exact same size. How do I do that?

#5
September 21st 05, 12:27 AM
 Dave Peterson Posts: n/a

Or search www.shareware.com for some graph paper software???

ChessNut wrote:

I want to make all rows and all columns the exact same size. How do I do that?

--

Dave Peterson

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Anna / Ideal Excel Worksheet Functions 14 August 10th 05 04:28 PM Tess Excel Discussion (Misc queries) 1 August 4th 05 03:39 PM PeterAtherton Excel Discussion (Misc queries) 0 July 28th 05 11:58 PM Buzzcut Excel Discussion (Misc queries) 1 May 3rd 05 05:24 PM Sam via OfficeKB.com Excel Worksheet Functions 12 April 17th 05 10:36 PM

All times are GMT +1. The time now is 12:57 PM.