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.

click top left

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

row height

Enter value 20 as row height,

row height `1

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

column width

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

graph size

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.

a4 paper

Now from Sheet Options, enable Print options under Gridlines.

print grid

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

graph paper

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