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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top