Ctrl+Q: Quick Analysis Options

The shortcut Ctrl+Q is to display the "Quick Analysis" options for the selected cells with data.

Step 1: Click any cell in the data range (e.g., A1)

Step 2: Press and hold the "Ctrl" key, then press the letter "Q" from the keyboard;

Step 3: The Quick Analysis tool bar will appear including formatting, charts, totals, tables, and sparklines.

Check More Excel Shortcuts

Leave a Reply