Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

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

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.


Download Practice Workbook

You can download the practice workbook from the link below.


2 Examples to Remove Gridlines from Table in Excel

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

Read More: How to Remove Gridlines in Excel for Specific Cells (2 Quick Methods)


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

Read More: How to Remove Gridlines in Excel Graph (5 Easy Methods)


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


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. Also, if you want to read more articles like this, you can visit our website ExcelDemy.


Related Articles

Sowmik Chowdhury

Sowmik Chowdhury

Hello! Welcome to my Profile. I , Sowmik Chowdhury, graduated from the Bangladesh University of Engineering and Technology from the Department of Naval Architecture and Marine Engineering. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this..

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo