Autofill button

Copper Contributor

I am making a chart where the first column on the left are the first Tuesdays' in every week of the year.  I typed in 1/7/20, 1/14/20 and 1/21/20.  When I highlight those cells, a Quick Analysis tool appears instead of an Auto Fill button.  How do I fix this?

1 Reply

Hi @Janekay 

 

If  you highlight the first 3 cells then drag down the fill handle.  It will give you each Tuesday.  Also an autofill button may appear,  if it doesn't then try using the RIGHT mouse button when dragging rather than the usual left button.

 

In my version of O365, I don't get the Autofill icon but the newer versions have fixed this issue.