Excel is not counting

  • Thread starter Thread starter Sherees
  • Start date Start date
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
 
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
 
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

Similar Threads

Counting consecutive strings of text 2
Counting strings of consecutive numbers in a column 1
Consecutive Numbers 11
Counting consecutive strings of text 2
Count Number Of Times Values Appears Consecutively, Return Longest 5
Count Names 2
Excel VBA - counting cells by colors and names to it in two different rows. 0
Excel Count of Consecutive Data 0

Back
Top