Remove Gridlines from Only Part of a Worksheet in Excel

Add to Favorites

How to remove gridlines from a part of a worksheet in Excel instead of the entire worksheet or workbook.

This is important when you want the gridlines to be everywhere on the worksheet except for designated areas and it is really easy to do with a quick formatting trick in Excel.

Here is a worksheet with gridlines removed from only part of the worksheet:


To achieve this result, simply follow these steps:

Select the cells where you dont want any gridlines to appear:


Right-click and select the Format Cells option:


Go to the Fill tab and look under where it says Background Color and select the white tile:


Then, hit the OK button and you will have a section of the spreadsheet that no longer has gridlines!



To do this in Excel 2003, follow these steps:

Select the desired cells and go to Format > Cells... > Patterns > Color and then check the white box and hit OK.


I hope this tutorial was helpful! 

You can download the Excel file used in this tutorial either below or from the menu on the right.

Downloadable Files: Excel File

Similar Content on TeachExcel
Print Only Specific Parts of a Worksheet in Excel
Tutorial: In Excel you can select parts of a worksheet to print while ignoring all of the other data...
Get the Name of a Worksheet in Macros VBA in Excel
Tutorial: How to get the name of a worksheet in Excel using VBA and Macros and also how to store tha...
Get the Decimal Part of a Number in Excel
Tutorial: How to get the decimal part of a number without any rounding in Excel. This tip allows you...
Remove All Filtering From a Worksheet in Excel
Macro: This Excel macro removes all filtering from a worksheet in Excel. This allows you to compl...
Quickly Move Cells Around a worksheet in Excel Cut/Paste Trick
Tutorial: Moving Cells around a worksheet in Excel is fast an easy. Below I have a table of forename...
Change the Name of a Chart in Excel
Tutorial: How to change the name of a chart in Excel. This allows you to use a more intuitive char...