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.
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.
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: 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.
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 existing data.
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.
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 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.
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.
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.
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.
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.
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
- How to Create a Table in Excel with Multiple Columns
- How to Create a Table with Subcategories in Excel
<< Go Back to Make a Table | Excel Table | Learn Excel
Get FREE Advanced Excel Exercises with Solutions!