How to Print Excel with Lines on One Page (3 Easy Methods)

This tutorial will demonstrate how to print excel with lines on one page. When submitting the reports or bills update, it is essential to print the whole report or bill with proper lining on one page. Moreover, in some cases, the rows and columns of the excel workbook can be significant. So, we need to print the worksheet along with the lines. After going through this article, you will learn how to print excel with lines on one page.


Download Practice Workbook

You can download the practice workbook from here.


3 Easy Methods to Print Excel with Lines on One Page

Our aim is to print excel with lines on one page. To fulfill that, we will learn 3 methods. If you follow the steps of the methods correctly, you should know how to print excel with lines on one page.

1. Using Sheet Options

We can print excel with lines on one page by using Sheet Options. In this case, the lines are marked as Gridlines in the worksheet. We are going to learn this by following the below steps:

Steps:

  • First, select the Page Layout tab.
  • Then, from Sheet Options, go to the Gridlines option and tick the View option. Again, do the same for the Headings option.

Methods to Print Excel with Lines on One Page

  • After that, select the Print option under the View option in the Gridlines.

Methods to Print Excel with Lines on One Page

Methods to Print Excel with Lines on One Page

  • Afterward, select the Print option.

  • Next to this, you will see the Print window open on your display screen.

Methods to Print Excel with Lines on One Page

  • Finally, you will get the below result.

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


2. Applying Directly from Menu Tab

Our goal is to print excel with lines on one page. This time we will do that using directly from the Menu tab. The steps are described below:

Steps:

  • Firstly, go to the Page Layout option and select the Page Setup option.

Methods to Print Excel with Lines on One Page

  • Secondly, the Page Setup window will come on the screen.
  • Thirdly, go to the Sheet option and click on the Gridlines option.
  • Next, choose the Print Preview option and click OK.

Methods to Print Excel with Lines on One Page

  • After that, the Print window will come on your screen.

Methods to Print Excel with Lines on One Page

  • Furthermore, select the Print option.

Methods to Print Excel with Lines on One Page

  • Lastly, you will get results similar to the below image.

Methods to Print Excel with Lines on One Page

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


3. Use of Print Preview Mode

Using Print Preview Mode can be another useful method for printing excel with lines on one page. The steps are described below.

Steps:

  • Initially, go to the File tab.

  • Second, similar to the first method go to the Print option and select the Page Setup option.

  • Afterward, the Page Setup dialog box will open on the screen.
  • Like method 2, go to Sheet>Gridlines>Print Preview>OK.

  • Last, you will the desired output.

Read More: How to Hide Gridlines in Excel When Printing (4 Quick Tricks)


Converting Printed Gridlines Color

In the case of printing with gridlines, sometimes changing the color of the gridlines can be useful to display the printed copy to understand easily. This can be done by following the below steps:

 Steps:

  • To begin with, go to the File tab.

Converting Printed Gridlines Color

  • In addition, choose the Options.

  • Furthermore, the Excel Options window will open on your screen.
  • After that, tick the Show gridlines options from the Advanced option.
  • Next, select desired color from the Gridline color option and press OK.

  • Finally, you will get your desired result.

Converting Printed Gridlines Color


Troubleshooting Issues of Printing

If any printed version of any copy has a missing border line after following the above-described methods, then this can be solved in this process. The process is described below.

Steps:

  • First, go to Page Layout> Page Setup.
  • Next, in the Sheet window untick the Draft Quality option and press OK.
  • Last, you will find your problem solved.

Troubleshooting Issues of Printing

Read More: [Fixed!] Missing Gridlines in Excel When Printing (5 Solutions)


Things to Remember

  • You can follow any of the methods but make sure the method you follow is correct from first to last. If you mix the methods, then it will create a troubleshooting problem.
  • In case of choosing the color of the printed gridlines, make sure you have chosen the light colors otherwise the printed copy color can disappoint you.

Conclusion

Henceforth, follow the above-described methods. Thus, you will learn how to print excel with lines on one page. Let us know if you have more ways to do the task. Follow the ExcelDemy website for more articles like this. Don’t forget to drop comments, suggestions, or queries if you have any in the comment section below.


Zehad Rian Jim

Zehad Rian Jim

Hi there! I am Zehad Rian Jim. I graduated with a bachelor's degree in engineering from BUET. Currently, I am working as a technical content writer at ExcelDemy. You will find all my articles on Microsoft Excel on this site. Outside of the workplace, my hobbies and interests include watching movies, tv series, and meeting new people. I also enjoy sports. My favorite sports are Cricket (to watch and play) and Badminton (play).

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo