Generating number lists in Excel

K

KemperPierce

I have a list of 4,075 names that I need number in the colum next to it
in consecutive order. Is there a command that I can use to create this
ordered list so that I do not have to input each, individual value?

Any help would be appreciated
 
J

JE McGimpsey

I have a list of 4,075 names that I need number in the colum next to it
in consecutive order. Is there a command that I can use to create this
ordered list so that I do not have to input each, individual value?

one way:

Enter 1 next to the first name. Select the column next to the names.
Choose Edit/Fill/Series. Verify the Columns and Linear radio buttons are
checked, with a step value of 1. Click OK.

You could also enter a 1 in the first cell, then CTRL-click on the fill
handle of the cell (lower-right corner) and drag down as far as
necessary. When you release the mouse button, choose Fill Series from
the popup menu.
 

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