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.
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.
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.
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.
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.
It will create a table with your data.
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.
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.
It will create a pivot table with your data.
Now, you can drag the column headers in different areas of the PivotTable Fields to get different calculations in a tabular form.
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.
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.
It will create a table with your data.
Similar Readings
- How to Edit a Pivot Table in Excel (5 Methods)
- Update Pivot Table Range (5 Suitable Methods)
- How to Group Columns in Excel Pivot Table (2 Methods)
- Types of Tables in Excel: A Complete Overview
- How to Export HTML Table with Formatting to Excel
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.
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.
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.
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.
To Delete a Row
➤ Select any cell from the row and press,
CTRL+MINUS Key (-)
It will delete the selected row from your table.
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.
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.
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.
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.
Now, you can give a suitable name to your table.
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.