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.
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)
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
