Repeating Numbers In Numerical Order

[Whit]

How do you copy a number to go in numerical order.
1,2,3,...?

 

[Peo Sjoblom]

Couple of ways, if you put 1 in A1
1. hold down ctrl key while dragging with the mouse,
2. right click and copy and and when you release mouse button
select fill series.
3. put 2 in A2 and select A1 and A2 and just copy down normally.

 

[Bob Phillips]

Whit,

In A1 type 1
A2 type 2

select cells A1 an de A2, move the cursor to the bottom right of the
selection until it changes to a black cross, then right-click and drag the
cursor down the rows you want the values in .

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)