Create Table in Excel Using Shortcut (8 Methods)

Get FREE Advanced Excel Exercises with Solutions!

A 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


Create Table in Excel: 8 Shortcut Methods

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: Create a Table in Excel Based on Cell Value 


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 existing data.

TABLE

Read More: How to Create a Table Without Data in Excel


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 Create a Table with Merged Cells 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

Read More: How to Add New Row Automatically in an Excel Table


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


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

Read More: How to Make a Table in Excel with Lines


Download Practice Workbook


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.


Related Articles


<< Go Back to Make a Table | Excel Table | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Prantick Bala
Prantick Bala

PRANTICK BALA is a marine engineer who loves exploring Excel and VBA programming. Programming, to him, is a time-saving tool for efficiently managing data, files, and internet tasks. He is proficient in Rhino3D, Maxsurf, C++, MS Office, AutoCAD, Excel, and VBA and goes beyond the basics. Armed with a B.Sc in Naval Architecture & Marine Engineering from BUET, he has transitioned into the role of a content developer. Beyond his work, find him immersed in books, exploring new... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo