How to Print Empty Cells in Excel 2010

While most of what you do in Microsoft Excel 2010 is meant to be viewed on a monitor, you will inevitably need to generate a document that gets printed out. Properly configuring a document for printing presents its’ own set of problems but, once you have done it enough and familiarized yourself with the rules and settings, you should be able to accomplish your printing goals. However, you might need to print out an empty spreadsheet at some point because you will be filling in the information manually. But the solution for how to print empty cells in Excel 2010 is not immediately obvious, as you may have already discovered. Excel will only print columns and rows that contain data, so you need to make some changes to the empty document before it will print out how you want.


Print Out a Sheet of Empty Cells in Excel 2010


If you need to physically write out a checklist or take an inventory, then the structure of a blank Excel 2010 document can be appealing. It will keep all of your information from running together, while also providing a means for you to keep the data organized. But even if you fill out the information in the first column of an Excel spreadsheet, the rest of the cells will not print unless you have entered data into their columns. But there is a solution to this problem that will allow you to generate any size printed spreadsheet you require.


Step 1: Launch Microsoft Excel 2010.

Step 2: Adjust the width and height of your columns as needed, and enter any information into the cells that you wish. You do not need to enter any information to make this work, but you can if you need to.

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

excel 2010 page layout tab


Step 4: Click the Page Setup button at the bottom-right corner of the Page Setup section of the ribbon.

excel 2010 page setup button


Step 5: Click the Sheet tab at the top of the window.

click the sheet tab


Step 6: Check the box to the left of Gridlines, then click inside the Print Area field at the top of the window.

how to print empty cells in excel 2010


Step 7: Use your mouse to select all of the empty cells that you want to print. Note that this will populate the Print Area field with values that correspond to the cells that you just selected.

excel 2010 sample print area values


After the print area has been selected, click the Print Preview button to see how to printed document will look, then click the Print button to create the Excel 2010 sheet of empty cells. newsletter

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