Two Methods for Creating Tables in Microsoft Excel


There are many benefits to working with data in tables, including things like sorting, filtering, formatting, and system stability. But how do we convert data from a normal range to a table? Expert author Erin Olsen demonstrates two easy methods to create tables in Microsoft Excel in her Microsoft Excel РTables Deep Dive training course. 

Most commonly accessible way to create a table:

Once you’ve got your data organized (see below for tutorial video), make sure that your curser is somewhere inside the data range you want to convert. From the home tab, go into the styles group and choose Format as Table. Once you select a table from the gallery, you’ll have to verify your data range and whether your table has a header row, and when all is correct click ok.


What if you don’t have a header row?

Cue method 2. In the insert table, choose the Table option. You won’t get any formatting options with this method, it uses a default table style. All you have to do is make sure the data range is accurate, uncheck the box asking if you have a header row, and click ok. Because you don’t have a header row, the table needs to create one, so it generates a table with generic names such as Column 1, Column 2, etc.


 Things to remember:

It is important to prepare your data ahead of time, making it a simple, clean process. It’s also important to make sure your curser is somewhere inside the data range. Plus, you DO NOT need to select the entire range, just as long as your curser is inside the range then Excel will select the entire table for you.

Learn how to prepare your data in the training video below. Plus, watch Erin teach the entire process of creating tables. Both videos are taken from our Microsoft Excel – Tables Deep Dive training course, available as a digital download or as part of our monthly subscription service.

Preparing Data for Tables:

Creating Tables:



Save $50 when you sign up for an annual Learning Library account Learn More