About This Shortcut

This shortcut converts a range to an Excel Table.

To use this shortcut, first grab the range of data you want to convert.

The videos below demonstrate this shortcut.

Video thumbnail for 10 pivot table problems and easy fixes

Video thumbnail for How to randomly assign people to teams

Video thumbnail for How to filter chart data with a table filter

Video thumbnail for Excel Table Options

Video thumbnail for How to set a default custom table style

Video thumbnail for How to generate random text values