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.
Step 4: Click the Page Setup button at the bottom-right corner of the Page Setup section of the ribbon.
Step 5: Click the Sheet tab at the top of the window.
Step 6: Check the box to the left of Gridlines, then click inside the Print Area field at the top of the window.
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.
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.
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.