There are at least 4 different ways to create Excel Tables and they are…
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 + K
Select a cell in the data range > Press CTRL + T or CTRL K > 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
- Formula Errors in Excel
- Different ways to Create an Excel Table
- Import Facebook Friends list into Excel
- Combine Data from Multiple Worksheets (Tables) using Power Query
- Combine Multiple Worksheets of a Workbook using Power Query in Excel