Excel 2007 auto fill help
 

I used to use this method to fill in Excel 2003; however, it is no longer
working for me in
Excel 2007. I wanted to auto-fill from 181A to 189A and entered the first 4
cells. After highlighting cells 181A to 183A and dragging the little square
down, all I received was 181A to 183A in repeats. Can you help please?
p.s. I cannot customize the list because every time the senario is different

Excel 2007 auto fill help
 

?B?andvbmc=?= wrote in
:

I used to use this method to fill in Excel 2003; however, it is no
longer working for me in
Excel 2007. I wanted to auto-fill from 181A to 189A and entered the
first 4 cells. After highlighting cells 181A to 183A and dragging the
little square down, all I received was 181A to 183A in repeats. Can
you help please? p.s. I cannot customize the list because every time
the senario is different

Excel needs to be able to understand the sequence order to autofill.
Excel does understand simple mathematics:

Excel understands 2,4,6,8 (increase by two)
Excel understands 9.6.3 (decrease by three)

Excel does not understand 1,2,3,5 (Fibonacci sequence)
Excel does not understand 2,4,8,16

Provided there is a mathematical relationship between numbers, you can
work around the sequences Excel does not understand using formulae.For
example:
Fibonacci sequence

A1 - 1
A2 - 2
A3 - =A1+B1

Drag down the A3 formula

Multiplication

A1 - 2
A2 = =A1*2

Drag down the A2 formula




--