Repeating Numbers In Numerical Order

  • Thread starter Thread starter Whit
  • Start date Start date
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.
 
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)
 
Back
Top