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.

clicktopleft thumb Convert Excel Worksheet Into Graph PaperView in gallery

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

rowheight Convert Excel Worksheet Into Graph PaperView in gallery

Enter value 20 as row height,

row height `1View in gallery

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

column widthView in gallery

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

graph sizeView in gallery

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

a4View in gallery

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

a4 paperView in gallery

Now from Sheet Options, enable Print options under Gridlines.

print gridView in gallery

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

graph paperView in gallery

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

  • Pingback: Excel 2010 Remove Row & Column Headers()

  • me

    Good To know

  • Terisa Haman

    Creative comments , Speaking of which , if anyone has been looking for a NCAR SF 2-T , my business partner encountered a fillable form here http://goo.gl/qvH5CV