Skip to content

How to Remove Excel Table Formatting

This article answers the question – how do you remove the table formatting from an Excel table?

The Default Excel Table Formatting

If you have ever created a table in Excel, you probably noticed that some type of default formatting is applied to that table right away.

Sometimes this is a good thing. Other times it’s a nuisance.

And so the question remains, if you don’t like the default formatting and just want to get rid of it, then how do you do it?

How to Get Rid of the Formatting

Follow the steps below to get rid of the formatting applied to your Excel table due to the default table style or some other table style.

Select a cell in the table.

Click on the Table Design tab in the ribbon. Then click on the down arrow in the Table Styles group of commands.

 

Select the style of None in the upper left-hand corner.

Now the formatting is removed from your table.

From this point, you can add your own formatting or create a custom table style to apply to your table. To learn how to style your table, check out the article below.

How to Create a Custom Table Design

This Post Has One Comment

  1. When I was learning about Excel tables, this was the one thing that really made me more comfortable with Excel tables, now I can’t recommend them enough!

Leave a Reply

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.

Back To Top