✦Template Printable Ideas Insights

How to Create Graph Paper in Excel 2013

By

Ever needed to create graph paper for a project or assignment? While not a standard feature, Microsoft Excel 2013 allows you to create graph paper with a bit of creativity and simple steps. This guide will walk you through the process of creating graph paper in Excel 2013, making it perfect for planning, drawing, or even making unique patterns.

Before we begin, ensure you've opened Microsoft Excel 2013 and have a new or blank workbook ready. Let's dive right in and make your custom graph paper!

Setting Up Your Excel Sheet

To start, we'll configure your Excel sheet to mimic graph paper. This involves adjusting cell sizes, adding borders, and choosing the right colors.

How to Make Graph Paper in Excel (+ video tutorial)
How to Make Graph Paper in Excel (+ video tutorial)
How to Make Graph Paper in Excel - Tutorial
How to Make Graph Paper in Excel - Tutorial
How To Create Graph Paper In Excel
How To Create Graph Paper In Excel

First, change the width and height of your cells. Click the 'File' tab, then 'Options' at the bottom left corner. Under 'Advanced', scroll down to ' obrasz ' and entering '8.43' in the box next to 'Standard width'. In the row below, enter '14.17' for 'Standard height'. Now, press 'OK'.

Adding Borders and Shading

To make your graph paper look more like its paper counterpart, add borders and shading. Select the range of cells where you want your graph paper (e.g., A1:X60). Go to the 'Home' tab, click 'Format' in the 'Number' group, and choose 'Format Cells'.

A step-by-step guide to making a graph on Excel
A step-by-step guide to making a graph on Excel
How to Make a Graph from Excel - Lindsay Bowden
How to Make a Graph from Excel - Lindsay Bowden
How to Make Graph Paper in Excel
How to Make Graph Paper in Excel

In the pop-up window, select the 'Border' tab. Choose 'Preset 1 - Thick Box' (third row, third column). Check 'Outline' to add an outer border. Next, choose a light grey color for 'Fill' under the 'Fill' tab. Your selected cells should now display the chosen color. Click 'OK'.

Creating Graph Lines

Next, we'll add lines to create the grid-like appearance of graph paper. Using the 'Insert' tab, click the down arrow in the 'Shapes' group and choose 'Line'. Hold down the 'Shift' key while clicking and dragging from one cell corner to the opposite corner to create a diagonal line.

With the line still selected, click the 'Format' tab under 'Drawing Tools'. In the 'Size' group, enter '1.25' in the width box. Change the line color to match your borders (usually black). Repeat this process for vertical and horizontal lines, stepping through every fifth cell to create a grid.

How to Make a Line Graph in Excel
How to Make a Line Graph in Excel
How to create Graph in Microsoft Excel
How to create Graph in Microsoft Excel
How To Build Your Excel Charts & Graphs Easily (Beginners)
How To Build Your Excel Charts & Graphs Easily (Beginners)
Free Printable Graph Paper
Free Printable Graph Paper
How To Create Charts and Graphs in Excel
How To Create Charts and Graphs in Excel
How to Create a Graph in Excel
How to Create a Graph in Excel

Customizing Your Graph Paper

Now that you've created the basic structure of your graph paper, you can customize it to fit your needs. Add labels, change colors, or adjust cell sizes to make your graph paper truly unique.

Want to add labels or text? Click on the cell where you want to place text, and start typing. You can also adjust the font size and style using the 'Home' tab under 'Font'.

Creating Graph Paper with Different Sizes

Needing a graph paper with a different size or layout? You can easily adjust your graph paper's dimensions. To change the number of squares in a row or column, simply expand or shrink your selection when adding borders and shading. Remember to adjust the number of lines accordingly when creating your grid.

How to make line chart or graph in Excel
How to make line chart or graph in Excel
a graph paper that has been drawn in two different ways, with one line at the bottom
a graph paper that has been drawn in two different ways, with one line at the bottom
10 Free Printable Graph Paper Templates (Docs)
10 Free Printable Graph Paper Templates (Docs)

You can also create graph paper with unusual dimensions, like a square grid or one with more rows than columns. Just modify your cell selection and border placement accordingly.

That's it! You've now mastered the art of creating graph paper in Excel 2013. Experiment with different sizes, colors, and labels to design custom graph paper tailored to your projects. Happy graphing!