Months are not in order- How to place in order?

Hello,

Before I was able to type January in cell A1 then click on the cell and drag down to A12 and it will display every month in the Year in order Jan, Feb, March etc... Now when I type January in cell A1 and drag the 2nd cell will display (see below): How would I FIX this? Thank you for your help.

January
December
November
October
September
August
July
June
May
April
March
February
January
December

Check your Custom List

Options - Advanced - General - Edit Custom List

That's very odd... I am not able to replicate the issue. When I type "January" (without the quotes) into cell A1 and drag it down through A12, I get "January" through "December" (without the quotes).

It looks like your months are going backwards. What exactly is in cell A1? Is it a date, a formula, or just the word January?

Originally Posted by 63falcondude

That's very odd... I am not able to replicate the issue. When I type "January" (without the quotes) into cell A1 and drag it down through A12, I get "January" through "December" (without the quotes).

It looks like your months are going backwards. What exactly is in cell A1? Is it a date, a formula, or just the word January?

Just the word January. The solution from Sandy works only if i'm using sort. What I want to do is simply type the word January in cell A1 and drag it down so it can give me the remaining months in order. Thank you,

Well, the result is not normal. Is this happening in all workbooks?

If you open a new blank workbook and try it there, are you getting the same result?

Originally Posted by thursday140

What I want to do is simply type the word January in cell A1 and drag it down so it can give me the remaining months in order.

It works because Months are defined in Custom List
If there is a list with wrong order you'll get wrong order in the sheet

Select whole sheet, then Clear All, then try again

Originally Posted by sandy666

It works because Months are defined in Custom List
If there is a list with wrong order you'll get wrong order in the sheet

Select whole sheet, then Clear All, then try again

So I reviewed my custom list and I have a few entries. One of them is the months in chronological order then I have another custom list with the months in revers order. I specifically chose the months in chronological order and I followed your steps "new work book", it's still not working. This is what I get when I attempt to use the fill handle after I enter January in cell A1, any ideas? Thanks again-

January
December
November
October
September
August
July
June
May
April

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Workbook should contain your "errors"

So I reviewed my custom list and I have a few entries. One of them is the months in chronological order then I have another custom list with the months in revers order. I specifically chose the months in chronological order and I followed your steps "new work book", it's still not working. This is what I get when I attempt to use the fill handle after I enter January in cell A1, any ideas? Thanks again-

January
December
November
October
September
August
July
June
May
April

Write in A1 January then in A2 February,
select A1 and A2 then drag down till December

or select whole sheet then unhide all rows and columns