Sequential numbering

[JSMITH242B]

Hi Group,
How can I number a column from 1 to 3000 without entering each value?

TIA
J

 

[BrainB]

1. Put number 1 in cell A1. Formula
= A1 + 1
in cell A2 and copy down.

2. Put 1 in A1. 2 in A2. Select both, and drag downwards to copy.



Regards
BrianB
Use CupOfCoffee to speed up all windows applications
================================

 

[TonyJollans]

Hi JSMITH242B,

This rather depends on how you want the end result to behave, but one simple way ..

Enter [blue]1[/blue] in cell A1
Select A1
Move the cursor over the square in the bottom right hand corner of the cell until it changes to a black cross ..
Right Click and Drag down to A3000
Choose Fill Series from the Popup Menu

This will give you VALUES in the cells, which will not change if they are copied.

Alternatively ..

Enter [blue]1[/blue] in cell A1
Enter [blue]=A1+1[/blue] in cell A2
Copy A2 down to A3000

.. or ..

Enter [blue]=ROW()[/blue] in cell A1
Copy A1 down to A3000

These will give you FORMULAE in the cells, which will change when copied.

.. or ..

..

You can record any of these sequences to get code if that is what you want.



Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

 

[waynerenaud]

Another way to skin a cat.....
put 1 in cell A1 then choose edit/goto
under Reference put A2:A3000 click ok
then type =A1+1 and press ctrl + Enter