Autofill (for days and months) not functioning in excel 2013

Hi guys
I am dealing a very weird issue these days. I am using excel 2013 in my laptop (windows 8.1) after having upgraded excel 2007. Everything works fine during my daily tasks. Especially autofill which I use quite often works perfect.

At the same time I upgraded my girlfriends laptop (Windows 7) with the office 2013 (office 2007 was the older version) and somewhere there begun some isues. Autofill doesn't. Especially with months or days. I enter the value "Monday", I drag down (of course using the black filled cross down right of the cell) the cursor and all the cells get the value Monday. Even if enter the value Tuesday in the second cell and then try to autofill (having marked before both these two cells) I get the same results. Monday, Tuesday, Monday, Tuesday.

I tried to test the autofill with numbers. If i write only the one number (for instance the value "1") and then autofill, this doesnt work. It gives me the value "1" in all the cells. But if I enter the value "2" in the second cell, the autofill works fine (marking these 2 cells and then autofill).

I don't really know whats happening. We make some online courses using exactly the same excel exercise files. In my laptop everything works perfect. Any ideas

I really appreciate your help

Regards
greywarden

In Excel Options > Click Advanced > Under the General heading is a button called "Edit Custom Lists"

Check in here, if the Monday, Tuesday .... list is in there?

Thanx a lot Foundy. The lists where there, but in a different language (probably previous versions of office were installed in a different language). I added the lists and everything is fine.except for one thing. If I insert the value "jan 2012" and auto fill the following cells, it gives me jan 2013 Jan 2014 etc. The problem is that in case I want to fill months , I simply can't. Because the pop up option doesn't give me that option. It gives me only : copy cells, fill series, fill formatting only, flash fill

Thanx a lot

Sent from my HTC One using Tapatalk

Originally Posted by foundy

In Excel Options > Click Advanced > Under the General heading is a button called "Edit Custom Lists"

Check in here, if the Monday, Tuesday .... list is in there?

thanks you!