Share via

Excel Quick Analysis button??

Anonymous
2015-01-29T17:49:03+00:00

I have Microsoft 2013 Student Edition, when I am using Excel spreadsheet once I select my cells the quick analysis button appears in the bottom left corner of selection but the button only show options for filling. QUESTION is why doesn't my quick analysis tool show the following information:

  • Format
  • Charts
  • Totals
  • Tables
  • Sparklines

how do I update or add these features to the quick analysis tool in Excel?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

Anonymous
2015-02-01T21:06:02+00:00

You have just done a Copy and the Copy Option tool gets displayed.

Lets get the Quick Analysis tool to show

Make a worksheet as shown in screen capture; Seelct the entire table

Note the icon for the Quick ****;ysis tool; click it - second screen capture

best wishes

Was this answer helpful?

5 people found this answer helpful.
0 comments No comments

8 additional answers

Sort by: Most helpful
  1. Anonymous
    2015-02-01T16:16:58+00:00

    hi,

    I have emailed you a screenshot of the issue I am having.

    Thanks for helping me with this issue.

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2015-02-01T16:04:13+00:00

    I have emailed you a sample file.

    Thanks for helping me with this issue.

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2015-01-29T19:44:59+00:00

    What do you mean by "options for filing"

    This is what the tool shows

    Visit my website, get my email address, and send me a sample file

    best wishes

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2015-01-29T19:42:20+00:00

    This is strange. There is no option for filling when I click the Quick Analysis. Can you post a screenshot of your data selected and the QA dialog open?

    Was this answer helpful?

    0 comments No comments