How To Create A Table In Excel

Get your data in order and looking sharp with tables

How To Calculate IRR In Excel

Last Updated on

Microsoft Excel is a great tool to use to create awesome tables to show off your data and results, but not everyone knows how to pull one together. Here is our guide on how you can create tables in Excel. Check out the steps below and try following them yourself.

How To Create A Table In Microsoft Excel



Gather Your Data

The first thing you need to do is to make sure that you have all the data you need and want to display in a table.

Then, you need to start organizing it into groups. This is so that you don’t end up overlapping different types of data in the same column.

When you have decided on your columns, you can start to fill in the columns with headings on your Excel spreadsheet.

Next, fill in each row with your data until you have a table of results.



Select The Data For Your Table

This step is about selecting the data you want to convert into a table image.

Then you can easily copy and paste your table onto other software. For example, PowerPoint or Word.

To select the data you want to use into your table, select a cell in that range. Then click and drag your cursor until you have highlighted every cell of information you want to use.

Some people, they highlight the whole table while others go column by column or row by row. Ultimately, how much data you want to select is down to you.



Format As Table

Now that your data is selected, you need to locate the Format as Table button.

This can be found on your Home tab on the above ribbon menu.

In the Styles section, the Format as Table button is seen between the Conditional Formatting button and the Cell Styles button.

Once you have found the Format as Table button, select it and then choose the table style you prefer.

You will have a range of options to choose from so pick the one that best suits your needs.



Edit And Complete Your Table

Once you have selected the style you prefer, you can select the ‘OK’ button and your table should appear on your spreadsheet.

All of your data and headings should be in the correct place but you can make changes even after your table has been generated.

Just double click on your table to change the text in one of the cells and then click away when you are done editing – it’s easy.




Change table style

If you have changed your mind about the style of the table, then you can change that as well.

Click on your table to highlight it, head to the Design tab on the top ribbon menu, then find the Quick Styles button.

This can be found on the furthest right of your options. Click it and the same styles menu as before will drop down.

Select a new style, click ‘OK’ to save it and then see how it looks. Keep going until you have found the perfect style.

And then your table is complete.


And that is how you can turn your data and results from just isolated cells on an Excel spreadsheet into a complete table. Using just a few clicks of your mouse, you can swap out the ugly Excel format for a table in Excel that you can proudly use and present to others. It’s very easy to do as long as you follow the above instructions.