Selecting alternate cells
Thanks, I appreciate the feedback.
***********
Regards,
Ron
XL2002, WinXP
"Jackie D" wrote:
I would never have thought of that! Thanks. SImple but effective.
--
Many thanks
JD
"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
|