Share via

Excel Date Autofill problems

Anonymous
2020-04-27T18:23:09+00:00

Hi all :)

I have a problem with autofilling dates in Excel (Office 365). It is not possible to autofill dates. This is the same for days, months or years. I do not even come to point to choose what to autofill ( drag down while holding right-click).

My cells are in the right format for my region. I can change them to short or long format without a problem but the autofill won't work.

For your information my display language (Windows + Excel) is english. Region settings for Germany.

Maybe someone had the same issue or can help me.

Best regards

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

23 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-05-01T19:23:33+00:00

    Okay,  I did this. After opening a new workbook or working with an old one, there is no file generated in the empty folder.

    0 comments
  2. Anonymous
    2020-05-07T22:20:40+00:00

    Have you installed the M365 Office suite?

    I think M365 is broken with Fill as the fill handle doesn't show anymore and is replaced with the Table formatter handle

    8 people found this answer helpful.
    0 comments
  3. Anonymous
    2020-05-23T17:33:47+00:00

    Yes, it is the 365 Suite. Btw loggin in with another account doesn't make a difference.

    Also a reinstallation with Microsofts SARA did not help.

    3 people found this answer helpful.
    0 comments