Nov 01 2021 06:40 AM
When I use autofill function I get no option how to autofill. Instead I get Speed analyses.
How can I get back my autofill option
Nov 01 2021 07:02 AM
You should get the Quick Analysis button when you select a range, not when you drag the fill handle. Are you sure that you dragged the fill handle?
Nov 01 2021 07:38 AM
@Hans Vogelaar Yes I am pretty sure of that. I have used the autofill function for many years, but somehow the option was replace by this rapid analyses.
Nov 01 2021 08:36 AM
Try turning off Quick Analysis:
Select File > Options.
Clear the 'Show Quick Analysis options on selection' check box.
PS The AutoFill options menu should pop up if you drag the fill handle with the right mouse button.
Nov 01 2021 09:17 AM
Nov 01 2021 11:54 AM
Do you drag the fill handle with the right mouse button?
Nov 01 2021 12:28 PM
Nov 01 2021 12:37 PM
Even the Fill Formatting Only and Fill Without Formatting options?
Nov 01 2021 01:27 PM
Strange. I'm afraid I have no explanation or solution for that, sorry.