Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel will not fill in the months
Appearently Excel refuses to fill in the months. After having typed January
in cell A2, selected cell A2, placed the pointer in the bottom right corner of the cell and then dragging downwards, the rest of the months do NOT fill in. For numbers it DOES work, though. This is part of the online training course at: http://office.microsoft.com/training...RC010437481033 A little help would be appreciated. I am using Excel 2003. Simon Tofte |
#2
|
|||
|
|||
Simon,
Check Tools / Options... "Custom Lists" tab, and make sure that you have a list "January, February,..." If you don't have it, you will need to create it. HTH, Bernie MS Excel MVP "Swoosh" wrote in message ... Appearently Excel refuses to fill in the months. After having typed January in cell A2, selected cell A2, placed the pointer in the bottom right corner of the cell and then dragging downwards, the rest of the months do NOT fill in. For numbers it DOES work, though. This is part of the online training course at: http://office.microsoft.com/training...RC010437481033 A little help would be appreciated. I am using Excel 2003. Simon Tofte |
#3
|
|||
|
|||
This is one way to do it.
Say you want to write Jan to Dec in Cells A1 to A12. Enter the following formulas in A1 to A12 1 =+A1+31 =+A2+31 =+A3+31 =+A4+31 =+A5+31 =+A6+31 =+A7+31 =+A8+31 =+A9+31 =+A10+31 =+A11+31 Now set the format of these cells to Month. To do this Select A1 to A12.Format CellsCustom, In the "Type:" box type MMMM and click OK. With this you have only changed the format, the actual data is not the name of the months. To convert this into text copy : paste it in note pad or word and then copy: paste it back to excel. The easiest way : You write all the 12 Months once. :) ;) Thanks Karthik Bhat Bangalore |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel won't fill formulas | Excel Worksheet Functions | |||
fill out a scanned form in excel spreadsheet ? | Excel Discussion (Misc queries) | |||
autoshape fill problems in Excel 2003 | Excel Discussion (Misc queries) | |||
How do I fill an Excel template from a file | Excel Worksheet Functions | |||
Identifying the Active Fill Color | Excel Discussion (Misc queries) |