Fill Series

[WmBrown]

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

 

[RagDyeR]

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!
=====================================================

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

 

[bpeltzer]

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]

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?

 

[RagDyeR]

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:
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?