Excel Table is a very useful tool with many features like to ‘Sort’ and ‘Filters’, which makes it easy to view and organize data. To create table in excel, it makes it easier and quicker for you to visually group and analyze your data.

Just as you have data in a tabular format, you can convert your data into a table in excel. When you create or convert data into a table, you have access to a variety of Excel table features that will make work a lot easier for you, and you can also print out the table.

When working with lists and data, I will advise you work in an Excel table format to enable you access the various features in Excel Table.

This Excel-ur-data will teach you three different ways to create a table in Excel.

1. Create Table in Excel using Keyboard Shortcut

To convert a data range to an Excel Table,

  • Select the entire data in the worksheet or any cell within the data
  • Press Ctrl + T  

It should be noted that:

When you use the shortcut method, it is the default Table Style that will be applied. You will have to go to the ‘Table Style’ options to change it and apply a specific style that you want.

2. Using the INSERT Tab

a. Select the entire data or any cell within the data

b. Go to the INSERT tab and click on the ‘Table’ command

c. In the ‘Create Table’ dialog box, check the ‘My table has headers’ box if you have column headings. If you do not have headers, do not worry about it. Excel will automatically give the headers generic names like Column 1, Column 2, etc.

d. Confirm that the selected range is correct.

e. Click Ok.

Now, you will have your table created. But it is the default Table Style that will be applied. So, if you want to change the table style, then you go ahead with the following steps:

f. Click on any cell in the table and go to ‘Design’ tab

g. Go to ‘Table Styles’ option to select from the various table styles and the colour that you want.

h. Click on any of the box to apply the table style that you want.

3. Create Table in Excel via the HOME Tab

a. Select any cell within the data or select the entire data in the worksheet

b. Go to HOME tab and select ‘Format as Table’

c. Select a table style from the pre-defined styles

d. In the ‘Format As Table’ dialog box, check to confirm that the right range is selected. Mark the checkbox if the table has headers (Column Title) and if it does not, Excel will automatically insert the headers and give generic names like Column 1, Column 2, and so on.

e. Click ok.

Now, you will have a data table that looks like this one below:

Note the following changes that has been made to the data:

  • The header has been shaded to a different colour.
  • There are now banded rows in the dataset.
  • There are arrows pointing down at the right side of the headers which means the Data Filter have been enabled.

Another point to note is that when data has been converted to an excel table, only the design changes. All the data remain unchanged.

Convert an Excel Table back to Tabular Data

If you have converted your data to a table format and you want to switch back to the regular tabular range:

  • Right-click anywhere in the table range
  • Go to Table and select ‘Convert to Range’

Again, it should be noted that when an Excel table has been converted to a range, it will still retain the formatting. However, the properties of an Excel table will no longer be available.