How to turn your Data into a Table in Excel

Here is a quick tip on how to turn your Data into a table in Excel.

There are many table styles available or you have the choice to create a custom style.

First you need to highlight the group of data you want to put in a table.

Then on the ‘Home’ tab under ‘Styles’ choose ‘Format as Table’

How to turn your Data into a Table in Excel

Here you can choose the format of your table

In the ‘Create Table’ box that pops up you can choose whether your table has headers or not.

How to turn your Data into a Table in Excel

You can then add elements to your table and adjust it under the ‘Table tools Design’ tab.

How to turn your Data into a Table in Excel

If you would like to learn more about Excel and its tools, take a look at our Excel Training Courses

Share on LinkedInShare on FacebookTweet about this on TwitterShare on Google+Email this to someone