Forum Discussion
Holly Goode
Jun 02, 2017Copper Contributor
Turn off quick analysis?
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 checke...
SergeiBaklan
Jun 02, 2017Diamond Contributor
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-45da-aa82-35a236c5b5db
- Kelli CastagnettaJun 26, 2018Copper Contributor
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.
- SergeiBaklanJun 26, 2018Diamond Contributor
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-be8225b1bb78