Exceljet

Quick, clean, and to the point

Insert table

Windows shortcut 
T
Mac shortcut 
T

This shortcut converts a range to an Excel Table. To use this shortcut, first select the range of data you want to convert. 

Note: in Mac Excel 365, you can also use Control + T to convert a range to a table.

Related videos

The videos below demonstrate this shortcut.
In this video we look at how to simulate a random drawing to pick winners in a contest with Excel using the RAND and RANK functions together.
When plotting unsummarized data, the chart filter may not be convenient. In this video, we'll look at how to filter larger sets of data in an Excel Table with filters applied.
In this video, we'll look at the options available for Excel Tables, including automatic range expansion and a setting to automatically fill formulas.
In this video, we'll look at how to make an area chart. Like line charts, area charts are a good way to show trends over time.
In this video, we'll set up XLOOKUP to return multiple values in a dynamic array, by providing a range of lookup values instead of a single lookup value.

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.