Different ways to Create an Excel Table

Different Methods to create Excel Tables

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 + 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

Read more on Excel Tables


Please follow and like us:

Leave a Reply

Your email address will not be published.Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.