How to print Gridlines in Excel with empty cells

By default, when you print a worksheet in Microsoft Excel, the program removes the grid lines separating each cell. To preserve the grid lines in your printout, you must modify the display settings for each applicable worksheet. Microsoft Excel, however, only shows borders around cells containing actual data. If you want the program to print grid lines for empty cells as well, make sure to include those cells in the print area.

1. Select the worksheet or worksheets you want to print, and then click the "Page Layout" tab.

2. Check "Print" under Gridlines in the Sheet Options group, and then press "Ctrl-P" to go to the Print window.

3. Choose your printer from the associated drop-down menu, and then click the "Print" button to send your selected worksheet or worksheets to the print queue.

References

• Microsoft Office: Print Gridlines in a Worksheet - Excel

Tips

• To select more than one worksheet, hold down "Ctrl" and click each worksheet you want to print. To select all of the worksheets in your workbook, right-click any worksheet and choose "Select All Sheets" from the context menu.
• To define the print area for your worksheet, highlight the columns and rows to include, select "Print Area" on the Page Layout tab, and then choose "Set Print Area" from the drop-down menu.

Warnings

• Information in this article applies to Excel 2013. It may vary slightly or significantly with other versions or products.

Writer Bio

Ruri Ranbe has been working as a writer since 2008. She received an A.A. in English literature from Valencia College and is completing a B.S. in computer science at the University of Central Florida. Ranbe also has more than six years of professional information-technology experience, specializing in computer architecture, operating systems, networking, server administration, virtualization and Web design.

If you’ve ever tried to print a page of Excel cells that didn’t have any information in them, then you probably know that it can be kind of difficult. Luckily there is a way to make a blank Excel sheet printable that doesn’t involve any strange hacks like white text or copying and pasting into a Word document.

How to Print 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.

Our guide continues below with additional information on how to make a blank Excel sheet printable, including pictures of these steps.

Find out more about how to add entire columns in Excel with a formula that you can quickly add to one of your spreadsheets.

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.

Learn about creating tables in Excel and how to take advantage of this powerful tool for sorting and adding cell data.

Printing Blank Tables in Excel 2013 (Guide with Pictures)

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.

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

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

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

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.

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.

Now that you know how to make a blank Excel sheet printable you will be able to create all of the blank grids and tables that you need for manually data recording.

You can find additional information here on using a setting in Excel that lets you quickly expand all of the rows in your spreadsheet at once.

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.

Additional Sources

Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.

After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.

His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.

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

Microsoft Excel has a lot of uses, both at home and at work. One way that you can use it is when you’re writing a checklist or an inventory. But you may be having trouble trying to figure out how to print empty gridlines in Excel since Excel doesn’t like to print cells that don’t have anything in them.

How to Print a Blank Excel Sheet with Gridlines

1. Open Excel and create a new blank workbook.
2. Select the cells that you want to print.
3. Click the Page Layout tab at the top of the window.
4. Click the Print Area button, then choose the Set Print Area option.
5. Check the box to the left of Print under Gridlines in the Sheet Options section of the ribbon.

The steps in this article are going to show you how to format a blank Excel spreadsheet so that it will print, with gridlines.

We covered the steps briefly at the top of this guide, then we will continue further below with additional information and pictures for the steps.

Microsoft Excel spreadsheets have long been difficult to print in a manner that makes them easy to read. You can adjust a number of options to fix this, however, such as choosing to print your data with gridlines.

But even if you have gone through the various Page Setup menus in Excel and made all of the necessary changes, none of it is going to matter if you are trying to print a blank spreadsheet. Luckily this is something that you can do, but you need to take an extra step first. So continue reading below to find out how to print a blank Excel sheet with gridlines.

Our how to remove page 1 watermark in Excel guide can show you ways to add or remove watermarks on your spreadsheets.

How to Print a Blank Excel Grid With Gridlines (Guide with Pictures)

The steps in this article were performed in Microsoft Excel 2013, but the same method will work in most other versions of Excel. The situations where I ‘m typically printing gridlines on a blank spreadsheet are when I am performing a task where I need to write information into a grid format, such as taking a manual inventory, or keeping track of information where I don’t have a computer.

Essentially what we are doing in the guide below is manually defining the size of the spreadsheet, then adding gridlines.

Typically Excel defines the size of your spreadsheet by the cells that contain data, then it prints those cells. When you try to print a worksheet that doesn’t contain any data, Excel isn’t going to print anything. By setting a Print Area we are forcing Excel to print the defined range of cells that we need.

Step 1: Open Excel and choose to create a new workbook.

Step 2: Click on the top-left cell that you want to include in the blank grid, then drag your mouse to select the rest of the cells to include in the blank spreadsheet.

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

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

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

You should now be able to click the File tab and then click Print to see a preview of how the blank sheet will look. You can also use the keyboard shortcut Ctrl + P to get to this Print menu instead.

The resulting printout should be a blank Excel worksheet containing the number of blank rows and blank columns that you specified when you set the print area.

Now that you know how to print empty gridlines in Excel you can proceed to make more adjustments to the formatting of the empty grid so that it better suits your needs.

You can learn how to make Excel gridlines darker if you find that the current line color is too light to be able to see it easily.

More information on How to Format an Empty Excel Grid for Printing

If you want to make some additional changes to your grid’s formatting, you can find many of those options by clicking the small Page Setup dialog button at the bottom-right corner of the Page Setup section of the ribbon. This opens the Page Setup dialog box.

There you will find the menu shown below, where you will see a Page tab, a Margins tab, a Header/Footer tab, and a Sheet tab. The options on these tabs let you do things like set the orientation of the page, add information that repeats on each printed page, or specify the number of pages that the empty cells and blank rows should fit onto.

You can achieve a similar result if you choose to add cell borders rather than enabling the print option for gridlines. The Borders options are found on the Home tab, in the Font section of the ribbon. You are going to want to select the All Borders option.

Frequently Asked Questions About Making a Blank Printable Spreadsheet in Excel

While the focus of this article has been on printing empty spreadsheets, you may also need to customize the sheet a bit before you get the layout that you want.

You can print spreadsheet with lines in Microsoft Excel by selecting the Page Layout tab at the top of the window, then checking the box next to Print under the Gridlines section.

Note that Excel only prints cells that have data in them by default, so you will also need to set a print area for your spreadsheet if you want to print empty cells.

An excel spreadsheet will only print cells that include information inside of them, so you need to create a print area if you want to make a blank spreadsheet printable in Excel.

You can make a print area by selecting the cells you want to print, clicking the Page Layout tab at the top of the window, selecting the Print Area button, then clicking Set Print Area.

After you have made a print area and enabled gridlines, you may discover that your spreadsheet is a little too big to fit on one page.

Rather than trying to fix this manually, you can click the File tab at the top of the window, select the Print tab at the left side of the window, then click the No Scaling button and choose the Fit Sheet on One Page option.

Alternatively, you could select the Fit All Columns on One Page or the Fit All Rows on One Page if you only want to control those ranges.

Additional Reading

Matt Jacobs has been working as an IT consultant for small businesses since receiving his Master’s degree in 2003. While he still does some consulting work, his primary focus now is on creating technology support content for SupportYourTech.com.

His work can be found on many websites and focuses on topics such as Microsoft Office, Apple devices, Android devices, Photoshop and more.