How to Create Tables in Excel (With Example)

The following step-by-step example shows how to create and format tables in Excel.

Step 1: Enter the Data

First, let’s enter the following data about various basketball teams:

Step 2: Create the Table

To turn this data into a table, first highlight all of the cells in the range A1:C11.

Then click the Insert tab along the top ribbon and then click the Table icon:

create table in Excel

In the new window that appears, verify that the range for the table is correct and check the box next to My table has headers, then click OK:

The following table will automatically be created:

Step 3: Format the Table

To modify the appearance of the table, simply click on any value in the table. Then click on the Table Design tab along the top ribbon.

This will give you a variety of options to change the appearance of the table.

For our example, we’ll uncheck the box next to Filter Button to remove the dropdown arrows in the header of our table and we’ll choose the yellow table style:

The style of our table will automatically be updated:

Feel free to play around with the design options in the Table Design tab to make the table appear however you’d like.

Additional Resources

The following tutorials explain how to perform other common tasks in Excel:

How to Create a Contingency Table in Excel
How to Group by Month and Year in Pivot Table in Excel

Leave a Reply

Your email address will not be published.