How to Remove Gridlines in Excel

Helpful when you are making spreadsheets

Gridlines in Microsoft Excel make it easier to view your data. However, you can disable these gridlines if you don’t want to use them while making spreadsheets. There are multiple ways to remove gridlines in Excel.

You can hide them, fill them with white to make them disappear into the page, or create a template that uses no gridlines.

Quickly Remove Gridlines in Excel

Microsoft Excel has an option that defines whether or not gridlines appear in your spreadsheets. You can disable this option to hide gridlines in your Excel spreadsheets.

This method works on a per-worksheet basis, which means you’ll have to perform these steps for each worksheet to remove gridlines.

Immediately,Excel will hideall gridlines in your current worksheet. If you’d like to bring gridlines back, enable theViewbox in theGridlinessection.

Change the Gridline Color to Remove Gridlines in Excel

Another way to remove gridlines from an Excel worksheet is by changing the gridlines’ color. By default, Excel uses the grey color for gridlines. If you change this to white, your gridlines will automatically disappear.

Again, this option works on a per-worksheet basis, which means you’ll have to follow these steps for each of your worksheets to remove gridlines.

All gridlines should now be hidden in your current worksheet.

Apply a Fill Color to Remove Gridlines in Excel

You can fill the white color in your worksheet to make gridlines disappear. Later, if you change your mind, you can remove the fill color to get gridlines back.

To bring gridlines back, chooseNo Fillfrom the bucket icon menu.

Remove Gridlines From Specific Rows or Columns in Excel

If you’re looking to remove gridlines fromspecific rows or columns, use Excel’s Border option. This option allows you to remove gridlines from the selected area in your spreadsheet.

Back on the worksheet screen, you’ll find gridlines from your selected area are now gone.

Always Keep Gridlines Removed in Excel

If you want to make your future spreadsheets without gridlines, createan Excel templatethat uses no gridlines by default. Then, any spreadsheets that you base on this template will have no gridlines.

To make this template:

By default, gridlines aren’t printed when youprint an Excel spreadsheet. If you’d like to print gridlines, enable an option in the Excel app.

Getting Rid of Gridlines From Excel Spreadsheets

While gridlines make arranging data in your Excel spreadsheets easier, you don’t always have to use them. For the occasions when you don’t need gridlines, the methods above should help you remove gridlines from your Excel spreadsheets.

Mahesh has been obsessed with technology since he got his first gadget a decade or so ago. Over the last few years, he’s written a number of tech articles on various online publications including but not limited to MakeTechEasier and Android AppStorm.Read Mahesh’s Full Bio

Welcome to Help Desk Geek- a blog full of tech tips from trusted tech experts. We have thousands of articles and guides to help you troubleshoot any issue. Our articles have been read over 150 million times since we launched in 2008.

HomeAbout UsEditorial StandardsContact UsTerms of Use

Copyright © 2008-2024 Help Desk Geek.com, LLC All Rights Reserved