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

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

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

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

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