Windows Mac
CtrlQ

About This Shortcut 

This shortcut opens the Quick Analysis menu for the current selection, the same menu you get by clicking the Quick Analysis button at the bottom right of a selected range. Select a range that contains data first. The menu has tabs for Formatting, Charts, Totals, Tables, and Sparklines, and Excel previews each option as you hover over it.

Quick Analysis was added in Excel 2013. Excel for Mac does not have Quick Analysis, so there is no Mac equivalent.

Related videos

Excel Ways to create a chart

Ways to create a chart

In this video, we'll look at several different ways you can create charts in Excel. In later versions of Excel, starting with Excel 2013, the best option for creating a new chart is usually the Recommended Charts button on the Insert tab of the ribbon. Just select some data then go to Insert > …
Dave Bruns Profile Picture

AuthorMicrosoft Most Valuable Professional Award

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.