How do you sequentially number a column?

M

Morgan Montague

I'm a bit of a n00b here.

I'm setting up a spreadsheet in Excel 2002 with the first column dedicated
to just a sequence of numbers from 1 to 256 which represent slots in a
binder for various CD/DVD's off software that I own. Next to each number I
will have the name of the software plus a third column for comments (like
license key, etc.). How do I format that first column of just sequential
numbers?

TIA
 
B

Bob I

put 1 in the first cell, 2 in the second cell, select both cells, grab
the little square block in the lower right corner of the second block
and drag down till you get to 256.
 
M

Morgan Montague

Thanks again. That did the trick!
Bob I said:
put 1 in the first cell, 2 in the second cell, select both cells, grab the
little square block in the lower right corner of the second block and drag
down till you get to 256.
Click to expand...
 

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

Sequential Numbering 2
sequential numbering 8
Concatenate Date and Number field for Append Query 0
How do I use "column" function to get the column number of the firstcell matching criteria? 1
How to Count Text Occurrences in a Column?? 6
Have a list if descriptions to go in a list of cells 2
How do number columns first, then the rows in an excel footer? 1
How do I Reset Column lettering 6

Top