Different ways to Create an Excel Table

There are at least 4 different ways to create Excel Tables and they are…

Using Shortcuts

CTRL + T is the most used Keyboard Shortcut for creating Excel Tables. But there is one more shortcut for the same and that is CTRL +L

Select a cell in the data range > Press CTRL + T or CTRL L > Create Table dialog will be activated. Click OK and the data range will be converted into an Excel Table.

Using the Table button in Insert Tab

Select a cell in the data range > go to the Insert Tab of the Excel ribbon and Click on Table to activate the Create Table dialog.

Format as Table option in the Home tab

Select a cell in the data range > Click on Format as Table option in the Home the Excel ribbon > Select the preferred format to activate the Create Table dialog.

Using the Quick Analysis Tool

Select the entire data range which is to be converted into an Excel Table > Quick Analysis button will appear in the bottom right corner of the selected data > Select Tables > Click on the first option Table


Read more on Excel Tables

How to connect Excel Tables (How to build relationship in Excel)