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.
How to generate an expiration date in the future, how to calculate "days remaining", and how to highlight dates that are expired or expiring soon with conditional formatting.
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 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 use the SUMIFS function with an Excel table, with a side-by-side comparison without a table.