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 conditional formatting to shade every other row in a table. This is sometimes called "zebra striping".
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.
In this video, we'll look at how to create a list of random text with the RANDARRAY function and INDEX function.
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.
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.

Download 200+ Excel Shortcuts

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