✦Template Printable Ideas Insights

Print Excel with Gridlines: A Simple Guide

By

Ever needed to print an Excel spreadsheet with the gridlines visible? By default, Excel hides gridlines during printing to apoptosis. But what if you need to keep them? Maybe you're creating a report where visual cues are essential, or perhaps you want to maintain the same layout as displayed on the screen. Today, we'll guide you through simple steps on how to print Excel with gridlines, ensuring your output remains true to its on-screen form.

ća nned to know that gridlines differentiate one cell from another, providing a visual boundary, especially vital when dealing with multiple columns and rows, or larger data sets. Being able to print these lines can enhance the readability of your reports and spreadsheets, making it easier for others to understand your data. So, let's dive right in and see how to make this happen.

Printing Excel with Gridlines: Step-by-Step

Below, we've detailed a basic yet effective process to print Excel with gridlines visible. We'll cover this across two primary methods: adjusting print settings and using the Page Layout view.

an excel spreadsheet showing how to use the balance sheet in microsoft's workbook
an excel spreadsheet showing how to use the balance sheet in microsoft's workbook
Guide: Print Blank Grid lines On Excel Sheet
Guide: Print Blank Grid lines On Excel Sheet
How to print gridlines with Excel 2013
How to print gridlines with Excel 2013

The chosen method ultimately depends on your preference and the version of Excel you're using. Both methods are designed to be straightforward and easily replicable.

Method 1: Adjust Print Settings

This method involves tweaking your Excel print settings to include gridlines in your output. Here's how:

Change the Gridline Color in Excel Spreadsheets - 2 Ways!
Change the Gridline Color in Excel Spreadsheets - 2 Ways!
How to print gridlines in Excel
How to print gridlines in Excel
Excel Formula Cheat Sheet Printable - Excel Functions Guide PDF - Excel Reference Sheet Digital Download
Excel Formula Cheat Sheet Printable - Excel Functions Guide PDF - Excel Reference Sheet Digital Download

  • Open your Excel document, and go to the 'File' tab, then select 'Print'.
  • In the 'Page Setup' group, click on 'Print what'.
  • Choose 'Selection' instead of 'Active sheets'. This will only print the selected area.
  • Now, under 'Settings', click on 'More settings'.
  • In the 'Page Setup' dialog box that opens, ensure the 'Sheet' section is selected, then click on the 'Print selected comments, ink, and formulas' checkbox.
  • Finally, click 'OK', then click 'Print' on the 'Print' panel to print your spreadsheet with gridlines.

Test this method by printing a small range of cells. If it works, adjust your selection as needed before printing your entire sheet.

How do I print the gridlines in my spreadsheet in Excel 2007, 2010 and 2013?
How do I print the gridlines in my spreadsheet in Excel 2007, 2010 and 2013?
Excel Worksheet Printing Tips - Printing Problem Fixes
Excel Worksheet Printing Tips - Printing Problem Fixes
How to Show/Hide Grid Lines in Excel - Grids Not Showing Up in Excel Worksheet - NO ADS
How to Show/Hide Grid Lines in Excel - Grids Not Showing Up in Excel Worksheet - NO ADS
Printing in Excel 1 - Print the Gridlines when an Excel Spreadsheet is Printed
Printing in Excel 1 - Print the Gridlines when an Excel Spreadsheet is Printed
How to Format Your Excel Spreadsheets (Complete Guide) | Envato Tuts+
How to Format Your Excel Spreadsheets (Complete Guide) | Envato Tuts+
How to Print Gridlines in Excel - A Step-By-Step Guide
How to Print Gridlines in Excel - A Step-By-Step Guide

Method 2: Using Page Layout View

The Page Layout view offers a complete visual of your print layout, including gridlines, headers, footers, and margins. Here's how to use it:

  • First, switch to 'Page Layout' view by clicking on the appropriate icon at the bottom-left of your screen (it looks like a monitor).
  • You'll now see your gridlines displayed, mimicking the output of your printed or exported document.
  • You can now format your spreadsheet exactly as you want it to appear in the printout.
  • Once you're satisfied, simply hit 'Ctrl + P' (Windows) or 'Command + P' (Mac) to print your spreadsheet with gridlines.

[FREE] 141 Free Excel Templates and Spreadsheets
[FREE] 141 Free Excel Templates and Spreadsheets
How to Print Gridlines in Excel
How to Print Gridlines in Excel
How to Make Graph Paper in Excel (+ video tutorial)
How to Make Graph Paper in Excel (+ video tutorial)

By using the Page Layout view, you have complete control over your print output, ensuring only the desired area prints – including gridlines.

When Should You Print Excel with Gridlines?

Gridlines can significantly improve the readability and understanding of your data, especially when handing over your work to colleagues or presenting it in a meeting. Here are a few instances where printing Excel with gridlines might be beneficial:

  • Data Reports: If you're creating reports, visible gridlines can make it easier for others to understand relationships within the data.
  • Presentations: During live presentations, gridlines can guide the audience through your data, making it simpler for them to follow along.
  • Collaboration: If you're working with others, printed gridlines can help facilitate better communication and understanding among your team members.

In conclusion, printing Excel with gridlines is typically done when you want your printed or exported document to reflect exactly what's on your screen, enhancing readability and facilitating easier data navigation for others. The chosen method ultimately depends on your personal preference and the version of Excel you're using. With either method, you can print Excel with gridlines and bring your data to life."