How to Print a Blank Spreadsheet in Excel 2013

Last updated: December 27, 2016

There are many situations where a blank spreadsheet might be helpful. If you are manually recording information, such as with a physical inventory, then you may find it easiest to create a spreadsheet in Excel that you can print and fill out. But Excel will only print cells that contain information by default, which can make it difficult to achieve your desired result.

One way to print a blank grid in Excel 2013 is to create a print area, and elect to print gridlines. This will enable you to create a blank grid or table that you can then print out from your computer. Our how-to guide below will show you what you need to do to print a blank table with dimensions of your own choosing.

 

Printing Blank Tables in Excel 2013

The steps in this article will show you how to print a completely blank spreadsheet in Microsoft Excel. You will need to know how many rows and columns you want in the table, then you will need to make some minor adjustments to the size of those rows and columns based on your needs with the table. We will also include a step that shows you how to force the table to fit on one page, but you can skip that option if it does not apply to you.

 

Step 1: Open Microsoft Excel 2013 and create a new workbook.

 

Step 2: Use your mouse to highlight the size of the table that you want to create. In the image below I am selecting 7 columns and 12 rows.

select the desired size of your blank table

 

 

Step 3: Click the Page Layout tab at the top of the window.

click the page layout tab

 

 

Step 4: Click the Print Area button in the Page Setup section of the navigational ribbon, then click the Set Print Area option.

set the print area

 

 

Step 5: Check the box to the left of Print under Gridlines in the Sheet Options section of the navigational ribbon.

click print under gridlines

 

 

Step 6: Adjust the row heights and column widths as needed. You can change row heights and column widths by dragging the borders of the row numbers and column letters, or by right-clicking a row number or column letter and choosing the Row Height or Column Width option. This article can show you how to change row height if you are not familiar with the process.

edit the row heights and column widths

 

 

Step 6: Click File at the top-left corner of the window, then click the Print option to open the Print menu. If your table is set to print on more than one page, but you want to keep it on just one page, then click the No Scaling button and choose the Fit Sheet on One Page option. You can then print your blank table.

click the fit sheet on one page option

 

 

Summary – How to create a blank spreadsheet in Excel 2013

  1. Use your mouse to highlight the desired size of your blank spreadsheet.
  2. Click the Page Layout tab.
  3. Click the Print Area button, then click the Set Print Area option.
  4. Check the box to the left of Print under Gridlines in the Sheet Options section.
  5. Manually adjust cell widths and printing options as needed.

If you have a header row at the top of your spreadsheet and you want to print it on every page, then this article can show you how.

solveyourtech.com newsletter
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.