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.
How to Print Gridlines with Empty Cells in Excel: 2 Methods
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 Print Gridlines in Excel Online
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 Excel Sheet with Lines
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.
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
Conclusion
I hope you will find this article helpful. If you find any problems, feel free to ask us in the comment section.