"5 Easy Steps to Remove Gridlines in Excel without Losing Your Mind"

Christopher Jun 16, 2026

How to Remove Gridlines in Excel: A Step-by-Step Guide

How to Quickly Remove Gridlines in Excel?
How to Quickly Remove Gridlines in Excel?

Excel's gridlines can be useful for creating a visual representation of data, but they can also clutter the screen and make it difficult to read and analyze your data. Removing gridlines can help you focus on the data itself and make it easier to create professional-looking reports and presentations. In this article, we'll show you how to remove gridlines in Excel using various methods.

Remove Gridlines in Excel
Remove Gridlines in Excel

Method 1: Disable Gridlines for the Entire Spreadsheet

To remove gridlines for the entire spreadsheet, you can follow these simple steps:

How to Remove Gridlines in Excel
How to Remove Gridlines in Excel
  • Open your Excel spreadsheet.
  • Go to the View tab in the ribbon.
  • Click on Gridlines in the View group.
  • Select the option to Gridlines Off or Don't Show Gridlines.

This method removes gridlines for the entire spreadsheet, but it may not be suitable if you only want to remove gridlines for a specific range of cells.

Instantly Remove Gridlines in Excel ๐Ÿ‘Š
Instantly Remove Gridlines in Excel ๐Ÿ‘Š

Method 2: Remove Gridlines for a Specific Range of Cells

If you only want to remove gridlines for a specific range of cells, you can use the following method:

  • Select the range of cells for which you want to remove gridlines.
  • Go to the Home tab in the ribbon.
  • Click on the Border button in the Styles group.
  • Select No Border from the dropdown menu.
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

This method removes gridlines for the selected range of cells without affecting the rest of the spreadsheet.

Method 3: Use VBA Macros to Remove Gridlines

If you're comfortable with VBA macros, you can use the following code to remove gridlines for the entire spreadsheet:

Remove Gridlines in Excel
Remove Gridlines in Excel

Sub RemoveGridlines()
    ActiveSheet.DisplayGridlines = False
End Sub

To use this macro, follow these steps:

  • Press Alt + F11 to open the Visual Basic Editor.
  • Insert a new module by clicking Insert > Module.
  • Paste the code into the module.
  • Press F5 to run the macro.
How to remove gridlines in Excel (The Easy Way)
How to remove gridlines in Excel (The Easy Way)
a laptop computer sitting on top of a desk with the words remove gridlines from specific cells
a laptop computer sitting on top of a desk with the words remove gridlines from specific cells
How to show gridlines in Excel; hide (remove) lines
How to show gridlines in Excel; hide (remove) lines
How To Remove Gridlines From Specific Cells In Excel
How To Remove Gridlines From Specific Cells In Excel
How to remove gridlines in Excel! Save this so you wonโ€™t forget it๐ŸŒŸ
How to remove gridlines in Excel! Save this so you wonโ€™t forget it๐ŸŒŸ
how to remove gridlines from specific cells in excel
how to remove gridlines from specific cells in excel
How to Print With Gridlines in Excel in 60 Seconds | Envato Tuts+
How to Print With Gridlines in Excel in 60 Seconds | Envato Tuts+
Change the Gridline Color in Excel Spreadsheets - 2 Ways!
Change the Gridline Color in Excel Spreadsheets - 2 Ways!
How to Remove Gridlines in Excel Pivot Table (with Easy Steps)
How to Remove Gridlines in Excel Pivot Table (with Easy Steps)
How to remove gridlines from an Excel chart
How to remove gridlines from an Excel chart
How to easily remove gridlines in Excel when printing
How to easily remove gridlines in Excel when printing
the text how to remove gridlines from specific cells in excel with an arrow pointing up
the text how to remove gridlines from specific cells in excel with an arrow pointing up
How to Remove Gridlines from Specific or selected Cells in Excel
How to Remove Gridlines from Specific or selected Cells in Excel
Most Excel users don't know this hidden trick!
Most Excel users don't know this hidden trick!
How to Remove Print Lines in Excel (4 Easy Ways)
How to Remove Print Lines in Excel (4 Easy Ways)
How to Remove Grid Lines in Excel | Techwalla
How to Remove Grid Lines in Excel | Techwalla
Remove Gridlines in Excel
Remove Gridlines in Excel
Why Do Gridlines Disappear in Excel? (5 Reasons with Solutions) - ExcelDemy
Why Do Gridlines Disappear in Excel? (5 Reasons with Solutions) - ExcelDemy
How to remove specific gridlines in excel chart
How to remove specific gridlines in excel chart
How to creat Blank Spreadsheet in excel  remove gridlines, Headings
How to creat Blank Spreadsheet in excel remove gridlines, Headings

This method is useful if you want to remove gridlines programmatically or if you want to automate the process for multiple spreadsheets.

Method 4: Use a Shortcut Key to Remove Gridlines

Excel provides a shortcut key to quickly remove gridlines:

  • Press Ctrl + 0 to toggle gridlines on and off.

This shortcut key is useful if you want to quickly switch between gridlines on and off without having to go to the View tab.

Conclusion

Removing gridlines in Excel is a simple process that can help you create a more visually appealing and professional-looking spreadsheet. In this article, we've shown you four different methods to remove gridlines, including disabling gridlines for the entire spreadsheet, removing gridlines for a specific range of cells, using VBA macros, and using a shortcut key. Choose the method that works best for you and your spreadsheet needs.