Forum Discussion
Afsana1998
Jun 07, 2020Copper Contributor
Fill Handle
Hello there, When I want to use a fill handle and drag down from Monday in order to write all days, excel copies Monday in all cells. How can I make it to get Tuesday, Wednesday and other days by us...
Riny_van_Eekelen
Jun 07, 2020Platinum Contributor
Afsana1998 I suspect that your Excel does not have a custom list set up that recognises "Mon" as an element in a list Mon, Tue, Wed etc.
If you are on Windows, go Sort
and check the custom lists available. Create your own if you don't find the one you need.
If you are on a Mac, you'll find Custom Lists under Excel, Preferences..., Formulas and Lists