Excel’s Table feature enables us to do various computations and arrange our data more efficiently. There are several methods to construct tables in Excel. In this post, I’ll demonstrate 8 shortcut ways to create a table in Excel.
📁 Download Practice Workbook
Download the practice workbook below.
Learn to Create Table in Excel Using Shortcut with These 5 Suitable Approaches
To clarify things easily, we will consider a dataset where different items, their categories, and price per kilogram are given. We will use these data to construct a table in Excel using only shortcut keys. The dataset is shown as follows:
1. Using Format as Table Option
The Format as Table option from the Home tab can be utilized to create a table. In this approach, we will look at the shortcut key for that option. The steps of this process are as follows:
⬇️⬇️ STEPS ⬇️⬇️
- In the beginning, we select our dataset and press the shortcut key Alt+H+T.
- This will open the Format as Table option from the Home tab and present different styles of tables that we can choose from.
- We select New Table Style.
- From the New Table Style window, we select Table Element as Whole Table. We set this as the default style and press OK.
- Now we press the shortcut key mentioned above again. The Format as Table window will show different styles. We select the Custom style.
- The Create Table box will show up. We check on the box My table has headers and press OK.
- The dataset will be replaced in a tabular form like the following image.
2. Applying Keyboard Shortcut Key
This is the simplest way to create a table using shortcut key in Excel. The steps for this approach are as follows:
⬇️⬇️ STEPS ⬇️⬇️
- At first, we select the data range which we want to present as a tabular form.
- After that, we press the shortcut key Ctrl+T.
- A Create Table window will pop up. If our table has headers, we select the option My table has headers and then press OK.
- The results will look like a table like the following image.
3. Utilizing Insert Tab
The Create Table window that we can find after going to the Insert tab has a shortcut key that we can utilize to create a table. The steps for this process are as follows:
⬇️⬇️ STEPS ⬇️⬇️
- At first, we select the dataset with which we want to make a table. In this case, we select the cell range B5:D14.
- Next, we press the shortcut key Alt+N+T on the keyboard.
- This shortcut key will enable us to open the Create Table window from the Insert tab.
- In the window, we check My table has headers if our table has headers and then we press OK.
- The dataset will turn into a table. Thus, we have created a table from a dataset using Insert tab feature.
4. Implementing Pivot Table
We can create a Pivot Table by using a certain shortcut key as well. In this approach, we will look at that approach. The steps for this approach are as follows:
⬇️⬇️ STEPS ⬇️⬇️
- Similar to the other approaches, we select the whole dataset first.
- Then, we press the shortcut key Alt+N+V+T for a Pivot Table.
- This will make a box named PivotTable from table or range appear. The table/range will be automatically selected. We click on Existing Worksheet and in the Location box, we select the cell B18 and press OK.
- A Pivot Table will be generated but to view data, we need to check the boxes on the right. We check the boxes with the name Item and Price Per Kilogram.
- The Pivot Table will look like the following image with the sum of the prices.
5. Applying Power Query
We can use the Power Query feature to create a table as well. To do that, we can use shortcut keys by following these steps.
⬇️⬇️ STEPS ⬇️⬇️
- We select the dataset and press the following shortcut keys, Alt+A+P+T.
- The Create Table box will pop up. Then we check on the box My table has headers and press OK.
- The Power Query Editor will open and a table will be generated in the Editor. We can edit and manipulate our data in this editor.
- When we close the Power Query Editor and keep the changes, a table will automatically be created in our existing sheet.
- Another table will be generated in a separate sheet. This will be visible like the following image.
How to Insert or Delete Rows and Columns in a Table in Excel
We can insert or delete rows and columns in a table with the help of shortcut keys. For a clear understanding, we will add and remove a row in a table first. Then we will do the same for columns.
1. Insert and Delete a row
To insert or delete a row, we need to follow these steps.
⬇️⬇️ STEPS ⬇️⬇️
- At first, we select a cell above which we aim to create a row. In this case, we select cell B10.
- Then we press the following formula Ctrl+Shift+Plus(+).
- A row will be created above the selected cell.
- Now to delete that row, we select cell B10.
- Then we apply the shortcut Ctrl+Minus(-).
- The row will go away and the result will look like the following image.
2. Insert and Delete a Column
To insert or delete a column, we need to follow these steps.
⬇️⬇️ STEPS ⬇️⬇️
- At first, we select a few cells in that column before which we aim to insert a new column. In this case, we select the cells D8:D10.
- Then we press the following formula Ctrl+Shift+Plus(+).
- A column will be created before the selected cells.
- Now to delete that column, we select cell D8:D10.
- Then we apply the following shortcut Ctrl+Minus(-).
- The column will go away and the result will look like the following image.
How to Add Total Row in a Table in Excel
A Total Row calculates the total sum of the values present in a table. We can add a Total Row in a table by following these steps.
⬇️⬇️ STEPS ⬇️⬇️
- At first, we select any cell of the table.
- Then we press the following shortcut keys Ctrl+Shift+T.
- As a result, a Total Row will be added to the existing table that will give a sum total of the price of the items.
How to Rename a Table in Excel
We can also use shortcut keys to rename a table in Excel. To do so, we need to follow these steps.
⬇️⬇️ STEPS ⬇️⬇️
- At first, we select any cell from the table.
- Then we press the shortcut keys mentioned below Alt+J+T+A.
- The cursor will take us to the Table Name where we write the table name as GroceryItems.
- Therefore, in this way, we can rename a table.
📄 Important Notes
🖊️ In the Pivot Table fields that come out when we save the table, we can drag the header fields between areas to change the orientation of the output table that we want to get.
🖊️ If we don’t check the option My table has headers then the table will auto-generate some headers with the name column.
📝 Takeaways from This Article
You have taken the following summed-up inputs from the article:
📌 We can use general shortcut keys as well as different commands under different tabs such as Home tab, Insert tab and their individual shortcut keys to create a table in Excel.
📌 Additionally, we can also create tables using Pivot Table and Power Query shortcut in Excel.
📌 Finally, we can manipulate different data within a table in Excel by various ways having shortcut keys.
Conclusion
To conclude, shortcut keys are quite useful while we do our work in Excel. I hope this article has helped you to understand the basic shortcut keys that we can use to create a table in Excel. If you have any queries, reach out to us by leaving a comment below. Follow our page ExcelDen for more informative articles related to Excel.