Exceljet

Quick, clean, and to the point

Insert table

Windows shortcut 
T
Mac shortcut 
T

This shortcut converts a range to an Excel Table. To use this shortcut, first select the range of data you want to convert. 

Note: in Mac Excel 365, you can also use Control + T to convert a range to a table.

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 apply a table style. Table styles quickly change the look and feel of an Excel Table.
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 lesson we look at 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 build a simple dynamic chart in Excel. A dynamic chart automatically responds to changes in data.

Download 200+ Excel Shortcuts

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