Home |
Search |
Today's Posts |
#1
|
|||
|
|||
extending dates
When I have a date in a cell (say,Jan01) and use the fill handle to drag it
down, by default, it seems to fill with days. If I click the tag next to the list, I can check 'fill months' to get the list I want. Can I make 'fill months' the default? Thanks Sanford |
#2
|
|||
|
|||
Excel assumes an increment of 1 (1 day in this case) if you don't give an
indication of what you want. To do that for months you'd have to enter 1/1 in a cell and 2/1 in the next (month/day). Then select both cells and then drag the fill handle. Another way to do what you're doing presently that might be slightly easier is to drag the fill handle using the right mouse button, and then select the interval from the popup menu. -- Jim Rech Excel MVP "Sanford Lefkowitz" wrote in message ... | When I have a date in a cell (say,Jan01) and use the fill handle to drag it | down, by default, it seems to fill with days. If I click the tag next to the | list, I can check 'fill months' to get the list I want. | | Can I make 'fill months' the default? | | Thanks | Sanford | |
#3
|
|||
|
|||
I'm don't think you can change this.
But you could use a formula and drag that: =date(year(a1),month(a1)+1,1) Sanford Lefkowitz wrote: When I have a date in a cell (say,Jan01) and use the fill handle to drag it down, by default, it seems to fill with days. If I click the tag next to the list, I can check 'fill months' to get the list I want. Can I make 'fill months' the default? Thanks Sanford -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How sort dates just by day/month and NOT year if all 3 given in ce | Excel Worksheet Functions | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
due dates | New Users to Excel | |||
I get wrong dates when i paste from a different sheet into a new s | Excel Discussion (Misc queries) | |||
micosoft excel dates entered but changed to sequencial numbers ho. | Excel Worksheet Functions |