Excel Graph Paper: Create a Grid in a Worksheet

Charts & pivot tables · Updated November 18, 2026

Yes. You can make graph paper in Excel by setting worksheet columns and rows to small, consistent sizes, then printing the gridlines or adding borders for darker lines. In Excel for Microsoft 365 on Windows, the key controls are under Home > Format and Page Layout; the steps below help you make a grid that is useful on screen and legible on paper.

What Excel graph paper is

Excel does not have a dedicated graph-paper template built into the worksheet grid. Instead, you adapt the ordinary cells: narrow columns and short rows create small squares, while gridlines or cell borders make those squares visible. The result can serve as plain graph paper, a coordinate grid, a planning sheet, or a background for a simple diagram.

A worksheet has many more rows and columns than a typical printed page can hold. Decide first how large the printed grid should be. For example, a block of 25 columns by 35 rows can make a compact page section, while a larger block may require landscape orientation or multiple sheets of paper. The size of the grid cells and the number of cells determine how much usable drawing area you get.

Excel’s normal on-screen gridlines are not cell contents. They help you see cell boundaries while editing, but they are not included on printouts unless you enable printing. Borders, by contrast, are formatting applied to cells and can be printed. Knowing this difference helps you choose a method that matches your purpose.

Create a basic grid

For a quick printable grid, set the dimensions of the columns and rows you plan to use, then turn on printing for gridlines. On Windows, you can build it as follows:

  1. Select the columns for the grid by dragging across their column letters. Select the rows by dragging across their row numbers. For a grid in A1:Z40, select columns A through Z and rows 1 through 40.
  2. Go to Home > Format > Column Width. Enter a small value, such as 2.14, and select OK.
  3. With the intended rows selected, go to Home > Format > Row Height. Enter a value such as 15 and select OK.
  4. Go to Page Layout. In the Sheet Options group, under Gridlines, select the Print checkbox.
  5. Open File > Print to inspect the preview before printing.

The sample dimensions are a starting point, not a guarantee of a perfect square on every system. Column width uses a character-based measurement tied to the workbook’s Normal style font, while row height is measured in points. Use the next section to fine-tune the proportions.

Make the cells look square

Excel’s column-width and row-height units are different, so entering the same number for both will not make square cells. With the default Calibri 11-point Normal style on many Windows installations, a column width around 2.14 and a row height of 15 points often look close to square. The exact result can vary with the workbook font, display scaling, and printer.

To tune the grid visually, select one or more columns and rows, set their dimensions, then inspect a small block at a consistent zoom level. If the cells look taller than they are wide, increase the column width or reduce the row height; if they look wider, do the reverse. Zoom changes how the grid appears on the screen, not the stored row and column dimensions.

For a more reliable printed result, check the preview and make a test print on the paper you plan to use. Printer margins and page scaling can affect the final appearance. If you use a scaling option to fit the grid to a page, Excel resizes the printed content, so verify that the squares remain useful for your intended task. A hand-drawn measurement on the test page can reveal whether the cells are close enough to square.

Choose gridlines or cell borders

Printed gridlines are the fastest option for a light, uniform graph-paper background. They are controlled by the worksheet’s print settings, not by the cell formatting. They also cannot be given different weights or colors in the same flexible way as borders. If the preview appears blank, first check Page Layout > Sheet Options > Gridlines > Print.

Use borders when you need more control. Select the grid range, then use Home > Borders to apply borders to the cells. A light border around every cell gives a defined grid; stronger borders can mark larger intervals. For example, on a grid with ten small squares per major division, you can apply a heavier border after each tenth row and column. This takes more setup, but it creates a more deliberate graph-paper style and does not depend on the gridline print checkbox.

A practical compromise is to use printed gridlines for the fine squares and borders for every fifth or tenth line. Make the major borders darker or thicker so they remain visible without overwhelming the smaller squares. Excel offers line color and line style choices in the border menus. Apply them to the intended cells, and check the print preview because very pale lines may be difficult to see on some printers.

If your grid uses borders, remember that selecting a range and applying All Borders changes the appearance of those cells. It does not change the worksheet’s normal gridlines. Borders are useful when you need a repeatable, self-contained design, such as a worksheet that will be shared or printed on a machine with different sheet settings.

Set paper size and print options

After creating the grid, choose a paper size and orientation that leave enough room for it. On Windows, use Page Layout > Size to select a paper size supported by your printer, and Page Layout > Orientation to choose Portrait or Landscape. Use Page Layout > Margins to choose a preset or adjust margins when the grid needs more printable space.

