Autofill without option

Occasional Contributor

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

10 Replies

@Nils_Thorsen 

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?

@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. 

@Nils_Thorsen 

Try turning off Quick Analysis:

Select File > Options.

Clear the 'Show Quick Analysis options on selection' check box.

S0855.png

PS The AutoFill options menu should pop up if you drag the fill handle with the right mouse button.

Thank's - that took away the rapid analyses, but now I don't get any option.

@Nils_Thorsen 

Do you drag the fill handle with the right mouse button?

Yes. Now I get the option menu up, but all choices except from copy are unaccessable.

@Nils_Thorsen 

Even the Fill Formatting Only and Fill Without Formatting options?

Yes, Those opions is also in grey.

@Nils_Thorsen 

Strange. I'm afraid I have no explanation or solution for that, sorry.

Anyhow, thank you for your help so far, Hans!