Forum Discussion

Afsana1998's avatar
Afsana1998
Copper Contributor
Jun 07, 2020

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 using Fill Handle?

1 Reply

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum 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