How to Remove Gridlines from Table in Excel (2 Examples)

Get FREE Advanced Excel Exercises with Solutions!

There may be some instances where you need to remove gridlines from tables. In Microsoft Excel, you can do this type of task within seconds. This article demonstrates how to remove gridlines from table in Excel with 2 suitable examples. Moreover, this article emphasizes how to remove gridlines of cells outside the table in Excel.


How to Remove Gridlines from Table in Excel: 2 Examples

In many cases, we may need to remove the gridlines from a table in Excel. Removing gridlines can make a table visibly more appealing sometimes.
In the following stages of this article, we will see two methods to remove gridlines from tables in Excel. One example is for general tables and another is for Pivot tables in Excel.
We have used Microsoft Excel 365 version for this article, you can use any other versions according to your convenience.


1. Removing Gridlines from General Excel Table

Let’s assume you have a dataset as shown in the below screenshot in an Excel file. Now, you want to remove the gridlines from this table only. At this point, follow the below steps to do so.

Removing Gridlines From General Excel Table

Steps:

  • First, select the whole table.
  • Then, right-click on it.
  • After that, select Format Cells.

Removing Gridlines From General Excel Table

At this point, a Format Cells window will pop up.

  • Now, go to the Border tab in the Format Cells window.
  • Next, select both Outside and Inside from Presets.
  • Then, go to Color and select the color, White.
  • Consequently, click on OK.

Removing Gridlines From General Excel Table

  • Finally, you will have an output as shown in the below screenshot.

Removing Gridlines From General Excel Table


2. Erasing Gridlines from Pivot Table in Excel

In this example, we have a Pivot Table as shown in the below screenshot. Now, we want to erase or remove the gridlines from the Pivot Table. Follow the below steps to do so.

Erasing Gridlines From Pivot Table in Excel

Steps:

  • At the very beginning, select the Pivot Table.
  • Now, go to the Design tab.
  • Then, click on the More button (a down-arrow-like button) from PivotTable Styles.

Erasing Gridlines From Pivot Table in Excel

  • After that select the Pivot Table style, which has no gridlines. For example, in this case, we have chosen the style Light Gray, Pivot Style Light 15.

Erasing Gridlines From Pivot Table in Excel

  • Finally, you will have an output as shown in the below screenshot.

Erasing Gridlines From Pivot Table in Excel


How to Remove Gridlines of Cells Outside a Table in Excel

Suppose, you have a dataset in an Excel worksheet with gridlines enabled. In some cases, you may need to remove the gridlines for the cells outside of your table. Now, to do so follow the below steps.

Cells Outside

In the first few steps, we will remove the gridlines for the whole worksheet first.

Steps:

  • First, go to the View tab.
  • Then, uncheck the Gridlines box.

Cells Outside

Now, we will add gridlines for the cells in the table only.

  • At this point, select the whole table.
  • Next, go to the Home tab.
  • Then, click on Borders.
  • Consequently, click on All Borders.

Cells Outside

  • Finally, you will have your output as shown in the below screenshot.

How to Remove Gridlines of Cells Outside a Table in Excel


Practice Section

For doing practice by yourself we have provided a Practice section like below on the right side of every worksheet. You can practice removing gridlines from these sections.

Practice Section


Download Practice Workbook

You can download the practice workbook from the link below.


Conclusion

In this article, we see two examples of how to remove gridlines in Excel tables. Also, we see how to remove gridlines from cells outside the table. Last but not least, I hope you found what you were looking for from this article. If you have any queries, please drop a comment below.


Related Articles


<< Go Back to Remove Gridlines | Gridlines | Learn Excel

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.
Sowmik Chowdhury
Sowmik Chowdhury

Sowmik Chowdhuri, with a BSc in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, serves as a crucial Excel & VBA Content Developer at ExcelDemy. His profound passion for research and innovation seamlessly aligns with his unwavering dedication to Excel. In this role, Sowmik not only skillfully addresses challenging issues but also demonstrates enthusiasm and expertise in gracefully navigating intricate situations, highlighting his steadfast commitment to consistently deliver content of exceptional quality and value. Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo