win VISTA, Excel 7;
I desire to generate a simple series, starting with a Date. Clkng FILL, (on
Home tab), series, colum, date, day ... cannot get the STEP: to be anything
but 1. What's my oversight?
--
Boswell

"Boswell" wrote...
win VISTA, Excel 7;
....

Excel 7? Really? The same version that was also called Excel 95? I wouldn't
have thought it could run under Vista.

Or do you mean Excel 2007?

As near as I can tell (Excel 2007) you have to now enter the first 2 values
of your series with the desired step between those two and then drag to fill.
Check out Excel Help topic using
fill data
as the search topic.


"Boswell" wrote:

win VISTA, Excel 7;
I desire to generate a simple series, starting with a Date. Clkng FILL, (on
Home tab), series, colum, date, day ... cannot get the STEP: to be anything
but 1. What's my oversight?
--
Boswell

As near as I can tell (Excel 2007) you have to now enter the first 2
values
of your series with the desired step between those two and then drag to
fill.

It is nice to know the Ribbon is so intuitive to use.<g

You can still do series fills the "menu" way... click the Home tab on the
Ribbon and in the Editing panel, click the Fill icon (box with a down arrow
in it).

Rick

Thanks - looked all over for that. The ribbon may be 'intuitive' but how
many (7? more?) years of using the other inteface seems to have taken the
intuit out of my intuition, plus I didn't even find mention of that method in
2007 Help :-<

Actually, now that you've pointed it out, I think I must have looked right
at it and missed it. Too much info presented to find the unfamiliar easily?

"Rick Rothstein (MVP - VB)" wrote:

As near as I can tell (Excel 2007) you have to now enter the first 2
values
of your series with the desired step between those two and then drag to
fill.

It is nice to know the Ribbon is so intuitive to use.<g

You can still do series fills the "menu" way... click the Home tab on the
Ribbon and in the Editing panel, click the Fill icon (box with a down arrow
in it).

Rick

If you right click and drag with the mouse you will get a lot of options
upon releasing the mouse button, one of them is fill series


--

Regards,

Peo Sjoblom

"JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message
...
Thanks - looked all over for that. The ribbon may be 'intuitive' but how
many (7? more?) years of using the other inteface seems to have taken the
intuit out of my intuition, plus I didn't even find mention of that method
in
2007 Help :-<

Actually, now that you've pointed it out, I think I must have looked right
at it and missed it. Too much info presented to find the unfamiliar
easily?

"Rick Rothstein (MVP - VB)" wrote:

As near as I can tell (Excel 2007) you have to now enter the first 2
values
of your series with the desired step between those two and then drag to
fill.

It is nice to know the Ribbon is so intuitive to use.<g

You can still do series fills the "menu" way... click the Home tab on the
Ribbon and in the Editing panel, click the Fill icon (box with a down
arrow
in it).

Rick

I tried that (it is covered in Help) but couldn't seem to get it to work
right for me, maybe I wasn't holding my tongue between my teeth at just the
right angle.

But with the number of 2007 questions we're beginning to get here and there,
I suppose I'm going to have to use it more and more. But for now 2003 is
still my primary tool, and the only one in use at my workplace.

"Peo Sjoblom" wrote:

If you right click and drag with the mouse you will get a lot of options
upon releasing the mouse button, one of them is fill series


--

Regards,

Peo Sjoblom

"JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message
...
Thanks - looked all over for that. The ribbon may be 'intuitive' but how
many (7? more?) years of using the other inteface seems to have taken the
intuit out of my intuition, plus I didn't even find mention of that method
in
2007 Help :-<

Actually, now that you've pointed it out, I think I must have looked right
at it and missed it. Too much info presented to find the unfamiliar
easily?

"Rick Rothstein (MVP - VB)" wrote:

As near as I can tell (Excel 2007) you have to now enter the first 2
values
of your series with the desired step between those two and then drag to
fill.

It is nice to know the Ribbon is so intuitive to use.<g

You can still do series fills the "menu" way... click the Home tab on the
Ribbon and in the Editing panel, click the Fill icon (box with a down
arrow
in it).

Rick