# How to Remove Table Formatting In Excel

To remove table [**formatting in Excel**](https://www.youtube.com/watch?v=4MJKJNqwdis), you can convert the table back to a range. Here's how you can do it:

1. Click anywhere inside the table that you want to remove formatting from.
    
2. Go to the "Table Design" tab in the Excel ribbon. This tab appears when you're inside a table.
    
3. In the "Table Styles" group, click on the "Convert to Range" option. Excel will prompt you with a confirmation message.
    
4. Click "Yes" to confirm that you want to convert the table to a normal range.
    
5. The table formatting will be removed, and the data will still be intact in the worksheet.
    

By converting the table to a range, you'll essentially be removing the table formatting while keeping the data as is.