How To Remove Table Format In Excel

This article will tell you how to remove the table format in excel but reserve the table features so that you can still use the table features without the table style that was applied to it before.

1. How To Remove Table Format In Excel And Reserve Table Features.

  1. Select any cell in the excel table.
  2. Then click the Table Tools —> Table Design tab on the excel top area.
  3. Go to the Table Styles group, and scroll the table styles list.
  4. Click to select the None table style.
  5. Then you will find the excel table format has been removed.
  6. Or you can click the More icon on the Table Styles scroll bar bottom.
  7. Then click the Clear text in the drop-down table styles list bottom left corner to remove the table format.

2. How To Remove Customized Table Format In Excel.

  1. The above steps can clear the predefined table format, but they can not remove your customized table style format.
  2. If you want to remove the customized table style format which is added by yourself, you can follow the below steps.
  3. Select one table cell, then press Ctrl + A to select all the table cells.
  4. Click the Home tab, then in the Editing group, click the Clear —> Clear Formats menu item.
  5. Then it will remove all the table style formats including both the predefined and customized from the selected excel table.


  1. Excel Convert Table To Range Example And Vice Versa.

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.