Have been playing with column width and row heighth and border options
to make graph paper. A bit frustrating. Best I can figure so far is 6.013
to 1.0 ratio for heighth to width for a square cell. Are there any ready
made styles in excel. Thanks
Have been playing with column width and row heighth and border options
to make graph paper. A bit frustrating. Best I can figure so far is 6.013
to 1.0 ratio for heighth to width for a square cell. Are there any ready
made styles in excel. Thanks
More info here: http://www.mrexcel.com/tip071.shtml
Microsoft has a "Graph Paper" template that may give you some ideas.
http://office.microsoft.com/en-us/te...183751033.aspx
HTH
--
Dana DeLouis
Win XP & Office 2003
"keith" <[email protected]> wrote in message
news:%[email protected]...
> Have been playing with column width and row heighth and border options
> to make graph paper. A bit frustrating. Best I can figure so far is 6.013
> to 1.0 ratio for heighth to width for a square cell. Are there any ready
> made styles in excel. Thanks
>
>
There's a graph paper template on the Microsoft web site:
http://office.microsoft.com/en-gb/te...CT063455571033
keith wrote:
> Have been playing with column width and row heighth and border options
> to make graph paper. A bit frustrating. Best I can figure so far is 6.013
> to 1.0 ratio for heighth to width for a square cell. Are there any ready
> made styles in excel. Thanks
>
>
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
DD and DD? What are the odds of that? Thanks to both.
Followed the directions but couldn't get the sheet to open. But, then
again, there's a pretty good chance I don't know what I'm doing. I'll try
again. As for playing with cell dimensions, it is a bit strange. A square on
the screen isn't square on the printed page and vice versa. And even if you
tell the column or row what size to be they might decide to be something
just slightly different. Perhaps what I want to do isn't what excel was
intended for.
"Debra Dalgleish" <[email protected]> wrote in message
news:[email protected]...
> There's a graph paper template on the Microsoft web site:
>
>
>
http://office.microsoft.com/en-gb/te...CT063455571033
>
> keith wrote:
> > Have been playing with column width and row heighth and border
options
> > to make graph paper. A bit frustrating. Best I can figure so far is
6.013
> > to 1.0 ratio for heighth to width for a square cell. Are there any ready
> > made styles in excel. Thanks
> >
> >
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
Hello. I had no problem downloading the template. My security settings are
set high, so I had a prompt for ActiveX controls. Once I selected ok, it
downloaded with no problems.
To square a cell, Excel needs to do it in a loop. Not too long ago, someone
posted a neat solution. However, I apologize because I can't find the
name of the poster. I've search the newsgroups, and Google, but had no luck
finding this post.
Anyway, his general solution is the following. Set the Row height to what
you want, then run the macro to adjust the column widths.
Sub SquareAllCells()
Dim i As Long
Dim cw
Dim w
Dim h
Cells.ColumnWidth = Rows(1).Height
With Cells(1)
For i = 1 To 5
cw = .EntireColumn.ColumnWidth
w = .EntireColumn.Width
h = .EntireRow.Height
Cells.ColumnWidth = (cw / w) * h
Next i
End With
End Sub
--
Dana DeLouis
Win XP & Office 2003
"keith" <[email protected]> wrote in message
news:[email protected]...
> DD and DD? What are the odds of that? Thanks to both.
> Followed the directions but couldn't get the sheet to open. But, then
> again, there's a pretty good chance I don't know what I'm doing. I'll try
> again. As for playing with cell dimensions, it is a bit strange. A square
> on
> the screen isn't square on the printed page and vice versa. And even if
> you
> tell the column or row what size to be they might decide to be something
> just slightly different. Perhaps what I want to do isn't what excel was
> intended for.
> "Debra Dalgleish" <[email protected]> wrote in message
> news:[email protected]...
>> There's a graph paper template on the Microsoft web site:
>>
>>
>>
> http://office.microsoft.com/en-gb/te...CT063455571033
>>
>> keith wrote:
>> > Have been playing with column width and row heighth and border
> options
>> > to make graph paper. A bit frustrating. Best I can figure so far is
> 6.013
>> > to 1.0 ratio for heighth to width for a square cell. Are there any
>> > ready
>> > made styles in excel. Thanks
>> >
>> >
>>
>>
>> --
>> Debra Dalgleish
>> Excel FAQ, Tips & Book List
>> http://www.contextures.com/tiptech.html
>>
>
>
Keith
If you want to use VBA to set height and width in mm....which can be converted
to inches....
Ole Erlandson has code for setting row and column dimensions.
http://www.erlandsendata.no/english/...vbawssetrowcol
Gord Dibben Excel MVP
On Sun, 2 Jan 2005 23:28:51 -0500, "keith" <[email protected]> wrote:
> DD and DD? What are the odds of that? Thanks to both.
> Followed the directions but couldn't get the sheet to open. But, then
>again, there's a pretty good chance I don't know what I'm doing. I'll try
>again. As for playing with cell dimensions, it is a bit strange. A square on
>the screen isn't square on the printed page and vice versa. And even if you
>tell the column or row what size to be they might decide to be something
>just slightly different. Perhaps what I want to do isn't what excel was
>intended for.
>"Debra Dalgleish" <[email protected]> wrote in message
>news:[email protected]...
>> There's a graph paper template on the Microsoft web site:
>>
>>
>>
>http://office.microsoft.com/en-gb/te...CT063455571033
>>
>> keith wrote:
>> > Have been playing with column width and row heighth and border
>options
>> > to make graph paper. A bit frustrating. Best I can figure so far is
>6.013
>> > to 1.0 ratio for heighth to width for a square cell. Are there any ready
>> > made styles in excel. Thanks
>> >
>> >
>>
>>
>> --
>> Debra Dalgleish
>> Excel FAQ, Tips & Book List
>> http://www.contextures.com/tiptech.html
>>
>
If you know someone with Mac XL04, you can have them set column widths
and row heights directly in the GUI (inches, mm, cm).
I've got some sample graph paper sheets in various sizes here
ftp://ftp.mcgimpsey.com/excel/graph_paper.xls
In article <[email protected]>,
Gord Dibben <gorddibbATshawDOTca> wrote:
> If you want to use VBA to set height and width in mm....which can be converted
> to inches....
>
> Ole Erlandson has code for setting row and column dimensions.
>
> http://www.erlandsendata.no/english/...vbawssetrowcol
OK, now we've got Rectangular Graph Paper. What about Semi-Log or
Log-Log, Probability paper, Circular and Triangular Graph Papers. K&E
used to have a whole collection, but some one published a book with
them. You just copied the Graph paper you wanted from the book and
drew your graph: and turned in your homework.:-)
A Google search for "graph paper freeware" turns up a number of
possibilities.
Bill
"Pranas" <[email protected]> wrote in message
news:[email protected]...
OK, now we've got Rectangular Graph Paper. What about Semi-Log or
Log-Log, Probability paper, Circular and Triangular Graph Papers. K&E
used to have a whole collection, but some one published a book with
them. You just copied the Graph paper you wanted from the book and
drew your graph: and turned in your homework.:-)
Thanks to all. The macro approach is a bit out of my league but Google
caughed up some good options. Will try the ctech and nutsnbits links. Both
are downloadable .exe items that seem easy enough to use. Of course there's
always the Staples and/or Office Depot route. Thanks again to all.
Keith
"Bill Sharpe" <[email protected]> wrote in message
news:[email protected]...
> A Google search for "graph paper freeware" turns up a number of
> possibilities.
>
> Bill
>
> "Pranas" <[email protected]> wrote in message
> news:[email protected]...
> OK, now we've got Rectangular Graph Paper. What about Semi-Log or
> Log-Log, Probability paper, Circular and Triangular Graph Papers. K&E
> used to have a whole collection, but some one published a book with
> them. You just copied the Graph paper you wanted from the book and
> drew your graph: and turned in your homework.:-)
>
>
How do you get it to print out on a full page? Since it's empty, Excel tells
me there's nothing to print.
"JE McGimpsey" <[email protected]> wrote in message
news:[email protected]...
> If you know someone with Mac XL04, you can have them set column widths
> and row heights directly in the GUI (inches, mm, cm).
>
> I've got some sample graph paper sheets in various sizes here
>
> ftp://ftp.mcgimpsey.com/excel/graph_paper.xls
>
> In article <[email protected]>,
> Gord Dibben <gorddibbATshawDOTca> wrote:
>
> > If you want to use VBA to set height and width in mm....which can be
converted
> > to inches....
> >
> > Ole Erlandson has code for setting row and column dimensions.
> >
> > http://www.erlandsendata.no/english/...vbawssetrowcol
One way:
enter a space character at the bottom right corner of the area you which
to print.
In article <[email protected]>,
"Sandra" <[email protected]> wrote:
> How do you get it to print out on a full page? Since it's empty, Excel tells
> me there's nothing to print.
One way:
enter a space character at the bottom right corner of the area you which
to print.
Proving once again that although Excel is VERY smart, it's easily fooled.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks