Greetings all!

I am having difficulty with printing graph lines on a spreadsheet. This is
a spreadsheet form which is printed off for our Sales Reps to use in
gathering data from a customer. On the back of the form, they would like
graph lines so that each "box" is exactly 1/4" x 1/4". They will use this
form for an office layout which is then given to our design department.

I am running Excel 2003; the closest I seem to be able to get is a cell that
is 2.57 wide by 18.75 high. The resulting printout seems accurate, however,
when I try and print out an entire page of cells - my "graph paper" - if you
measure across, it is not to scale. We use 1/4" = 1 ' scale. If I measure
over 24 cells, it should be exactly 6", however the result is actually 6
1/8th.

Is it possible for excel to print exact 1/4" x 1/4" squares to be used as
scale graph paper?

Thanks!

See http://peltiertech.com/Excel/Charts/SquareGrid.html
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"MarkT" wrote in message
...
Greetings all!

I am having difficulty with printing graph lines on a spreadsheet. This
is
a spreadsheet form which is printed off for our Sales Reps to use in
gathering data from a customer. On the back of the form, they would like
graph lines so that each "box" is exactly 1/4" x 1/4". They will use this
form for an office layout which is then given to our design department.

I am running Excel 2003; the closest I seem to be able to get is a cell
that
is 2.57 wide by 18.75 high. The resulting printout seems accurate,
however,
when I try and print out an entire page of cells - my "graph paper" - if
you
measure across, it is not to scale. We use 1/4" = 1 ' scale. If I
measure
over 24 cells, it should be exactly 6", however the result is actually 6
1/8th.

Is it possible for excel to print exact 1/4" x 1/4" squares to be used as
scale graph paper?

Thanks!

Thanks Bernard,

I copied the macro to a new worksheet but I'm getting an error. Do I need
to have some sort of chart displayed first?

"Bernard Liengme" wrote:

See http://peltiertech.com/Excel/Charts/SquareGrid.html
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"MarkT" wrote in message
...
Greetings all!

I am having difficulty with printing graph lines on a spreadsheet. This
is
a spreadsheet form which is printed off for our Sales Reps to use in
gathering data from a customer. On the back of the form, they would like
graph lines so that each "box" is exactly 1/4" x 1/4". They will use this
form for an office layout which is then given to our design department.

I am running Excel 2003; the closest I seem to be able to get is a cell
that
is 2.57 wide by 18.75 high. The resulting printout seems accurate,
however,
when I try and print out an entire page of cells - my "graph paper" - if
you
measure across, it is not to scale. We use 1/4" = 1 ' scale. If I
measure
over 24 cells, it should be exactly 6", however the result is actually 6
1/8th.

Is it possible for excel to print exact 1/4" x 1/4" squares to be used as
scale graph paper?

Thanks!

You can try this graph paper template from the MS Template Gallery.

http://office.microsoft.com/en-us/te...CT101448201033

If not satisfactory try this method...........

If you want to use VBA to set height and width in mm which you can convert to
inches............

Ole Erlandson has code for setting row and column dimensions.

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


Gord Dibben Excel MVP

On Thu, 18 Jan 2007 07:28:04 -0800, MarkT
wrote:

Greetings all!

I am having difficulty with printing graph lines on a spreadsheet. This is
a spreadsheet form which is printed off for our Sales Reps to use in
gathering data from a customer. On the back of the form, they would like
graph lines so that each "box" is exactly 1/4" x 1/4". They will use this
form for an office layout which is then given to our design department.

I am running Excel 2003; the closest I seem to be able to get is a cell that
is 2.57 wide by 18.75 high. The resulting printout seems accurate, however,
when I try and print out an entire page of cells - my "graph paper" - if you
measure across, it is not to scale. We use 1/4" = 1 ' scale. If I measure
over 24 cells, it should be exactly 6", however the result is actually 6
1/8th.

Is it possible for excel to print exact 1/4" x 1/4" squares to be used as
scale graph paper?

Thanks!

