Exceljet

Quick, clean, and to the point

Insert table

Windows shortcut 
CtrlT
Mac shortcut 
T

This shortcut converts a range of related information to an Excel Table. To use this shortcut, just select any cell in a range of related data first.

Related videos

The videos below demonstrate this shortcut.
In this video, we'll look at the options available for Excel Tables, including automatic range expansion and a setting to automatically fill formulas.
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 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 look at how to make a custom table style the default table style in new workbooks.
In this video, we'll look at how to plot over 3000 survey responses to a question in an Excel bar chart.