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 Series
Newbie
Is there an action to automatically fill a series of dates? Row A1 01/01/2006 Row B1 Blank Row C1 01/02/2006 Row D1 Blank Row E1 01/03/2006 etc. Thanks for any help |
#2
|
|||
|
|||
Fill Series
Simply select A1 to D1,
Right *OR* left click on the fill handle of the selection, And drag right. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "WmBrown" wrote in message ... Newbie Is there an action to automatically fill a series of dates? Row A1 01/01/2006 Row B1 Blank Row C1 01/02/2006 Row D1 Blank Row E1 01/03/2006 etc. Thanks for any help |
#3
|
|||
|
|||
Fill Series
Fill in the first cell. Then select the first TWO cells (1/1/06 and blank).
Grap the fill handle at the extreme lower right of the selected cells and drag until you've reached the ending cell (the tip will show you the value of the latest cell you've covered). "WmBrown" wrote: Newbie Is there an action to automatically fill a series of dates? Row A1 01/01/2006 Row B1 Blank Row C1 01/02/2006 Row D1 Blank Row E1 01/03/2006 etc. Thanks for any help |
#4
|
|||
|
|||
Fill Series
WmBrown wrote: Sorry The entries are in a column. A1 01/01/2006 A2 Blank A3 01/02/2006 A4 Blank A5 01/02/2006 etc. Will that make your answer change? Newbie Is there an action to automatically fill a series of dates? Row A1 01/01/2006 Row B1 Blank Row C1 01/02/2006 Row D1 Blank Row E1 01/03/2006 etc. Thanks for any help |
#5
|
|||
|
|||
Fill Series
No !
Just select A1 to A4, And drag down to where ever. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "WmBrown" wrote in message ... WmBrown wrote: Sorry The entries are in a column. A1 01/01/2006 A2 Blank A3 01/02/2006 A4 Blank A5 01/02/2006 etc. Will that make your answer change? Newbie Is there an action to automatically fill a series of dates? Row A1 01/01/2006 Row B1 Blank Row C1 01/02/2006 Row D1 Blank Row E1 01/03/2006 etc. Thanks for any help |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
fill series is incorrectly copying result | Roxy | Worksheet Functions | 2 | August 26th, 2005 03:50 PM |
fill a series of dates excluding holidays | gsh20 | Worksheet Functions | 1 | August 25th, 2005 12:33 AM |
Fill series but a little different | kingjeremy | General Discussion | 5 | August 20th, 2005 01:18 PM |
series graph -- one series being added to another series | rich zielinski via OfficeKB.com | Charts and Charting | 3 | March 30th, 2005 06:23 PM |
Changing a series' Name, X- and Y-values by using its series number | L Mehl | Charts and Charting | 4 | February 4th, 2004 01:32 PM |