View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CarlosAntenna
 
Posts: n/a
Default Selecting alternate cells

Another way:

First value in A1, next value in A3.
Select A1:A4
Grab the fill handle and drag it down as far as you need.

--
Carlos

"Jackie D" wrote in message
...
I'm using Office 2003 with XP Home.

I like the function in excel to generate numbers in a series. This is
achieved by selecting a an unbroken series of cells first and then going

to
Edit/Fill/Series.

What I would like to do now is place the series of numbers in alternate
cells. Is this achievable? If it is, how do I select alternate cells? I

can't
figure out a way to do it.


Many thanks
JD