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 look at how to simulate a random drawing to pick winners in a contest with Excel, using the RAND and RANK functions together.
In this video, we'll look at how to apply a table style. Table styles quickly change the look and feel of an Excel Table.
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 the options available for Excel Tables, including automatic range expansion and a setting to automatically fill formulas.
In this video, we look at a step by step approach to randomly assign people to groups with teams using formulas. Along the way, we use three functions (RAND, RANK, and CEILING), helper columns, and nesting. We verify results with the COUNTIF function.

Download 200+ Excel Shortcuts

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