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

That's clever.
--
Kevin Vaughn


"Ron Coderre" wrote:

Try this:

Put your start value in the first cell
Select the range to be filled

<edit<fill<series
Step Value: 0.5
Click the [OK] button

With the range still selected......
<edit<replace
Find What: *.5
Replace with: (leave this blank)
Click the [Replace All] button

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Jackie D" wrote:

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