how to remove table formatting in excel

How To Remove Table Formatting In Excel?

Do you know how to remove table formatting in excel? Excel Table makes working with data a lot easier. But a lot of people find it frustrating about the formatting. So, in today’s tutorial, I will show you how to remove table formatting in excel table. Here, I’ll also show some other customizations you can do to remove the format as a table. Keep on reading further to find out how to remove table formatting in excel.

How To Remove Table Formatting In Excel

To learn how to remove table formatting in excel, follow these steps.

  1. Open the excel sheet containing the table.
  2. Now, select a cell anywhere in the table to activate table tools.
  3. Go to the design tab.
  4. In the table styles section, click on the more option.
  5. In the More menu, click on the Clear option.

Thus, these above steps will remove the Excel Table formatting by keeping the table as it is. In fact, you’ll see the filters that are automatically added.

Note: You can follow the same set of instructions for how to remove table formatting in excel office 365, 2016, and 2007.

Remove Table Formatting In Excel Mac

To learn how to remove table formatting in excel mac, follow these steps.

  1. Open the excel sheet containing the table.
  2. Now, select a cell anywhere in the table to activate table tools.
  3. Go to the home tab.
  4. Now, expand the table styles gallery from the table tools.
  5. Here, select the tables tab.
  6. In the More menu, click on the Clear option.

Keep on reading further to know how to remove formatting as a table in excel.

Remove Table Formatting In Excel Without Losing The Data

The convert to range feature comes in handy as it easily removes the table format style from the table. You can follow these steps to learn how to remove table formatting in excel but keep data.

  1. Open the excel sheet containing the table.
  2. Now, select a cell anywhere in the table to activate table tools.
  3. Go to the design tab.
  4. Here, click on the Convert to Range checkbox.
  5. A Microsoft Excel dialogue box will pop up.
  6. Click on the Yes button.

Now, you’ll notice that the table formatting style has been removed from the original table.

Remove All Table Formatting In Excel

The above two methods do not remove all the formatting in your excel table. To know how to remove all table formatting but retain all formatting in excel, follow these steps.

  1. Open the excel sheet containing the table.
  2. Now, select a cell anywhere in the table.
  3. Then, press Ctrl + A twice to select the whole table including the headers.
  4. Now, go to the home tab.
  5. In the editing group, click the drop-down arrow on clear.
  6. Over here, select clear formats.

Thus, this will clear all formatting including number formats, alignments, font styles, etc.

Shortcut Keys To Remove Table Formatting In Excel

Short-cut keys come in handy when you are in a hurry! Here, I will tell you how to remove table format in excel shortcut keys.

  1. Open the excel sheet containing the table.
  2. Now, select a cell anywhere in the table.
  3. Next, press Alt + H + E + A to clear all table formatting.

Make sure you press these keys one after the other. 

Remove Pivot Table Formatting In Excel

By now you have learned how to remove table formatting in excel 2007. Now, let us understand how to remove pivot table formatting in excel.

  1. Open the excel sheet containing the pivot table.
  2. Now, select a cell anywhere in the pivot table.
  3. Go to the design tab.
  4. In the PivotTable Styles group, click on the more button.
  5. In the More menu, click on the Clear option

FAQ

What Type Of Formatting Can You Do To Modify Your Spreadsheet?

A cell style is a defined set of formatting characteristics, such as fonts and font sizes, number formats, cell borders, and cell shading. To prevent anyone from making changes to specific cells, you can also use a cell style that locks cells. Excel has several predefined cell styles that you can apply.

How Do I Get Rid Of Rich Text Formatting In Excel?

Simply highlight the complete data range that has been imported, then in the “Editing” ribbon select “Clear” and “Clear Formats”. This will remove the rich text formats and restore any data to your default formats.

How Do I Remove Blank Cells From Data Validation List In Excel?

In Excel 2007 and later go to the Home tab and look to the right and click the Find & Select button and then you can see this option. From the window that opens, select the Blanks option and hit OK. Now, right-click a selected cell, which will be a blank one, and click Delete. Hit OK and that’s it!

You can collect more information on such topic here

Conclusion

With the help of my above article, you got to learn how to remove style table formatting in excel. The procedure is pretty simple. You can use the shortcut Alt + H + E + A to clear all table formatting. I hope you won’t face excel table formatting problems in the future. Thus, you can save a lot of time once you understand how to remove table formatting in excel.