Forum Discussion
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 checked. What else can I do?
5 Replies
- I am using 2010 version and the option to turn off/on the quick analysis is not present when i click options
Hi Kelli,
It's in 2013 and later. In 2010 you may work through ribbon menus.
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
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.
