Fill Handle Changed - What's Going On ??

[Zigax]

Hello,

At the beginning of each year I use Excel to make my schedule book pages. I have created them the same way for over 10 years. Now, suddenly, the Fill Handle is not behaving as it did previously. I currently use Excel 2010.

To be clear, I actually made the pages for 2016 this morning, and then I got the idea to work ahead and make my calendar pages for future years. I got 2017 done successfully, but when I was trying to make the pages for 2018, the Fill handle, instead of putting down the 365 days of the year, it just repeated the first week which I had typed in.

Here is how I have created, in the past, 52 schedule pages, each of with Saturday at the top, and Friday at the bottom:

In cell A3 I type numeric date 1/2, and in cell B3 I type Sat (this is the first Saturday for 2016). I then skip 5 cells, and type, in cell A9 1/3, and in cell B9 I type Sun. I type in the other days of that week, skipping 5 cells between each day. Friday ends up being row 39, so 1/8 goes into cell A39, and Fri goes into B39.

The cells are skipped to make space on the page, each page being an 8.5 X 11 size page. With the top and bottom page margins set to zero, and row height is set at 18, and with two cells above Sat, and two cells below Fri, that makes up one single page.

Having typed up one full page (the first week) I used to be able to highlight from cell A1 down to cell B41, grab the fill handle, and draaaaaaag it down around to row 2,130. This would produce numeric dates in column A from 1/2 of 2016 to 1/6 of 2017. In column B, the fill handle would produce Sat through Fri, over and over for each week. Excel would put 4 spaces between each Fri and Sat, and 5 spaces between the other days of the week.

My Fill handle no longer does this!

Instead, after I type in the first week, when I grab it and pull down, it re-produces the first week, over and over.

Does anyone know what setting I need to change to make Excel behave as it used to? I've spent a considerable amount of time trying to figure it out. I've experimented with Fill series, Series, and Fill Days, and autofill.

[Zigax]

Problem solved!


When I typed in the first week of 2018, I was inconsistent. I had some dates as 2018, and a few other days typed in as 2016. If you just type in 1/6 and hit enter, Excel puts the date in as 1/6/2016! Therefore, when I grabbed the Fill handle, it repeated instead of putting in the subsequent days, because it wasn't dealing with a recognizable series.

Oy!