Convert Excel Worksheet Into Graph Paper

If you have been mapping out on graph paper, now you can make it by yourself using Excel sheet. All you need to do, is to start tweaking with the row and column height. In Excel, you can change the height, and width of gridlines which enables you to create traditional graph paper, out of gridlines. This post will try a trick of converting Excel sheet in to traditional graph, and make it ready for print on A4 size paper.

Launch Excel 2010, open a work book which you want to print as graph paper. Now click at the top-left corner of the worksheet.

Navigate to Home tab, and from Format options, click Row Height.

Enter value 20 as row height,

From Format options, click Column width, and enter 5 as column width, click OK

Now you will see the Excel sheet look like a Graph paper.

Now if you want to print it on A4 size paper, navigate to Page Layout tab, and from Size options click A4 size.

You will notice that Excel automatically divide the graph paper size, as specified.

Now from Sheet Options, enable Print options under Gridlines.

Merge & Center the first row to enter a suitable title for graph. Now your Excel sheet is ready to print as Graph sheet.

You can check out previously reviewed guides on Difference between Absolute & Relative Referencing & How to split columns in Excel 2010.

Read Full Bio

Usman Javaid

Follow me on Google+

Latest from Author

How To Create A Portable Windows 8 Enterprise To Go Workspace How To Install Windows 8 As Guest OS Using VMware Player