How to Make Graph Paper Template in Excel

This post will guide you how to create graph paper template in your worksheet in Excel. How to do I turn an Worksheet into graph paper in Excel 2013/2016.

Make Graph Paper Template

To Make a worksheet as graph paper in Excel, you just need to do the following steps:

Step1: go to Insert tab in the Excel Ribbon, click on Shapes command under Illustrations group, and then select Rectangle from the Rectangles section.

make graph paper template1

Step2: you can draw a rectangle in your current worksheet, and then you need to go to the Shape Format tab, and specify the rectangle’s height and width in the Size group. you should set the same size for both height and width.

make graph paper template2

make graph paper template3

Step3: right click on it and select the Size and Properties from the drop down menu list. And the Format Shape pane will appear.

make graph paper template4

Step4: check the option Don’t move or size with cells option in the SHAPE OPTIONS .

make graph paper template5

Step5: move the rectangle to the top-left corner, just over Cell A1.

Step6: select any one cell and then press Ctrl + A keys on your keyboard to select the entire worksheet.

make graph paper template6

Step7: hover the mouse over the right border of the Column A’s header cell. And when the cursor turns into a double-arrow, drag the border until same to the rectangle. And then adjust Row1’s height same to the rectangle.

Step8: you should see that excel will adjust all the selected rows and columns.

make graph paper template7

Step9: click on the File tab, and click Save As menu to save this workbook to your local disk as a template, you need to select Excel Template from the drop down list in the Save As dialog box.

make graph paper template8

Leave a Reply