To print only the graph-paper area, select the cells you want and choose Page Layout > Print Area > Set Print Area. Then open File > Print and review the preview. This avoids printing unrelated worksheet content. If the grid is intended to span several pages, check where Excel places the page breaks; a grid split at an awkward point may be less useful than one printed on a single page.

Excel’s print settings can scale the worksheet to fit. In File > Print, the scaling control includes options such as fitting the sheet on one page. That may be convenient for a small grid, but it can shrink the squares too much. For a large graph, fitting to one page can make the paper unusable for plotting. Consider fitting the width to one page while allowing the height to span multiple pages, or leave scaling unchanged and accept a larger printout.

When the preview shows too many blank pages, check the print area and page breaks. When it shows a tiny grid surrounded by white space, confirm that the selected print area is correct and review scaling and margins. If the final result will be used for precise measurements, rely on the printed dimensions rather than assuming that the worksheet’s screen appearance matches the paper.

Use the grid for drawing and planning

Excel graph paper can be more than a blank pattern. The cell structure makes it useful for rough plans where one cell represents a fixed unit, such as one square on a sketch or one step in a layout. You can label axes, add a title above the grid, or shade selected cells to distinguish regions. If you add labels, keep them outside the drawing area or reserve a margin so the usable grid stays clear.

For example, a simple room-layout sketch might use one cell to represent a chosen distance, with shaded cell blocks showing furniture footprints. A classroom activity could use a grid for coordinate plotting, while a craft plan might use colored cells to map a repeating pattern. These are visual planning aids rather than engineering drawings: worksheet cell sizes and printer output should not be treated as precise physical measurements unless you calibrate and verify the printout.

To keep a drawing tidy, use a defined range rather than formatting the entire worksheet. Freeze panes are not usually necessary for a page-sized printable grid, but they can help if you are entering labels in a long working sheet. Avoid merging cells inside the drawing area when square cells matter, because merged cells disrupt the regular grid.

Save a reusable graph-paper template

Once the dimensions, borders, and print settings are right, save a reusable copy. Choose File > Save As and select Excel Template (*.xltx) if you want a clean starting point for future work. A template preserves formatting and page setup while letting you create new workbooks from it. If your workbook contains macros, use the macro-enabled template format only when macros are actually required.

Give the template a clear name and consider including a note about its scale, such as the intended cell size or the number of squares across the page. That information matters if another person uses the sheet or prints it with different scaling. Keep an unmodified copy as a master and make working copies for individual designs.

Common problems and fixes

  • Gridlines appear on screen but not in print: Enable the Print checkbox under Page Layout > Sheet Options > Gridlines, or apply borders to the cells.
  • The cells are rectangular: Adjust column width and row height separately. Their units differ, and the suggested starting values may need tuning for your font and printer.
  • The printout is too small: Check File > Print scaling. Fitting a wide or tall range to one page can shrink it substantially.
  • The grid prints across unexpected pages: Set a print area, inspect page breaks, and confirm paper size and orientation.
  • Some lines are hard to see: Use cell borders with a darker color or thicker style for important divisions, then check the preview.

Another common misunderstanding is that changing the worksheet zoom makes the printed graph squares larger. Zoom only changes the on-screen view. To change physical output, adjust row height or column width, or change print scaling and then verify the result.

Frequently Asked Questions

Can Excel print graph paper?
Yes. Set small row heights and column widths, then enable Page Layout > Sheet Options > Gridlines > Print. For stronger or customized lines, apply borders to the desired cells.

How do I make square cells in Excel?
Set column width and row height independently. A width around 2.14 and a height of 15 points can be a useful starting point with the default Normal font, but inspect the print preview and adjust because the dimensions depend on workbook and printer settings.

Why are Excel gridlines missing from my printout?
On-screen gridlines are not printed by default. Select the Print checkbox under Page Layout > Sheet Options > Gridlines, or use cell borders, which print as formatting.

Can I make every fifth line darker?
Yes. Apply borders to the full grid for the small squares, then select the rows and columns at the desired intervals and apply a thicker or darker border through Home > Borders. Check the print preview to confirm the contrast.

Can I make graph paper in Excel for Mac?
Yes. The same approach works in Excel for Mac: adjust row height and column width, and use the Page Layout tab’s print options. Ribbon labels and dialog layouts can differ slightly by Excel version, so use the equivalent Format and Page Layout controls if a path appears differently.

When another method may be better

Excel is convenient when you want a customizable grid alongside calculations, labels, or colored cell patterns. For a plain sheet with standard squares and no spreadsheet features, a ready-made graph-paper PDF or a word-processing page template may be faster. For precise technical drafting, use software designed for scaled drawing rather than relying on worksheet cells. If you stay in Excel, a carefully defined print area, consistent cell sizes, and a test print are the practical steps that make the result dependable.

Related

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.