I want a graph paper on my computer. But I am unsure hot to get it with the rows & columns of the same size. Is it possible with either Word or Excel? I am having Office 2003. I may upgrade to Office 2007 if that has some solutions.
I want a graph paper on my computer. But I am unsure hot to get it with the rows & columns of the same size. Is it possible with either Word or Excel? I am having Office 2003. I may upgrade to Office 2007 if that has some solutions.
To create a graph paper in Excel 2003, follow the below steps:
- Press Ctrl + A.
- Open the Format Menu.
- Select Row.
- Click Height.
- Change the Height to 13.
- Click OK.
- Open the Format menu again.
- Select Column.
- Click Width.
- Set the width to 1.5.
- Click OK.
- Select cells A1 through AS 58.
- Open the File menu.
- Click Page Setup.
- Click the Margins tab.
- Set all margins to 1 inches.
- Under Center on Page, out checks in both the Vertically and Horizontally boxes.
- Click OK.
- Open the File menu.
- Click Print.
- Click Print Selection under Print what.
- Click OK.
You can even do some kind of coding in VBA to create the graph paper:
Code:Sub GraphPaperCreator() Dim i As Long Dim cw Dim w Dim h Cells.ColumnWidth = Rows(1).Height With Cells(1) For i = 1 To 10 cw = .EntireColumn.ColumnWidth w = .EntireColumn.Width h = .EntireRow.Height Cells.ColumnWidth = (cw/w) * h Next i End With End Sub
To create a graph in Word:
1. Open a new Word Document.
2. Bring up the Draw menu by selecting View - Toolbars - Drawing.
3. Select Draw - Grid and set the Horizontal and Vertical spacing according
to the finest line spacing you want on your graph.
4. Set the Horizontal and Vertical Origins to 0.
5. Select Snap objects to grid
This will create your graph paper. Now you can draw anything using the Draw menu and use various tools which you may need for your graph.
Bookmarks