How to Print Excel With Lines?

  • Home
  • / How to Print Excel With Lines?

Most of us are familiar with the headaches that can come with printing out an Excel spreadsheet. Pages upon pages of tiny numbers, all jumbled together in a seemingly impossible-to-decipher mess.

But did you know that there’s a way to make your life (and your printer’s ink cartridge) just a little bit easier? Printing with gridlines can help to neaten up your spreadsheet and make it more legible.

Not to mention, it can also save you time and frustration when it comes time to enter data into your cells. So next time you’re getting ready to print out an Excel spreadsheet, take a few minutes to adjust your settings and add gridlines – your eyes will thank you!

All you have to do is to follow the below mentioned simple steps and you’ll be able to print your Excel spreadsheet with perfectly straight lines:

Advantages of Printing Excel with Gridlines

That’s right – printing gridlines is a great way to create a hard copy of your spreadsheet for reference purposes. Here are some other advantages of printing gridlines:

  • Gridlines are a helpful way to keep track of where you are in your spreadsheet and to make sure everything is aligned correctly.
  • They help you to quickly identify where the column and row headings are.
  • You can use them as guides when creating charts or graphs.
  • Printing excel sheets with gridlines can help you stay organized and make your data easier to read and understand.
  • Gridlines make it easy to align data and text in a workbook.
  • Gridlines can be turned on or off, depending on your needs.
  • They are helpful when you need to make precise measurements.
  • These can be customized to match your preferences.
  • They can help you to format your data in a more visually appealing way.

A Step-by-Step Guide to Print Excel with Gridlines

Here’s a step-by-step guide to printing gridlines in Excel:

Step 1: Open your workbook in Excel.

Step 2: Select the “Page Layout” tab on the ribbon and search for the “Page Setup: option.

Step 3: In the “Page Setup” group, click on the “Print Titles” button.

Step 4: A new window will open. In the “Sheet” tab, select the worksheet that you want to print gridlines.

Step 5: In the “Gridlines” drop-down menu, select the “On” option.

Step 6: Click on the “OK” button.

Step 7: Your worksheet should now be ready to print with gridlines!

Step 8: If you want to remove the gridlines, simply follow the same steps and select the “Off” option in Step 5.


So, there you have it! Your complete guide on how to print Excel with lines. We hope this was helpful and that you are now able to produce beautifully formatted printouts of your spreadsheets.  

If you found this article helpful, be sure to check out our other Excel tips and tricks. And as always, if you have any questions or feedback, please let us know in the comments below – we’d love to hear from you!

Write your comment Here