5 Ways to Create Table Using Shortcut in Excel

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:

Sample datasheet for using shortcuts to create a table


Approach

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.

Shortcut to reach Format as Table option

  • 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.

Format as Table options

  • From the New Table Style window, we select Table Element as Whole Table. We set this as the default style and press OK.

New Table Style Window

  • Now we press the shortcut key mentioned above again. The Format as Table window will show different styles. We select the Custom style.

Format as Table custom option

  • The Create Table box will show up. We check on the box My table has headers and press OK.

Create Table Box

  • The dataset will be replaced in a tabular form like the following image.

create table in excel shortcut using Format as Table option


Approach

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.

Shortcut key to access Create Table option

  • The results will look like a table like the following image.

create table using keyboard shortcut


Approach

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.

Shortcut to access Create Table option from Insert tab

  • The dataset will turn into a table. Thus, we have created a table from a dataset using Insert tab feature.

create table using insert tab


Approach

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.

Shortcut key to open 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.

PivotTable from table or range window

  • 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.

PivotTable and its customizable fields


Approach

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.

shortcut to access Power Query

  • 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.

Power Query Editor window

  • When we close the Power Query Editor and keep the changes, a table will automatically be created in our existing sheet.

create table applying power query

  • Another table will be generated in a separate sheet. This will be visible like the following image.

Final result after using Power Query


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.

Inserting a Row in a Table 1

  • Then we press the following formula Ctrl+Shift+Plus(+).
  • A row will be created above the selected cell.

Inserting a Row in a Table 2

  • Now to delete that row, we select cell B10.

Deleting a Row in a Table 1

  • Then we apply the shortcut Ctrl+Minus(-).
  • The row will go away and the result will look like the following image.

Deleting a Row in a Table 2

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.

Inserting a Column in a Table 1

  • Then we press the following formula Ctrl+Shift+Plus(+).
  • A column will be created before the selected cells.

Inserting a Column in a Table 2

  • Now to delete that column, we select cell D8:D10.

Deleting a Column in a Table 1

  • Then we apply the following shortcut Ctrl+Minus(-).
  • The column will go away and the result will look like the following image.

Deleting a Column in a Table 2


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.

Adding a Total Row in a Table 1

  • 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.

Adding a Total Row in a Table 2


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.

Renaming a Table 1

  • The cursor will take us to the Table Name where we write the table name as GroceryItems.

Renaming a Table 2

  • 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.

(Visited 24 times, 1 visits today)

Tags:

Abrar

Abrar

Hello there! I am Mohammad Abrar Uddin, an engineering graduate from BUET. I write articles and blogs related to Excel in this site and hope that the viewers can learn simple to complex solutions of Excel problems easily by reading such articles.

We will be happy to hear your thoughts

Leave a reply

ExcelDen
Logo