Hi Gord,

I did see that template from MS, however it was set to the wrong scale for
me to use.

I tried to use the macro that you suggested, however I can't seem to get
that to work either? Do you have to enter in the width and height in the
macro? Nothing seems to happen when I run it as is.

Thanks again for your help.

"Gord Dibben" wrote:

You can try this graph paper template from the MS Template Gallery.

http://office.microsoft.com/en-us/te...CT101448201033

If not satisfactory try this method...........

If you want to use VBA to set height and width in mm which you can convert to
inches............

Ole Erlandson has code for setting row and column dimensions.

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


Gord Dibben Excel MVP

On Thu, 18 Jan 2007 07:28:04 -0800, MarkT
wrote:

Greetings all!

I am having difficulty with printing graph lines on a spreadsheet. This is
a spreadsheet form which is printed off for our Sales Reps to use in
gathering data from a customer. On the back of the form, they would like
graph lines so that each "box" is exactly 1/4" x 1/4". They will use this
form for an office layout which is then given to our design department.

I am running Excel 2003; the closest I seem to be able to get is a cell that
is 2.57 wide by 18.75 high. The resulting printout seems accurate, however,
when I try and print out an entire page of cells - my "graph paper" - if you
measure across, it is not to scale. We use 1/4" = 1 ' scale. If I measure
over 24 cells, it should be exactly 6", however the result is actually 6
1/8th.

Is it possible for excel to print exact 1/4" x 1/4" squares to be used as
scale graph paper?

Thanks!

Mark

You must copy both sets of code from Ole's page

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

Then use a macro to run the code.

