Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Selecting alternate cells
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Selecting alternate cells
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Selecting alternate cells
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Selecting alternate cells
Maybe it's early in the morning (7.23 am in the UK to be precise) but I don't
think I understand. -- Many thanks JD "CarlosAntenna" wrote: 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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Selecting alternate cells
Assuming you want to number every other row beginning with 1 and increment
the number by 1 each time: Enter 1 in cell A1 Enter 2 in cell A3 Click in cell A1 and drag to cell A4 Now you should have four cells shaded with a small square at the lower right corner of the selected area (that's the fill handle). Click on the fill handle and drag it down the column as far as you wish. The numbering will follow the pattern you have set up in the first four cells. -- Carlos "Jackie D" wrote in message ... Maybe it's early in the morning (7.23 am in the UK to be precise) but I don't think I understand. -- Many thanks JD "CarlosAntenna" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
selecting non adjacent cells | Excel Worksheet Functions | |||
selecting cells | Excel Discussion (Misc queries) | |||
Hightlighting crosshairs when selecting cells | Excel Discussion (Misc queries) | |||
To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) |