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 how to create an Excel Table from source data on a worksheet.
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.
In this video, we'll look at how to create a Pareto chart. A Pareto chart plots the distribution of data in columns by frequency, sorted in descending order.
Pivot tables are very easy to create, but they still present challenges. In this video, we look at how to identify and fix 10 common pivot table problems.
In this video we'll look at how to create a dynamic named range with a Table. This is the simplest way to create a dynamic named range in Excel.

Download 200+ Excel Shortcuts

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