Skip to content

Create a Table in Excel

One of the most powerful features of an Excel Workbook is the Excel table.

Now I’m not talking about a dinner table or coffee table, although I am fond of these. What I am referring to is a brilliant digital device within the Excel spreadsheet that just so happens to be called a “table.”

What is An Excel Table?

An Excel table is simply a defined range within your spreadsheet.

Ok…what does that mean?

It means that these are a series of rows and columns that you identify with a name. What’s more, these cells are granted an assortment of features unique to an Excel table (more on these later).

How to Create An Excel Table

To create a table in Excel, follow the steps below.

Step 1 – Select the Table Range

The first thing you need to do when creating a table is to select the range that you want to turn into an Excel table.

The selected range does not have to contain data. You can select a blank range if you want to.

Step 2 – Insert the Table

With your table range selected, click on the Insert tab in the Excel Ribbon, and click on the Table button.

You can also use the keyboard shortcut CTRL + T instead of the Ribbon.

The Create Table dialog box will appear.

Step 3 – Decide If Your Table Has Headers

In the Create Table dialog box, you have the option to check the box next to “My table has headers.”

If the range you selected for your table contains table headings, leave this box checked.

If you want Excel to create table headings for you, leave the box unchecked.

After you have made your selection, click Ok.

Step 4 – Format the Table

At this point, Excel should have created your table. It probably looks something like this.

If you would like to change the appearance of the table, the best thing to do is customize the table style.

You can read all about how to do this in our post, How to Format Excel Tables.

And that’s how to create a table in Microsoft Excel. If you enjoyed this article and want to learn more about the use of Excel tables, be sure to leave a comment below.

Your questions, comments, and concerns are always welcome, and we would love to know what you would like to learn so we can continue to write helpful articles!

As always, thanks so much for reading!

This Post Has One Comment

  1. Let me be the first to say that I have underestimated the greatness of using tables in Excel. If you haven’t tried it out, you should give it a shot!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top