Maybe this code from Ole Erlandson can help?

Set your rows and columns to mm(2.54 is 1/10th inch.)

You will have to play with print settings and zoom to try to fit all on one
page as you wish.

Sub SetColumnWidthMM(ColNo As Long, mmWidth As Integer)
' changes the column width to mmWidth
Dim w As Single
If ColNo < 1 Or ColNo 255 Then Exit Sub
Application.ScreenUpdating = False
w = Application.CentimetersToPoints(mmWidth / 10)
While Columns(ColNo + 1).Left - Columns(ColNo).Left - 0.1 w
Columns(ColNo).ColumnWidth = Columns(ColNo).ColumnWidth - 0.1
Wend
While Columns(ColNo + 1).Left - Columns(ColNo).Left + 0.1 < w
Columns(ColNo).ColumnWidth = Columns(ColNo).ColumnWidth + 0.1
Wend
End Sub

Sub SetRowHeightMM(RowNo As Long, mmHeight As Integer)
' changes the row height to mmHeight
If RowNo < 1 Or RowNo 65536 Then Exit Sub
Rows(RowNo).RowHeight = Application.CentimetersToPoints(mmHeight / 10)
End Sub


Sub ChangeWidthAndHeight()
Dim w As Long
Dim r As Long
For w = 1 To 75
SetColumnWidthMM w, 2.54
Next w
For r = 1 To 100
SetRowHeightMM r, 2.54
Next r
End Sub


Gord Dibben MS Excel MVP

On Fri, 20 Feb 2009 01:18:11 GMT, "HIOX8" <u49758@uwe wrote:

Bernard, thank you for your response. I was already aware of most of what you
had suggested.Perhaps if I explain what I need the template for, you will
better understand the solution. It involves diagramming a seating plan for
various size halls and various numbers of chairs. Some chairs are rigid steel
with padded backs and seats, others are molded plastic supported by heavy
wire frames, and then we also have the standard steel folding chairs whose
basic design has been around for decades and is duplicated by hundreds of
manufacturers. Each chair, regardless of its design, has a footprint, or area
encompassed by its four legs, of about 18 inches square. For individual
comfort and ease of access, each chair needs to be positioned within an area
about 3 feet (36 inches) wide and four feet (48 inches long). From the back
of every chair to the back of the seat in front of it, would be four feet
(48 inches) and from the right side of every chair to the corresponding right
side of the chair to its left, there shouild be three feet (36 inches). I now
figure a scaled graph template with a grid or cell size of .125 inch (1/8
inch) per inch will work nicely. Each cell would represent 6 inch squares on
the floor. Thus, one chair in the diagram will cover 9 cells on the template,
and the 3 foot by 4 foot zone will cover 48 cells on the template. The brick
and mortar problem is one of acoustics. A new hall we started meeting in is
larger than most high school gymnasiums, and with chairs in a rectangular
pattern, speakers facing front in the front row cannot be heard by most of
the people in the rows behind. The arrangement of the chairs based on the
number of people in attendance and on the size of the hall can make a
difference as to who hears who. Thus, a well thought out, adjustable seating
plan needs to be devised. To encourage attendees to sit where they can be
heard and/or where they can hear, requires the more luxurious padded chairs
to be strategically placed. The diagram will reflect that by color coding the
different types of chairs. I was thinking of having preprinted paper
templates with fifteen chairs in each template that can be arranged angularly
to other identical templates before scanning the images to a single floor
plan, which may be utilized only one time for one hall. The fifteen chair
template would have four chairs in the front row, five chairs in the middle
row, and six in the back row. The back row would be 16.5 feet from the the
right side of the right chair to the left side of the sixth or last chair on
the left end of the row. Allowing one aisle three and a half feet wide at one
end of each set of fifteen chairas, that mini template would have 40 cells
for the back row, and so on and so forth.

Bernard Liengme wrote:
"in Microsoft excel 2007 by setting each column individually to .1" width
(75 times)"
Why not select 75 columns (the column headers A thru BW) and set the width
all at once
How do you get 0.1" when Excel uses pixels?

But why use Excel. I got what you wanted with in 3 minutes using a graph
paper printing software I have had for years. Google "graph paper printer"
and you will get 0.1M hits -- many to free software

best wishes
I need a simple way to create an empty cell graph with 75 columns with each
column .1 inch wide and 100 rows with each row .1 inch high. This implies
[quoted text clipped - 22 lines]
to
build a baseball field.