Microsoft Excel does not print with gridlines automatically. Gridlines are helpful with viewing data as it separates row and column from one another. In this article, you will learn how to print gridlines with empty cells in excel. Check this link for more information.
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
2 Methods to Print Gridlines with Empty Cells in Excel
In the following, we will show you 2 methods to print gridlines with empty cells or empty workbooks in excel.
1. Use Page Layout Option to Print Empty Cells with Gridlines in Excel
With the help of the Page Layout option, we can print empty cells with gridlines. In the following, we will describe the method to do it.
Step 1:
- Open a workbook in excel. Go to Page Layout > Page Setup icon to open the Page Setup dialogue box.
- In the Page Setup dialogue box, choose “Sheet” and click on the ‘Gridlines’
- Press OK.
Step 2:
- Select the cells which will be printed.
- Page Layout > Print Area > Set Print Area.
- Go to “Print”.
- In the Print Preview section, you will see the page with gridlines.
Thus, we can print gridlines with empty cells.
Read More: How to Not Print Empty Cells in Excel (3 Simple Methods)
Similar Readings
- How to Print Sheet on One Page in Excel (9 Easy Ways)
- How to Print to PDF in Excel VBA : With Examples and Illustrations
- Excel VBA Debug Print: How to Do It?
- How to Print Landscape in Excel (3 Easy Methods)
- How to Print Address Labels in Excel (2 Quick Ways)
2. Set a Specific Print Area to Print Gridlines with Empty Cells
In the following method, we will apply a shortcut method to print gridlines by selecting a specific print area.
Step 1:
- Open a workbook and select the cells to print.
- Click “Format” and change “Row Height” and “Column Width” according to the desired adjustment.
Step 2:
- Go to the Page Layout option and click on the “Print” option under the “Gridlines” column.
- Then select our print area with “Set Print Area” option.
- After that, in the print preview section, we will find our desired gridlines with empty cells.
Read More: How to Print Selected Area in Excel (2 Examples)
Things to Remember
- In the second method, after selecting “Page Layout” we will find two “Print” options to choose from. To print gridlines, we must select the “Print” option in the “Gridlines” column.
Conclusion
I hope you will find this article helpful. If you find any problems, feel free to ask us in the comment section.