Create Table in Excel Using Shortcut (8 Methods)

Get FREE Advanced Excel Exercises with Solutions!

Table in Excel allows you to perform different calculations and organize your data more easily. You can create a table in Excel in different ways. In this article I’ll show you 8 shortcut methods to create a table in Excel.

Suppose, you have the following dataset of different items with their prices. Now, I’ll show you the shortcuts to create a table with this dataset.

DATASET


Download Practice Workbook


8 Shortcut Methods to Create Table in Excel

1. Create Table with Keyboard Shortcut Key

The easiest way to create a table in Excel is using the keyboard shortcut key for creating a table. First,

➤ Select your Entire dataset and press,

CTRL+T

As a result, the Create Table window will be opened.

TABLE

Now,

➤ Check on the box My table has headers if your dataset has a header row. Otherwise, leave this box unchecked.

The dataset I’ve used to write this article has a header row. So, I’ve checked the box My table has headers.

After that,

➤ Click on OK.

As a result, the table will be created.

TABLE

Read more: How to Insert Table in Excel


2. Create Table from Insert Tab

You can also use a shortcut to create a table from the Insert tab. First,

➤ Select your data and press,

ALT+N+T

It will open the Create Table window from the Insert tab.

create table in excel shortcut

As a result, the Create Table window will be opened. Now,

➤ Check on the box My table has headers if your dataset has a header row. Otherwise, leave this box unchecked.

After that,

➤ Press OK.

create table in excel shortcut

It will create a table with your data.

TABLE


3. Shortcut Key to Create Pivot Table

With a keyboard shortcut key, you can also create a Pivot Table. Though it’s not a conventional table, it’s worth knowing the shortcut.

To create a pivot table,

➤ Select your entire data and press,

ALT+N+V+T

It will open the PivotTable from table or range window.

PIVOT TABLE

Now,

➤ Select Existing worksheet.

You can select a New worksheet if you want to create the pivot table in a new sheet.

After that,

➤ Select the cell where you want to create the pivot table in the Location box and press OK.

PIVOT TABLE

It will create a pivot table with your data.

PIVOT TABLE

Now, you can drag the column headers in different areas of the PivotTable Fields to get different calculations in a tabular form.

PIVOT TABLE

Read more: How to Insert A Pivot Table in Excel


4. Shortcut to Create Table from Home Tab

You can also use a shortcut from the Home tab to create a table in Excel. First,

➤ Select your Entire dataset and press,

ALT+H+T

It will open the option Format as Table from the Home tab.

➤ Select a suitable style from this option.

create table in excel shortcut

As a result, the Create Table window will be opened. Now,

➤ Check on the box My table has headers if your dataset has a header row. Otherwise, leave this box unchecked.

After that,

➤ Press OK.

create table in excel shortcut

It will create a table with your data.

TABLE


Similar Readings


5. Shortcut to Create Table in Power Query

You can also use a shortcut to create a table in Power Query. First,

➤ Select your Entire dataset and press,

ALT+A+P+T

As a result, the Create Table window will be opened. Now,

➤ Check on the box My table has headers if your dataset has a header row. Leave the box unchecked otherwise.

After that,

➤ Press OK.

create table in excel shortcut

Now, you will see a table will be created in the Power Query Editor window. You can now transform your data from this table in the Power Query Editor window.

POWER QUERY

If you close the Power Query Editor, you will see a table has also been created in your Excel sheet. By this way, you can create a table from Data tab using the keyboard shortcut.

TABLE


6. Insert or Delete Rows and Columns with Shortcut

Inserting and deleting rows or columns are the primary aspects of a table, you can insert or delete rows and columns in your table by using shortcuts.

Let’s see how to do that.

To Insert a Row

➤ Select any cell from the row before which you want to insert a row and press,

CTRL+SHIFT+PLUS Key (+)

It will add a row to your table.

ADD ROW

To Delete a Row

➤ Select any cell from the row and press,

CTRL+MINUS Key (-)

It will delete the selected row from your table.

DELETE ROW

Insert a Column

➤ Select more than one cell from the column before which you want to insert a column and press,

CTRL+SHIFT+PLUS Key (+)

It will add a column to your table.

ADD COLUMN

Delete a Column

➤ Select more than one cell from the column and press,

CTRL+MINUS Key (-)

It will delete the selected column from your table.

create table in excel shortcut


7. Add a Total Row in the Table

Generating a Total Row can be useful after creating a conventional table. You can also use a shortcut to add a Total Row in your Excel table.

➤ Select any cell from your table and press,

CTRL+SHIFT+T

It will add a Total Row to your table.

create table in excel shortcut

You can find more ways to add a Total Row in Excel from here.


8. Shortcut to Rename a Table

With a shortcut, you can rename the table you have created. It might be useful while initiating the table creation journey.

➤ Select any cell from your table and press,

ALT+J+A

It will take the cursor in the Table Name box.

create table in excel shortcut

Now, you can give a suitable name to your table.

create table in excel shortcut


Conclusion

I hope now you know how you can create a table in Excel using a shortcut. If you have any confusion please feel free to leave a comment.


Further Readings

Prantick Bala

Prantick Bala

Hi, I'm Prantick Bala, currently working and doing research on Microsoft Excel in Softeko.com. I have completed BSc in Naval Architecture and Marine Engineering From Bangladesh University of Engineering and Technology (BUET). Currently I am in the last semester of my MBA at Institute of Business Administration (IBA), Dhaka University (DU). I'm always eager to learn through experience and have a deep interest in solving problem to get optimum solution.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo