In Microsoft Excel, there is no automatic gridline printing. Gridlines are useful for viewing data because they distinguish between rows and columns. This allows the users to have a clear separator among the empty cells. Gridlines also help to make the printed data more attractive. In this article, we will learn how to print empty gridlines in Excel.
Download the Practice Workbook
2 Handy Approaches to Print Empty Gridlines in Excel
In this article, we will discuss three handy ways to print empty gridlines in Excel. We will start by using the Print Area feature in Excel. This feature allows the user to select the cells they want to print prior to opting for the print option. In the second method, we will use the Page Layout option. This option gives users a comprehensive set of options to print their Excel sheets. We will use those options to accomplish the task. We will use the sample dataset below to illustrate the methods.
1. Using Print Area Feature to Print Empty Gridlines in Excel
In this method, we opt for the Print Area feature to print empty cells with gridlines. Follow the outlined steps below to do it.
- Firstly, select the cells that you want to print.
- In this case, we will select the cells in the range A1:E8.
- Secondly, go to the Page Layout tab from the ribbon.
- Thirdly, select the Print Area tab.
- Finally, from the drop-down options select the Set Print Area command.
- After that, go to the Page Layout tab again.
- Next, select Sheet Options.
- Finally, check the Print option from Gridlines.
- Then, click on the File tab on the ribbon.
- After that, select Print from the options.
- Finally, you will find your empty cells are ready to print with gridlines.
2. Utilizing Page Layout Tab to Print Empty Gridlines in Excel
In this instance, we will go for the Page Layout option in Excel to print empty gridlines. Follow the ensuing steps to complete the task.
- Firstly, go to the Page Layout tab.
- Then, select the dialog box option from the Page Setup group.
- Consequently, a dialogue box will appear.
- Secondly, in the dialogue box, go to the Sheet tab
- Then, select the upward arrow sign from the option named “Print Area” to select the print area.
- Thirdly, from the worksheet select the area you want to print.
- In our case, the range of cells will be A1:E10.
- Finally, select the downward arrow sign to confirm it.
- Consequently, you will see the selected range is added to the Print Area option box.
- After that, check the checkbox beside the Gridlines option.
- Finally, select Print Preview.
- As a result, you will find that your selected area is ready to be printed.
Gridlines are important in separating rows and columns. Especially in empty cells, gridlines are the only distinguishing factors among the cells. So it is very important to have gridlines while printing empty cells. After going through this article, readers will have a complete understanding of how to print empty gridlines in Excel. If you find it useful, please let us know in the comment section below and share any recommendations and thoughts regarding this or any other content of ours. Thank you for your time. Follow ExcelDemy.com for more articles like this.