Excel is not counting

S

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
 
G

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
 
G

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.
 
Top