Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Edit / Fill / Series | Excel Discussion (Misc queries) | |||
Excel should not automatically extend series or fill values | Excel Discussion (Misc queries) | |||
Fill Series option grayed out | Excel Discussion (Misc queries) | |||
fill series | Excel Discussion (Misc queries) | |||
fill series grayed out (not available, disactivated) | Excel Discussion (Misc queries) |