How to Remove Gridlines in Excel Pivot Table (with Easy Steps)

Get FREE Advanced Excel Exercises with Solutions!

Looking for ways to know how to remove gridlines in an Excel pivot table? Sometimes, we want to remove gridlines in the Excel pivot table to see the pivot table clearly. Here, you will find a step-by-step explanation of how to remove gridlines in the Excel pivot table.


How to Remove Gridlines in Excel Pivot Table: with Easy Steps

Here, we will show you how to remove gridlines in Excel pivot table by going through 2 steps: Making a Pivot Table and Using Customized Pivot Tables. Follow the steps given below to do it on your own.


Step-01: Making a Pivot Table

Here, we have a dataset containing the Product Name, Sales and Profit of a shop. Now, we will make a pivot table from this dataset to remove gridlines in the Excel pivot table.

Making a Pivot Table to Remove Gridlines in Excel Pivot Table

Go through the steps given below to do it yourself.

  • Firstly, select cell range B4:D10.
  • Then, go to the Insert tab >> click on PivotTable >> select From Table/Range.

  • Now, the PivotTable from table or range box will open.
  • After that, you will see that the range has already been selected.
  • Next, select New Worksheet.
  • Then, press OK.

Making a Pivot Table to Remove Gridlines in Excel Pivot Table

  • Now, a new Worksheet and PivotTable Fields box will open.
  • After that, drag the Product Name field in the Axis box and the Sales and Profit fields in the Values box.

  • Finally, you will get your desired Pivot Table.

Make a Pivot Table to Remove Gridlines in Excel Pivot Table


Step-02: Using Customized Pivot Tables to Remove Gridlines

Now, we will remove gridlines in the Excel pivot table by using a Customized Pivot Table. Follow the steps given below to do it on your own.

  • In the beginning, select the pivot table from cell range A3:C10.
  • After that, go to the Design tab >> click on Quick Styles.

Using Customized Pivot Tables to Remove Gridlines

  • Then, select any pivot table from your preferences that has no gridlines. Here, we will select Light Blue, Pivot Style Light 16 pivot table.

  • Finally, you will be able to remove gridlines in the Excel pivot table by using a Customized Pivot Table.

Using Customized Pivot Tables to Remove Gridlines


How to Remove Gridlines in Excel Pivot Chart

We can also remove gridlines in Excel Pivot Chart by going through two different ways. Follow the steps given below to do it on your own.


Method 1: Using Add Chart Element Feature to Remove Gridlines in Excel Pivot Chart

In the first method, we will show you how to remove gridlines in an Excel pivot chart using the Add Chart Element feature.


Step-01: Making a Pivot Chart

Firstly, we will make a pivot chart from the given dataset containing the Product Name, Sales, and Profit of a shop to remove gridlines.

Using Add Chart Element Feature to Remove Gridlines in Excel Pivot Chart

Go through the steps given below to do it yourself.

  • Firstly, select cell range B4:D10.
  • Then, go to the Insert tab >> click on PivotChart >> select PivotChart.

  • Now, the Create PivotChart box will open.
  • After that, you will see that the range has already been selected.
  • Next, select New Worksheet.
  • Then, press OK.

Using Add Chart Element Feature to Remove Gridlines in Excel Pivot Chart

  • Now, a new Worksheet and PivotChart Fields box will open.
  • After that, drag the Product Name field in the Axis box and the Sales and Profit fields in the Values box.

  • Finally, you will get your desired Pivot Chart and its corresponding Pivot Table.

Using Add Chart Element Feature to Remove Gridlines in Excel Pivot Chart


Step-02: Using Add Chart Element Feature

Now, we will remove gridlines in Excel pivot chart by using the Add Chart Element Feature. Follow the steps given below to do it on your own.

  • In the beginning, select the Pivot Chart.
  • Then, go to the Design tab >> click on Add Chart Element.

  • After that, click on Gridlines.
  • Now, unselect your selected gridline. Here, we will unselect the Primary Major Horizontal gridline.

Using Add Chart Element Feature to Remove Gridlines in Excel Pivot Chart

  • Finally, you will be able to remove gridlines in Excel pivot chart by using the Add Chart Element feature.


Method 2: Selecting Gridlines Then Pressing Delete Button

We can also remove gridlines in Excel Pivot Chart by first selecting the gridlines and then pressing the Delete button.

Go through the steps given below to do it yourself.

Steps:

  • Firstly, create a pivot chart from the given Dataset by going through the steps given in Method 1.

Selecting Gridlines Then Pressing Delete Button

  • Then, select the Pivot Chart.
  • Next, click on the Gridlines to select them.

  • After that, press the Delete button on your keyboard.
  • Finally, you will be able to remove gridlines in the Excel pivot chart.

Selecting Gridlines Then Pressing Delete Button


Download Practice Workbook


Conclusion

So, in this article, you will find a step-by-step way to remove gridlines in Excel pivot table. Use any of these ways to accomplish the result in this regard. Hope you find this article helpful and informative. Feel free to comment if something seems difficult to understand. Let us know any other approaches that we might have missed here. Thank you!


What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Arin Islam
Arin Islam

Anowara Islam Arin, a graduate of Civil Engineering from Khulna University of Engineering & Technology, Bangladesh, serves as a technical content creator in the ExcelDemy project. Possessing a passion for innovation and critical thinking, she actively embraces challenges. Beyond her engineering background, Arin exhibits a keen interest in Excel, having authored numerous articles on Excel & VBA-related issues to simplify the experience for users facing obstacles in Excel. Besides, she is also interested in Advanced Excel,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo