Creating an automatic List

[DW]

Hello. Basically what I'm trying to do is have Excel complete the
list for me. For example, I am trying to catalog an office full of
CD's starting with the # 1000, then 1001, then 1002, etc. Do I have
to type all of these in because there are hundreds of them, or can
Excel see I am making a list of these numbers and automatically go on
from there? Any help is much appreciated as I would like to save the
time it will take to fill in all these numbers by hand!


Danielle

 

[Geoff Lilley]

Hello. Basically what I'm trying to do is have Excel complete the
list for me. For example, I am trying to catalog an office full of
CD's starting with the # 1000, then 1001, then 1002, etc. Do I have
to type all of these in because there are hundreds of them, or can
Excel see I am making a list of these numbers and automatically go on
from there? Any help is much appreciated as I would like to save the
time it will take to fill in all these numbers by hand!

Danielle

Danielle:

Couple of ways that could be done. The fastest and easiest one I can
think of is this:

1) Create column A for the CD number.
2) In A1, put the label (like, "CD Number.")
3) In A2, put 1000 (or whatever you want your starting value to be.)
4) In B2, put the CD name. (For example, if I was catalogging Mac
software, I might have B2 say, "Disk Warrior 3.")
5) Keep entering in CD names all the way down column B.
6) Whenever you're at a good stopping point, click on cell A2.
7) Put your cursor <IMPORTANT>in the lower right hand corner of the
cell.</IMPORTANT>
8) Double-click, and Excel will populate the number 1000 in every
cell. But that's just the beginning. Once it has, you'll see a
little gold plus sign flashing. Click on it, and it will give you
some options (AutoFill options). Click on "Fill Series."

You're good to go.

Hope that helps.

Cheers
Geoff

 

[CyberTaz]

Just a variation on Geoff's suggestion...

After typing all the records: In A2 type 1000, in A3 type 1001. Select
*both* A1 & A2, then use the fill handle to drag down to extend the series.
Seems to work a little faster for me

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[DW]

Thank you so much for the help. Forgive me, I am not Excel savvy at
all so I am afraid these suggestions are a little lost on me. If you
wouldn't mind putting it down very simple, step by step, that would be
a big help. I tried the first tip but didn't see any gold plus sign
flashing and got stuck there. Thanks so much.


Danielle

 

[Geoff Lilley]

Thank you so much for the help. Forgive me, I am not Excel savvy at
all so I am afraid these suggestions are a little lost on me. If you
wouldn't mind putting it down very simple, step by step, that would be
a big help. I tried the first tip but didn't see any gold plus sign
flashing and got stuck there. Thanks so much.


Danielle

Danielle:

Let's start small.

1) Go to your "Excel" menu in the upper-left hand corner of your
screen. Click on "About Excel."

What do you see there?

2) If you type in the number "1001" in a cell, and then put your cursor
in the lower right-hand corner of the cell, does your cursor change to a
black plus sign? What happens when you click and drag down? Do you see
anything at all change on your screen?

Let us know. We'll start small.

Geoff