What is Format as table in excel

What is Format as table in excel?

In Excel format as table is a function that quickly formats your worksheet data into a predefined table. Excel provides several predefined table styles which you can use on your worksheet. However, when you apply the predefined table style formula for the selected data, some formatting change applies to your worksheet. If you don't like to work with your data in a table but keep the table style formatting, you can convert the table back to a regular range.

Please see the below image for better understanding.

Home>Format As Table

format as table

Select the data at worksheet and choose an option.

How do format as tables work in Excel

To remove Format as table go to the Design tab Tools group, and click Convert to Range. Or, right-click anywhere within the table, and select Table > Convert to Range.