Can it do this? Don't know what its called!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

noidea - 18 Jul 2006 16:28 GMT

Hi All

Im new to excel and was wondering about the following:

In one of the columns i have to put the same information except for the
number at the end, eg example1, example2, example3 etc.

Is there something on excel that will add what i want with the number
from 1-1000? Even if it put a space that i could later remove would
help.

Thanks

Signature

noidea

Reply to this Message

SteveG - 18 Jul 2006 16:37 GMT

noidea,

In A1 type in "example1". Select your range to 1000. Go to
Edit>Fill>Series and select AutoFill. Click OK.

HTH

Steve

Signature

SteveG

Reply to this Message

noidea - 18 Jul 2006 16:42 GMT

Thanks Steve, that worked a treat!

Signature

noidea

Reply to this Message

noidea - 18 Jul 2006 16:45 GMT

Thanks Ron!

You guys have saved me typing loads of repetitive stuff!

Really appreciate your quick replies.

Signature

noidea

Reply to this Message

Ron Coderre - 18 Jul 2006 16:40 GMT

Try something like this:

Cell A1: Example1

Left-click and hold on the drag handle of cell A1
(the little black box in the lower right)

Drag down (while holding down the left mouse button)
You should see the series increment...Example1, Example2, etc
Release the mouse button when done.

Does that help?

Regards,
Ron

Signature

Ron Coderre

Reply to this Message

Bondi - 18 Jul 2006 16:43 GMT

> Hi All
>
[quoted text clipped - 14 lines]
> noidea's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36491
> View this thread: http://www.excelforum.com/showthread.php?threadid=562504

Hi,

If you enter example1, example2,example3 in cells A1, A2 and A3.
Then highlight all 3 cells and click on the little black square in the
buttom left corner of the highligted array. Then keep pressing down the
left mous button and drag down to A1000

It should fill in with example4, example5 etc. etc..

Regards,
Bondi

Reply to this Message

Rate this thread: