How to Create Tables in Excel

Learn how to use Excel tables to quickly and simply evaluate your data. Learn how to construct, sort, and filter tables, among other things.

Create a Table:-

On the Insert tab, in the Tables group, click Table (or simply press Ctrl + T).

Excel automatically selects the data for you. Check 'My table has headers' and click on OK.

Result. For you, Excel makes a nicely designed table. You may still think of this data range as being standard, but many effective functions are now accessible with the touch of a button.

You can change a Table Format.

Select any cell in the table.

Select Design.

In the Table Styles gallery, select the table style you want to apply. Note: To remove a table style, select Design. In the Table Styles gallery, select More, and then select Clear or Clear Table.