Thread: extending dates
View Single Post
  #2   Report Post  
Jim Rech
 
Posts: n/a
Default

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
|