Turn off quick analysis?

[Holly Goode]

I'm trying to do a fill series, however when I drag down it only gives me the quick analysis toolbar.  I went to "File", "Options", "Advanced" and the "enable auto complete for cell values" is checked.  What else can I do?

[#2]

Hi Holly,

If you drag down bottom right corner dot by right click mouse it shall give you fill series option (secind picture)

More about fill data is here https://support.office.com/en-us/article/Fill-data-automatically-in-worksheet-cells-74e31bdd-d993-45...

https://support.office.com/en-us/article/Use-AutoFill-and-Flash-Fill-2e79a709-c814-4b27-8bc2-c4dc84d...

[#3]

I am in a bind and I would like some direction on how to turn on my quick analysis icon.  When I select my cells I do not get a quick analysis icon to click on.

[#4]

Please check this https://www.officetooltips.com/excel_2016/tips/how_to_turn_on_off_the_quick_analysis_feature.html and https://support.office.com/en-us/article/analyze-your-data-instantly-9e382e73-7f5e-495a-a8dc-be8225b...

[#5]

I am using 2010 version and the option to turn off/on the quick analysis is not present when i click options

[#6]

Hi Kelli,

It's in 2013 and later. In 2010 you may work through ribbon menus.