G Guest Jun 15, 2005 #1 I want to be able to input any month (in the form Jan, Feb etc) and have Excel automatically fill the rest of the months in.
I want to be able to input any month (in the form Jan, Feb etc) and have Excel automatically fill the rest of the months in.
B Bernie Deitrick Jun 15, 2005 #2 Type Jan into a cell, select the cell, click the fill handle and pull down. Excel has a list months that it will then fill into the cells. If you want to type Jan into cell A1, and have the rest of the cells automatically filled, then in cell A2, use the formula =TEXT(DATE(2005,MONTH(DATEVALUE(A1&" 1, 2005"))+1,1),"mmm") and copy down as far as you need the list. HTH, Bernie MS Excel MVP
Type Jan into a cell, select the cell, click the fill handle and pull down. Excel has a list months that it will then fill into the cells. If you want to type Jan into cell A1, and have the rest of the cells automatically filled, then in cell A2, use the formula =TEXT(DATE(2005,MONTH(DATEVALUE(A1&" 1, 2005"))+1,1),"mmm") and copy down as far as you need the list. HTH, Bernie MS Excel MVP
G Guest Jun 15, 2005 #3 You'll have to enter two sequential months and it will work. Select the cells, click on the "square" in the lower RH corner and drag down. Does that do what you want?
You'll have to enter two sequential months and it will work. Select the cells, click on the "square" in the lower RH corner and drag down. Does that do what you want?
