How to Print Gridlines with Empty Cells in Excel (2 Methods)

Get FREE Advanced Excel Exercises with Solutions!

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.

Set a Specific Print Area to Print Gridlines with Empty Cells

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.

Using Page Layout Option to Print Empty Cells with Gridlines in Excel

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.

Set a Specific Print Area to Print Gridlines with Empty Cells

  • After that, in the print preview section, we will find our desired gridlines with empty cells.

Set a Specific Print Area to Print 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.


Related Articles

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Wasim Akram
Wasim Akram

Wasim Akram holds a BSc degree in Industrial and Production Engineering from Ahsanullah University of Science and Technology. Over the past 2 years, he has been actively contributing to the ExcelDemy project, where he has authored more than 150 articles. Now, he is working as an Excel VBA and Content Developer. He likes learning new things about Microsoft Office, especially Excel VBA, Power Query, Data Analysis, and Excel Statistics. He is also very interested in machine learning and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo