Simon Sez IT

Online software training and video tutorials for Microsoft, Adobe & more

  • Course List
    • Adobe
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Flash
        • Flash CS5
      • InDesign
        • InDesign CS6
        • InDesign CS5
      • Photoshop
        • Photoshop CS6
        • Photoshop CS5
        • Adobe Photoshop CS4
      • Photoshop Elements
        • Photoshop Elements 2022
        • Photoshop Elements 2019
        • Photoshop Elements 2018
        • Photoshop Elements 15
        • Photoshop Elements 14
        • Photoshop Elements 13
        • Photoshop Elements 12
        • Photoshop Elements 11
        • Photoshop Elements 10
        • Photoshop Elements 9
        • Photoshop Elements 8
    • Microsoft
      • Access
        • Access 2021 Beginners
        • Access 2019
        • Access 2019 Advanced
        • Access 2016
        • Access 2016 Advanced
        • Access 2013
        • Access 2013 Advanced
        • Access 2010
        • Access 2010 Advanced
        • Access 2007
      • Excel
        • Data Analytics in Excel
        • Excel 2021 Advanced
        • Excel 2021 Intermediate
        • Excel 2021 Beginners
        • PivotTables for Beginners
        • Excel Dashboards
        • Advanced Formulas in Excel
        • Excel for Business Analysts
        • Advanced PivotTables
        • Power Pivot, Power Query and DAX in Excel
        • Excel 2019 Beginners (Mac)
        • Excel 2019 Beginners
        • Excel 2019 Advanced
        • Excel 2016 Beginners
        • Excel 2016 Intermediate
        • Excel 2016 Advanced
        • Excel 2013
        • Excel 2013 Advanced
        • Excel 2010 Beginners
        • Excel 2010 Advanced
        • Excel 2007
      • OneNote
        • OneNote Desktop and Windows 10
        • OneNote 2016
      • Outlook
        • Outlook 2021
        • Outlook 2019
        • Outlook 2016
        • Outlook 2013
        • Outlook 2010
        • Outlook 2007
      • Power Automate
        • Introduction to Power Automate
      • Power BI
        • Power BI
        • Power BI Intermediate
      • PowerPoint
        • PowerPoint 2021
        • PowerPoint 2019
        • PowerPoint 2016
        • PowerPoint 2013
        • PowerPoint 2010
        • PowerPoint 2007
      • Project
        • Project 2021 Beginners
        • Project for the Web
        • Project 2019
        • Project 2019 Advanced
        • Project 2016
        • Project 2016 Advanced
        • Project 2013
        • Project 2013 Advanced
        • Project 2010
        • Project 2010 Advanced
      • Publisher
        • Publisher 2013
      • SharePoint
        • SharePoint Online
        • SharePoint Foundation 2013
        • SharePoint Server 2013
        • SharePoint Foundation 2010
      • Teams
        • Microsoft Teams (2023 Update)
      • VBA
        • Macros and VBA for Beginners
        • VBA for Excel
        • VBA Intermediate Training
      • Visio
        • Microsoft Visio 2019
        • Visio 2016
        • Visio 2013
        • Microsoft Visio 2010
      • Windows
        • Windows 11 (2023 Update)
        • Windows 10 (2020 Update)
        • Windows 10
        • Windows 8
        • Windows 7
        • Windows Vista
      • Word
        • Word 2021
        • Word 2019 Advanced
        • Word 2019
        • Word 2016
        • Word 2013
        • Word 2010
        • Word 2007
    • QuickBooks
      • QuickBooks
        • QuickBooks Desktop Pro 2022
        • QuickBooks Pro 2021
        • QuickBooks Online Advanced
        • QuickBooks Online
        • QuickBooks Canada
        • QuickBooks Pro 2020
        • QuickBooks 2019
        • QuickBooks 2018
        • QuickBooks Pro 2017
        • QuickBooks Pro 2016
        • QuickBooks Pro 2015
        • QuickBooks Pro 2014
        • QuickBooks Pro 2013
        • QuickBooks Pro 2012
        • QuickBooks Pro 2011
        • QuickBooks Pro 2010
        • QuickBooks Pro 2009
    • Web Development
      • AngularJs
        • AngularJS Crash Course
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Bootstrap
        • Bootstrap Framework
      • Html/CSS
        • HTML/CSS Crash Course
        • HTML5 Essentials
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
      • Java
        • Java for Beginners
      • JavaScript
        • JavaScript for Beginners
        • jQuery Crash Course
      • MySql
        • MySQL for Beginners
      • PHP
        • PHP for Beginners
        • Advanced PHP Programming
      • XML
        • XML Crash Course
    • Data Analysis
      • Financial Modeling
        • Financial Risk Management
        • Financial Forecasting and Modeling
      • Data Analytics
        • Introduction to Analytics and Artificial Intelligence
        • Data Analytics in Excel
      • Alteryx
        • Alteryx Advanced
        • Introduction to Alteryx
      • Power BI
        • Power BI Intermediate
        • Power BI
      • Qlik Sense
        • Qlik Sense Advanced
        • Qlik Sense
      • R Programming
        • R Programming
      • Tableau
        • Tableau Desktop Advanced
        • Tableau Desktop
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
    • Work Productivity
      • Google Sheets
        • Google Sheets for Beginners
      • Confluence
        • Introduction to Confluence
      • Monday
        • Getting Started in Monday.com
      • Asana
        • Asana for Employees and Managers
        • Introduction to Asana
      • Jira
        • Getting Started in Jira
  • For Business
  • About Us
    • Testimonials
    • Contact Us
    • FAQ
    • Membership
    • About Us
  • Pricing
  • Free Resources
  • Sign In
  • Get Started
Home > Microsoft Excel > How to Print Gridlines in Excel?

How to Print Gridlines in Excel?

Note: This tutorial on how to print gridlines in Excel is suitable for all Excel versions including Office 365.

Gridlines are faint grey lines that are visible around the cells of an Excel worksheet. These Gridlines define columns, rows, and cell boundaries in Excel. They help you visually differentiate between cells and read the data better. 

When you print an Excel spreadsheet, these gridlines are usually discarded, presumably to save ink or reduce printing time. But, in some cases, you may want to keep them in the printed hard copy. Financial reports are a good example, where printing gridlines helps make sense of the data better.

Similarly, in some cases, it is advisable to switch off gridlines or edit them to see certain elements better. For example, if you are creating a dashboard, switching off the gridlines is very desirable to contrast the images or charts. 

In this guide, I will show you how to print gridlines in Excel, and also how to remove gridlines in Excel.

You’ll learn:

  • Borders vs Gridlines in Excel
  • How to Change the Colour of the Gridlines in Excel?
  • How to Print Gridlines in Excel?
  • How to Remove Gridlines in Excel?

Related:

6 Easy Methods to Strikethrough in Excel

How to Delete a Named Range in Excel? 3 Easy Methods

How to Enable Excel Dark Mode? 3 Simple Steps

Borders vs Gridlines in Excel

Gridlines and borders are commonly confused and used interchangeably. However, there is a significant difference that you should know when using these features. Borders can be applied to any specific region of the worksheet, whereas gridlines are fixed to the entire worksheet.

Borders vs Gridlines in Excel - How to print gridlines in Excel
Borders vs Gridlines in Excel

Moreover, you can edit the cell borders by changing colours, width, or style and print them. On the other hand, gridlines are usually not edited or printed by default. 

How to Change the Colour of the Gridlines in Excel?

Before we look at how to print gridlines in Excel, let us see how to change their colour first.

You can easily change the gridline colour in Excel, by following these steps.

  1. Open File > Options.
File>Options
File>Options
  1. Select the Advanced option in the left pane from Excel’s dialogue box. 
  1. Scroll down and locate the  Display options for this Worksheet section. 
Locate the Display options for this worksheet section in Advanced options
Locate the Display options for this worksheet section in the Advanced options section
  1. Pick a colour from the Gridline colour picker near the bottom of the section and click OK.
Pick a new gridline colour
Pick a new gridline colour

This will change the colour of the Gridline for the current worksheet.

Coloured Gridlines in Excel
Coloured Gridlines in Excel

If you want to edit the Gridline colours of all the worksheets together, group them together before applying the colour changes. 

After editing the colour, ungroup the sheets by right-clicking on the tab and select the Ungroup from the option. 

Please keep in mind that these edits will not change the default colour of the Gridlines of Excel. If you are inserting a new worksheet, it will be in the same light grey colour. 

Also Read:

How to Use Goal Seek in Excel? (3 Simple Examples)

How to Insert Multiple Rows in Excel? The 4 Best Methods

How to Autofit Excel Cells? 3 Best Methods

How to Print Gridlines in Excel?

The gridlines in Excel are usually not printed by default. However, if you really want to make the gridlines printed, there is actually a way to do that. Let us see how:

  1. Go to the Page Layout tab.
  1. Move to Gridlines within the Sheet options group.
  1. Check on the Print checkbox in the Gridlines.
Page Layout > Gridlines > Print How to print gridlines in Excel?
How to print gridlines in Excel? Page Layout > Gridlines > Print

