Excel is not counting

[Sherees]

merry x'mas
In excel 2003, i entered a number in a column and dragged down the rows to
count the consecutive numbers automatically, but it was just copying the same
number instead counting. How to change so as to count?

 

[מיכ×ל (מיקי) ×בידן]

Do the same while holding the CTRL Pressed.
Micky

 

[Gord Dibben]

Enter 1 in A1.

Right-click and drag down.

Release button and "Fill Series"

Or 1 in A1, 2 in A2 select both and drag down.

Excel needs to see a pattern.


Gord Dibben MS Excel MVP

 

[Gary Keramidas]

need more than 1 entry when doing it without using the control key. enter a 2 in
the next row, then select both and drag.