How to Print Empty Gridlines in Excel (2 Easy Ways)

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.

Step 1:

  • 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.

2 Handy Approaches to Print Empty Gridlines in Excel

Step 2:

  • After that, go to the Page Layout tab again.
  • Next, select Sheet Options.
  • Finally, check the Print option from Gridlines.

2 Handy Approaches to Print Empty Gridlines in Excel

Step 3:

  • Then, click on the File tab on the ribbon.

2 Handy Approaches to Print Empty Gridlines in Excel

Step 4:

  • After that, select Print from the options.

2 Handy Approaches to Print Empty Gridlines in Excel

Step 5:

  • Finally, you will find your empty cells are ready to print with gridlines.

2 Handy Approaches to Print Empty Gridlines in Excel

Read More: How to Print a Blank Sheet with Lines in Excel (3 Effective Ways)


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.

Step 1:

  • Firstly, go to the Page Layout tab.
  • Then, select the dialog box option from the Page Setup group.
  • Consequently, a dialogue box will appear.

2 Handy Approaches to Print Empty Gridlines in Excel

Step 2:

  • 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.

Sample Data

Step 3:

  • 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.

Sample Data

Step 4:

  • 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.

Sample Data

Step 5:

  • As a result, you will find that your selected area is ready to be printed.

2 Handy Approaches to Print Empty Gridlines in Excel

Read More: How to Print Gridlines in Excel Online (2 Easy Ways)


Conclusion

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.


Related Articles

Adnan Masruf

Adnan Masruf

I am an engineering graduate. I graduated from Bangladesh University of Engineering and Technology(BUET), one of the top universities in Bangladesh from department of Naval Architecture & Marine Engineering with a major in structure. I am an avid reader of fiction especially fantasy. I also keep myself abreast of the recent developments in science and technology. I believe diligence will eventually pay off and luck tends to favor those who work hard.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo