Insert Table Shortcuts

Learn how to use the insert table shortcuts in Excel to speed up this frequently used task through examples.

When you are working with an Excel Table, you should know how to perform the task faster. Today’s quick guide will be about the most used table-related shortcuts.

How to insert a Table in Excel using shortcuts

There are two quick and easy ways to insert an Excel Table using existing data in a spreadsheet.

Using the create table shortcut

The Ctrl + T shortcut will convert a range to an Excel Table.

If you are not familiar with Excel shortcuts, do the following steps.

Select the range (or a cell in a range) that you want to convert. Next, go to the Insert tab in the Ribbon and click on the Table icon.

select a cell in a range

After clicking the icon, Excel will ask where the data is for your table. If your table has a header, leave the default settings to remain.

excel will ask where is the data

Click OK to insert a table. As you see, the conversion was successful.

converted range to table using insert table shortcut

The Home Tab

Here is the shortcut to open the Format as Table menu:

Alt, H, T

You will see various table styles. Next, navigate between the preformatted tables using the arrow keys. Finally, press Enter to insert a new table.

alt h t insert table shortcut

Don’t forget: comma sign (,) means that you need to press and release keys in order.

Additional resources:

Istvan Vozar

Istvan is the co-founder of Visual Analytics. He helps people reach the top in Excel.