skip to Main Content

How to create an Excel table with headers

Excel table is useful as you can organize and analyze data quicker. You can convert a data range into a table with features like filtering and sorting. It is straightforward to create a simple table in Excel by using a shortcut. This tutorial shows you how to create an Excel table with data and headers.

Prepare your data

Before you start, you need to have data entered into your Excel sheet. Even though your data looks like a table, it is not the same as an Excel table. It has more features, allowing you to sort, filter, and format data more efficiently. Look at the guidelines below about preparing your data.

  • Make sure that your data is organized in rows and columns
    • It should contain information about a single piece of data
  • Write a different title for each column
  • The data list should not contain any blank rows or columns
  • Keep your data separated from other tables or data in your Excel sheet
    • Don’t combine multiple data lists next to each other
    • There should be at least one row or column in between
how to make a table in excel

Creating an Excel table with data and headers

If you have a list of data in your spreadsheet, you can convert it into a table with or without headers. Follow the steps below.

  • First, you have to open your Excel spreadsheet with data
  • Select a cell in your data list
    • Or select all the data that you want to include in your table with your mouse cursor
  • Click on Insert at the top > Then click on Table in the ribbon
How to create an Excel table with headers
  • Now a Create Table box opens up
    • Make sure that all the data is selected
  • If you don’t have any headers, you don’t have to do anything
  • If you want to include headers > Select, My table has headers
  • Then click OK to confirm
how to create an excel table with data

Creating an Excel table with headers using a shortcut

You can also create an excel table with data by using a shortcut. This way, you avoid pressing the Insert button and clicking on the Table in the ribbon.

  • First, click on a cell inside your data
  • Then use the keyboard shortcut: CTRL + T

Press the CTRL button and the letter T on your keyboard. It will open the Create Table box in your spreadsheet and automatically select the data. It is much faster to use a keyboard shortcut.

Table with data filters

Following the steps above, you know how to create an Excel table with headers. You may have noticed a few changes once you have converted the data range into this table.

Looking at the pictures below, you can see a difference in its styles. The rows in the table have two different colors; one row is white, and the other is light blue. The headers in the right picture are bold and colored blue. Each header has a drop-down arrow, which you can use to sort and filter.

Before and after table with headers in Excel

Data filters in a table mean you can uncheck some of the data you don’t want to use. This way, you can emphasize the data that is most important to you. Click on one of the drop-down arrows next to a header, such as Color. Then uncheck the color blue > Click OK.

How to use data filters in excel

The table looks different as the products (rows) with blue color are removed. After you use the filter, the table has fewer rows than before. You can also see a filter icon next to the header Color to let you know it is used in this column.

Table with filter

Change the table name

When you first create a table, it will automatically be named. You can find this by clicking on a cell inside your table. Then go to Table Tools > Click on the Design tab. On the left of the ribbon, you can see the Table Name. In our example, it is named Table1.

How to rename a table in excel

You can rename the table to make it easy to recognize and use in formulas. Click on Table1 once to select it. It becomes blue, and you can write the name you want. Then press ENTER on your keyboard or click anywhere else in your sheet. Please make sure to write one word without spaces.

Rename table with headers in Excel

Conclusion

Now you have learned how to format a table with data in Excel. Once your data is ready in your spreadsheet, you can convert it into a table. This table will include headers and features that make it easy for you to analyze the data.

This Post Has 0 Comments

Leave a Reply

Your email address will not be published.