1. Home
  2. MS Office
  3. Convert excel worksheet into graph paper

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.

a4

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.

3 Comments

  1. 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

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.