How To Print Excel With Lines

Follow these steps to print an Excel spreadsheet with lines visible: adjust the page setup, go to the print preview to ensure the lines are visible, and select the desired printer and print the document.

How To Print Excel With Lines: Step-by-Step


Step 1: Open the Spreadsheet

Once you have opened the Excel spreadsheet, go to the Page Layout tab and click on the Print Area drop-down menu. From there, select Set Print Area. This will ensure that only the specified area will be printed with lines.

Next Step

Step 2: Apply Gridlines

Gridlines can be easily shown in your spreadsheet by navigating to the View tab, selecting the Gridlines option in the Show section. These lines provide a visual reference for the cells and enhance the readability of your data.

Next Step

Step 3: Set Print Area

By setting a specific section of your spreadsheet as the print area, you can easily print only that desired portion. To do this, highlight the area, go to Page Layout, choose Print Area, and click Set Print Area.

Next Step

Step 4: Set up the Page

In the Page Layout section, you can select between Portrait or Landscape orientation for your page. You can also adjust margins or scaling under Scale to Fit if needed.

Next Step

Step 5: Print Preview

Before printing your spreadsheet, it is advisable to preview it to ensure correct formatting with visible lines. To do this, go to File and click on Print. A preview will appear on the right side, where you can also specify the desired number of copies to print.

Next Step

Step 6: Print the Spreadsheet

In case the gridlines are still not printing, ensure that the Print box is checked in the Sheet Options section of the Page Layout tab before clicking the Print button.


In conclusion, learning how to print Excel with lines can greatly enhance the presentation and readability of your spreadsheet. By following the step-by-step guide outlined in this blog post, you can easily add gridlines to your Excel sheet and ensure that your data is organized and easy to understand. Whether you are working on a professional report, a budget spreadsheet, or any other project, incorporating lines into your printouts will make a significant difference in the overall aesthetics and professionalism of your work. So don’t hesitate to utilize this helpful feature and take your Excel prints to the next level.

Table of Contents