extending dates

S

Sanford Lefkowitz

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
 
J

Jim Rech

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
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
|
 
D

Dave Peterson

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)
 
Top