Can I turn off Quick Analysis icon in XL2013 & QAT size (2 questions in one)

[Johnny C]

Hi
I've just started using Xl2013. Whenever I select a range it gives an icon on the lower right to access quick analysis functions. Most of the tables I select have a total right where this icon appears so I can't see the total changing for example if I paste new formulas.

Can I turn it off? It's getting on my nerves.

Also, can I reduce the size of the icons on the QAT? I have a standard QAT that fitted fine on Excel 2010 but now the button icons are bigger it won't fit on one line and I can't see most of them without selecting the drop down (which defeats the point of the QAT being quick)

Cheers

 

[healey21]

You can turn the Quick Analysis via File Tab and Options in the General untick "Show Quick Analysis Options on Selection"

 

[Johnny C]

Great, thanks