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

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.

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 Empty Gridlines in Excel (2 Easy 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.

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 Not Print Empty Cells in Excel (3 Simple Methods)


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.


Related Articles

Wasim Akram

Wasim Akram

Hi! my name is Wasim Akram. I am a graduate in mechanical engineering from Ahsanullah University of Science & Technology. I am passionate about learning new things and writing articles. I write article about Microsoft Excel and it's my favourite thing to do.

We will be happy to hear your thoughts

Leave a reply

5 Excel Hacks You Never Knew

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS

ExcelDemy
Logo