Now print, as usual, using the Print option or Ctrl+P shortcut. All the gridlines will be printed in the hard copy of the spreadsheet.

How to Remove Gridlines in Excel?

By default, gridlines are always visible in the entire workbook. 

You can remove the gridlines from the Excel worksheet using these steps:

  1. Go to the Page Layout tab.
  1. Move to the Gridlines section in the Sheet option group. 
  1. Uncheck the View option within the Gridlines section.
Remove Gridlines in Excel by unchecking the view gridlines option
Remove Gridlines in Excel by unchecking the view gridlines option

You can also remove gridlines using the keyboard shortcut combination ALT + P + VG.

remove gridlines in Excel

Please keep in mind that removing gridlines is specific to each page. This means if you remove gridlines from one worksheet, it would still be visible in other sheets.

You can also make gridlines disappear using the fill colour feature in the Home tab. Just fill any suitable background colour to the entire sheet. This will make all the gridlines in the sheets invisible. Note that this will not deactivate the gridlines. 

Remove gridlines using Fill Colour
Remove gridlines using Fill Colour

Suggested Reads:

How to Make a Pareto Chart Excel Dashboard? 4 Easy Steps

How to Make a Sankey Diagram Excel Dashboard? A Step-by-Step Guide

How to Use the NPER Excel Formula: 2 Easy Examples

FAQs

How To Remove Gridlines From All Worksheets?

You can switch off gridlines from multiple sheets by grouping them all at once. Here’s how: 

Select any one worksheet and hold the Control Key while clicking on the remaining tabs. This will group all the selected worksheets together. 

Uncheck the View Gridlines option in the Page Layout tab. 
This will remove gridlines from the entire workbook. 

After removing the gridlines, remember to ungroup the sheets. To do this, right-click on any of the tabs and select Ungroup from the option. If you forget to ungroup them, any changes made in one sheet will reflect in all other sheets in the group. 

Is it Possible to Show Gridlines in a Specific Area in the Worksheet?

Gridlines cannot be displayed for a specific area in the worksheet. You have to either make it visible for the entire worksheet or hide it for the whole sheet.

But, you can replace it with borders to give a gridlines effect.

Borders, on the other hand, have a lot of editing options and can resemble the actual appearance of gridlines.

Let’s Wrap Up

That’s all folks. In this short guide, we explained how to print gridlines in Excel worksheets. We hope you find this guide useful. Try these techniques in a sample worksheet and let us know what you think. 

Want more high-quality guides for Excel? Check out our free Excel resources centre. 

Click here to access in-depth Excel training courses and master in-demand advanced Excel skills. 


Simon Sez IT has been teaching critical IT software for over ten years. For a low, monthly fee you can get access to 100+ IT training courses by seasoned professionals.

Simon Calder

Chris “Simon” Calder was working as a Project Manager in IT for one of Los Angeles’ most prestigious cultural institutions, LACMA. He taught himself to use Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy then, but he spotted an opportunity and made an online MS Project course - the rest, as they say, is history!

Most Popular Posts

  • Kanban vs Scrum: Project Management Methodologies and Their Differences [2022]
  • How to Insert a Checkbox in Excel? 3 EASY Examples
  • How to Autofit Excel Cells? 3 Best Methods
  • XLOOKUP Google Sheets – 4 Best Alternatives!
  • Dashboards in Excel Using Pivot Tables, Pivot Charts and Slicers
  • Free Microsoft Project Training Course
  • Free Microsoft Access Tutorial for Beginners (3.5 Hours Video)
  • How to Use Blending Mode With Layers in Adobe Photoshop Elements 15

Similar Posts

How to Use Goal Seek in Excel? (3 Simple Examples)

How to Randomize a List in Excel? 2 Different Methods

How to Add a Column in Excel? 3 Effective Ways

The Most Used Microsoft Outlook Shortcuts – Download

What’s New in QuickBooks 2013?

How to Make a Line Graph in Excel? 4 Best Line Graph Examples

Course Categories

  • Adobe
  • Data Analysis
  • QuickBooks
  • Microsoft
  • Web Development
  • Work Productivity

About Us

  • About Us
  • Free Resources
  • Affiliates
  • Become an Instructor

Products

  • Pricing and Plans
  • Business Pricing
  • Government Discounts
  • Non-Profit Discounts

Support

  • FAQ’s
  • Contact Us
  • DVD support

Connect

YoutubeFacebookLinkedIn
© 2023 Simon Sez IT, Inc.
  • Terms
  • Privacy Policy
  • Sitemap
888.817.6665 Monday thru Friday 7:30 a.m. - 5:00 p.m. (ET)