Excel : fill by example
 

Hi

Is there a similar function to the Lotus 1-2-3 "fill by example". I've
tried the Fill option under Edit, however can't seem to get it to work with
dates. For example if I enter in 3 dates in a column (see example below), I
would then like the next 20 or so rows for that column to be filled in with
dates incrementing by one week.

e.g

31.10.2005
07.11.2005
14.11.2005

thanks in advance.

Steven

Excel : fill by example
 

If those are real dates and just formatted that way, you can select the top two
cells. Click on the autofill button and drag down. Excel will see that you
want to increment by 7.

Debra Dalgleish describes it with pictures:
http://contextures.com/xlDataEntry01.html#Mouse

You could also put the date in the first cell (say A1)
then put this in A2: =a1+7
and drag down.



Steven wrote:

Hi

Is there a similar function to the Lotus 1-2-3 "fill by example". I've
tried the Fill option under Edit, however can't seem to get it to work with
dates. For example if I enter in 3 dates in a column (see example below), I
would then like the next 20 or so rows for that column to be filled in with
dates incrementing by one week.

e.g

31.10.2005
07.11.2005
14.11.2005

thanks in advance.

Steven

--

Dave Peterson

Excel : fill by example
 

Select range you want to fill with dates, then go to Edit-Fill-Series. In
dialog for "Type" select Date, "Date unit" select Day, and for "Step value"
put 7.

"Steven" wrote in message
...
Hi

Is there a similar function to the Lotus 1-2-3 "fill by example". I've
tried the Fill option under Edit, however can't seem to get it to work
with
dates. For example if I enter in 3 dates in a column (see example below),
I
would then like the next 20 or so rows for that column to be filled in
with
dates incrementing by one week.

e.g

31.10.2005
07.11.2005
14.11.2005

thanks in advance.

Steven