Ctrl+Q: Quick Analysis Options - ExcelNotes

HomeExcel ShortcutsCtrl+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

Share Tweet Pin it

Leave a Reply Cancel Reply

Search

You may like:

• What are the Names of the Keyboard … 66 Comments
• How to Retrieve Bing Webmaster Verification Code 15 Comments
• How to Extract Text before a Special … 8 Comments
• How to Move X Axis Labels from … 8 Comments
• How to Change the Spacing between Letters … 8 Comments
• How to Add or Reply Comments in … 7 Comments
• How to Convert Word From an Earlier … 7 Comments
• How to Show Emails Received Today or … 7 Comments