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

If you want to print a blank worksheet with lines, Excel won’t be able to print anything by default. You have to go through some procedures to do this. The main objective of this article is to explain how to print blank Excel sheet with lines.


Download Practice Workbook


3 Easy Ways to Print a Blank Sheet with Lines in Excel

To explain this article, I have taken the following blank Excel sheet.

Easy Ways to Print a Blank Sheet with Lines in Excel

If you want to print a blank Excel sheet like this one, you will get a message like the following image.

Easy Ways to Print a Blank Sheet with Lines in Excel

Here, I will show you how to print a blank Excel sheet with lines in 3 different ways.


1. Using Print Area Feature to Print Blank Excel Sheet with Lines

In this method, I will show you how to print a blank Excel sheet with lines using the Print Area feature.
Let’s see the steps.

Steps:

  • Firstly, select the cells that you want to print.
  • Secondly, go to the Page Layout tab from the Ribbon.
  • Thirdly, select Print Area.

Now, you will see a drop-down menu will appear.

  • After that, select Set Print Area from the drop-down menu.

Here, you will see that your selected cells have been set as Print_Area.

Using Print Area Feature to Print Blank Excel Sheet with Lines

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

Now, I will check the Print Preview.

  • Firstly, go to the File tab.

Using Print Area Feature to Print Blank Excel Sheet with Lines

  • Secondly, select Print.

Here, in the Print Preview, you will see that Excel will now print blank sheets with lines.

Using Print Area Feature to Print Blank Excel Sheet with Lines

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


2. Employing Page Layout Tab to Print a Blank Sheet with Lines

In this second method, I will show you how to print a blank Excel sheet with lines by employing Page Setup.
Let’s see the steps.

Steps:

  • First, go to the Page Layout tab.
  • Secondly, select the dialog box option from Page Setup.

Employing Page Layout Tab to Print a Blank Sheet with Lines

Now, you will see a dialog box named Page Setup will appear.

  • Firstly, go to the Sheet tab
  • Secondly, select the marked button to select the Print Area.

Employing Page Layout Tab to Print a Blank Sheet with Lines

  • After that, select the cells that you want to print.
  • Next, select the marked button to add the selected cells to your Print Area.

  • After that, check the Gridlines option from Print.
  • Finally, select Print Preview.

Employing Page Layout Tab to Print a Blank Sheet with Lines

Here, in the Print Preview, you will see that the blank sheet with lines has been printed.

Read More: How to Show Gridlines in Excel When Printing (6 Easy Ways)


3. Using Print Option to Print Blank Sheet with Lines

In this method, I will explain the way to print using the Print option.
Let’s see the steps.

Steps:

  • Firstly, select the cell range that you want to print.
  • Secondly, go to the File tab.

Using Print Option to Print Blank Sheet with Lines

  • Thirdly, select Print.

  • Now, select the marked drop-down option from Settings to set the Print Area.

Using Print Option to Print Blank Sheet with Lines

  • After that, select Print Selection from the drop-down menu.

  • Next, select Page Setup.

Using Print Option to Print Blank Sheet with Lines

Now, you will see a dialog box named Page Setup has appeared on the screen.

  • Firstly, go to the Sheet tab.
  • Secondly, check the Gridlines option from Print.
  • Finally, select OK.

Using Print Option to Print Blank Sheet with Lines

In the Print Preview, you will see that Excel will now print your blank sheets with lines.

Using Print Option to Print Blank Sheet with Lines

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


Practice Section

Here, I have provided a blank sheet for you to practice by yourself.


Conclusion

To conclude, I tried to explain how to print a blank sheet with lines in Excel. Here, I covered 3 different methods of doing it. I hope, this article was helpful for you. To get more articles like this visit ExcelDemy. Lastly, if you have any questions, feel free to let me know in the comment section below.


Related Articles

Mashhura

Mashhura

Hey! Welcome to my profile. Right now, I am doing research on Microsoft Excel. I will be posting articles related to this here. My last educational degree was B.Sc in Industrial and Production Engineering from Bangladesh University of Engineering and Technology. I like to explore new things and find the best and most innovative solutions in every situation.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo