consecutive numbering

G

Guest

Can i consecutively number a column without doing it manually or entering a
math function using excel 2000?
 
G

Guest

Hi,

Enter 1 in the top cell (say A2) and 2 in the cell below (A3). Now select
both A2 and A3, move the cursor to the bottom right-hand side corner of the
selected area; the cursor would change into a "+" like shape. Hold the left
mouse button and drag the cursor down to as many cells as you want.

Regards,
B. R. Ramachandran
 

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

Consecutive No'ing WHEN ADDING/DELETING ROWS 2
the numbers on the left do not start at 1 or go in order 2
Numbering table rows consecutively (PPT) 0
Count function in Auto-Filtered data 1
consecutive numbering 1
Multiple reports with consecutive numbering 5
change starting page number 2
Count Number Of Times Values Appears Consecutively, Return Longest 5

Top