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 use the SUMIFS function with an Excel table, with a side-by-side comparison without a table.
This video provides a brief introduction to structured references. Structured references are an easy way to refer to tables in Excel formulas.
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 create an Excel Table from source data on a worksheet.
In this video, we'll look at how to make a custom table style the default table style in new workbooks.