How To Print Excel With The Lines

Productivity Software

Printing an Excel spreadsheet with the gridlines visible can be a crucial aspect of presenting your data clearly and professionally. As an expert in technical topics, I understand the significance of this requirement and can guide you through the process. Whether you’re preparing a financial report or a project plan, ensuring that the gridlines are printed along with the content can greatly enhance the readability of your document. Let’s explore the steps to achieve this in Excel.

Step 1: Open your Excel Spreadsheet

First, open the Excel spreadsheet that you want to print with the gridlines. If you haven’t already set up the document, make sure to organize the data and apply any necessary formatting before proceeding to the printing stage.

Step 2: Go to Page Layout

Next, navigate to the ‘Page Layout’ tab in the Excel ribbon. This is where you can access various settings related to how your spreadsheet will appear when printed. This tab contains options that allow you to customize the print layout, including the visibility of gridlines.

Step 3: Check ‘Print’ Gridlines

Within the ‘Page Layout’ tab, you’ll find the ‘Sheet Options’ group. Here, you can check the box labeled ‘Print’ under the ‘Gridlines’ section. By enabling this option, you ensure that the gridlines will be included when you print the spreadsheet. It’s a small but essential step in making sure your document is presented as intended.

Step 4: Preview and Adjust

It’s always a good idea to preview how your document will look before sending it to the printer. Excel provides a ‘Print Preview’ feature that allows you to see the layout exactly as it will appear on paper. This is the perfect opportunity to make any final adjustments to the formatting, ensuring that the gridlines align with your content as desired.

Step 5: Print Your Spreadsheet

Once you’re satisfied with the preview, you’re ready to print your Excel spreadsheet. Simply select the ‘Print’ option, choose your printing settings, and send the document to the printer. With the ‘Print’ gridlines option enabled, the printed copy will include the gridlines, providing a clear structure to your data.


Printing an Excel spreadsheet with the gridlines visible is a simple yet effective way to enhance the clarity of your data. By following these steps, you can ensure that the gridlines are included in your printed document, allowing for a professional and polished presentation of your Excel data. Remember, the details matter, and the visibility of gridlines can make a significant difference in how your spreadsheet is perceived.