About This Shortcut

This shortcut will a create a chart using data in current range on a separate worksheet. This is a very good way to quickly visualize data to check for patterns, outliers, or inconsistencies.

About This Shortcut

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.