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 |
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 | |
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 |
All times are GMT +1. The time now is 04:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com