If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Fill handle increments year instead of day
I'm trying to use the fill handle to fill a series of dates one day at a
time. The cells are formatted as dates, and the first few are filled like this: May-17-2010 May-18-2010 May-19-2010 If I select the first cell and drag the fill handle down, I get: May-17-2010 May-17-2011 May-17-2012 If I select the first three cells and drag the fill handle down, I get: May-17-2010 May-18-2010 May-19-2010 May-17-2011 May-18-2011 May-19-2011 What I want is to get this: May-17-2010 May-18-2010 May-19-2010 May-20-2010 May-21-2010 May-22-2010 I've tried dragging the fill handle with the right mouse button, but the menu options that appear for "Fill Days", "Fill Weekdays", "Fill Months", and "Fill Years" are all grayed out. This is Excel 2010, in case that matters. How can I make this work? Thanks, Richard Koett. |
Thread Tools | |
Display Modes | |
|
|