This macro changes columns 1 to 40 and rows 1 to 40 to 6.35mm squares(1/4")

Sub ChangeWidthAndHeight()
Dim w As Long
Dim r As Long
For w = 1 To 40
SetColumnWidthMM w, 6.35
Next w
For r = 1 To 40
SetRowHeightMM r, 6.35
Next r
End Sub


Gord

On Thu, 18 Jan 2007 09:37:02 -0800, MarkT
wrote:

Hi Gord,

I did see that template from MS, however it was set to the wrong scale for
me to use.

I tried to use the macro that you suggested, however I can't seem to get
that to work either? Do you have to enter in the width and height in the
macro? Nothing seems to happen when I run it as is.

Thanks again for your help.

"Gord Dibben" wrote:

You can try this graph paper template from the MS Template Gallery.

http://office.microsoft.com/en-us/te...CT101448201033

If not satisfactory try this method...........

If you want to use VBA to set height and width in mm which you can convert to
inches............

Ole Erlandson has code for setting row and column dimensions.

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


Gord Dibben Excel MVP

On Thu, 18 Jan 2007 07:28:04 -0800, MarkT
wrote:

Greetings all!

I am having difficulty with printing graph lines on a spreadsheet. This is
a spreadsheet form which is printed off for our Sales Reps to use in
gathering data from a customer. On the back of the form, they would like
graph lines so that each "box" is exactly 1/4" x 1/4". They will use this
form for an office layout which is then given to our design department.

I am running Excel 2003; the closest I seem to be able to get is a cell that
is 2.57 wide by 18.75 high. The resulting printout seems accurate, however,
when I try and print out an entire page of cells - my "graph paper" - if you
measure across, it is not to scale. We use 1/4" = 1 ' scale. If I measure
over 24 cells, it should be exactly 6", however the result is actually 6
1/8th.

Is it possible for excel to print exact 1/4" x 1/4" squares to be used as
scale graph paper?

Thanks!

Hi Gord,

Finally able to try your answer and it worked out great!

thank you very much.

"Gord Dibben" wrote:

Mark

You must copy both sets of code from Ole's page

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

Then use a macro to run the code.

This macro changes columns 1 to 40 and rows 1 to 40 to 6.35mm squares(1/4")

Sub ChangeWidthAndHeight()
Dim w As Long
Dim r As Long
For w = 1 To 40
SetColumnWidthMM w, 6.35
Next w
For r = 1 To 40
SetRowHeightMM r, 6.35
Next r
End Sub


Gord

On Thu, 18 Jan 2007 09:37:02 -0800, MarkT
wrote:

Hi Gord,

I did see that template from MS, however it was set to the wrong scale for
me to use.

I tried to use the macro that you suggested, however I can't seem to get
that to work either? Do you have to enter in the width and height in the
macro? Nothing seems to happen when I run it as is.

Thanks again for your help.

"Gord Dibben" wrote:

You can try this graph paper template from the MS Template Gallery.

http://office.microsoft.com/en-us/te...CT101448201033

If not satisfactory try this method...........

If you want to use VBA to set height and width in mm which you can convert to
inches............

Ole Erlandson has code for setting row and column dimensions.

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


Gord Dibben Excel MVP

On Thu, 18 Jan 2007 07:28:04 -0800, MarkT
wrote:

Greetings all!

I am having difficulty with printing graph lines on a spreadsheet. This is
a spreadsheet form which is printed off for our Sales Reps to use in
gathering data from a customer. On the back of the form, they would like
graph lines so that each "box" is exactly 1/4" x 1/4". They will use this
form for an office layout which is then given to our design department.

I am running Excel 2003; the closest I seem to be able to get is a cell that
is 2.57 wide by 18.75 high. The resulting printout seems accurate, however,
when I try and print out an entire page of cells - my "graph paper" - if you
measure across, it is not to scale. We use 1/4" = 1 ' scale. If I measure
over 24 cells, it should be exactly 6", however the result is actually 6
1/8th.

Is it possible for excel to print exact 1/4" x 1/4" squares to be used as
scale graph paper?

Thanks!

Good to hear.

Thanks Mark

On Thu, 1 Feb 2007 08:57:00 -0800, MarkT
wrote:

Hi Gord,

Finally able to try your answer and it worked out great!

thank you very much.

"Gord Dibben" wrote:

Mark

You must copy both sets of code from Ole's page

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

Then use a macro to run the code.

This macro changes columns 1 to 40 and rows 1 to 40 to 6.35mm squares(1/4")

Sub ChangeWidthAndHeight()
Dim w As Long
Dim r As Long
For w = 1 To 40
SetColumnWidthMM w, 6.35
Next w
For r = 1 To 40
SetRowHeightMM r, 6.35
Next r
End Sub


Gord

On Thu, 18 Jan 2007 09:37:02 -0800, MarkT
wrote:

Hi Gord,

I did see that template from MS, however it was set to the wrong scale for
me to use.

I tried to use the macro that you suggested, however I can't seem to get
that to work either? Do you have to enter in the width and height in the
macro? Nothing seems to happen when I run it as is.

Thanks again for your help.

"Gord Dibben" wrote:

You can try this graph paper template from the MS Template Gallery.

http://office.microsoft.com/en-us/te...CT101448201033

If not satisfactory try this method...........

If you want to use VBA to set height and width in mm which you can convert to
inches............

Ole Erlandson has code for setting row and column dimensions.

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


Gord Dibben Excel MVP

On Thu, 18 Jan 2007 07:28:04 -0800, MarkT
wrote:

Greetings all!

I am having difficulty with printing graph lines on a spreadsheet. This is
a spreadsheet form which is printed off for our Sales Reps to use in
gathering data from a customer. On the back of the form, they would like
graph lines so that each "box" is exactly 1/4" x 1/4". They will use this
form for an office layout which is then given to our design department.

I am running Excel 2003; the closest I seem to be able to get is a cell that
is 2.57 wide by 18.75 high. The resulting printout seems accurate, however,
when I try and print out an entire page of cells - my "graph paper" - if you
measure across, it is not to scale. We use 1/4" = 1 ' scale. If I measure
over 24 cells, it should be exactly 6", however the result is actually 6
1/8th.

Is it possible for excel to print exact 1/4" x 1/4" squares to be used as
scale graph paper?

Thanks!