Select Date for the type and Day for the date unit. In the step value textbox
enter the step increment you want: 2 for every other day, 3 for every third
day, etc. IN the stop value textbox enter a date beyond which the series
should not extend (such as 1/1/2010). You can use the numeric value of the
date instead, if you prefer. For example, today has the numeric value 39313.
To stop the series one year from today, you could enter 39679 (39313+366).

Sorry for the late response. Hope this helps,

Hutch

"Boswell" wrote:

Hutch;
When attempting to use: Editing menu(Excel 7); Fill; Series; date- STEP ...
how to get a step other than 1?
--


"Tom Hutchins" wrote:

There is no Edit menu. The following list shows where the Edit menu options
from 2003 are located in 2007 (2003 not indented, 2007 indented):

Excel 2003 Location
Excel 2007 Location
Undo
Quick Access Toolbar | Undo
Redo
Quick Access Toolbar | Redo
Cut
Home | Clipboard | Cut
Copy
Home | Clipboard | Copy
Office Clipboard
Home | Clipboard | Office Clipboard
Paste
Home | Clipboard | Paste
Paste Special
Home | Clipboard | Paste | Paste Special
Paste as Hyperlink
Home | Clipboard | Paste | Paste as Hyperlink
Fill | Down
Home | Editing | Fill | Down
Fill | Right
Home | Editing | Fill | Right
Fill | Up
Home | Editing | Fill | Up
Fill | Left
Home | Editing | Fill | Left
Fill | Across Worksheets
Home | Editing | Fill | Across Worksheets
Fill | Series
Home | Editing | Fill | Series
Fill | Justify
Home | Editing | Fill | Justify
Clear | All
Home | Editing | Clear | Clear All
Clear | Formats
Home | Editing | Clear | Clear Formats
Clear | Contents
Home | Editing | Clear | Clear Contents
Clear | Comments
Home | Editing | Clear | Clear Comments
Delete
Home | Cells | Delete
Delete Sheet
Home | Cells | Delete | Delete Sheet
Move or Copy Sheet
Home | Cells | Format | Move or Copy Sheet
Find
Home | Editing | Find & Select | Find
Replace
Home | Editing | Find & Select | Replace
Go To
Home | Editing | Find & Select | Go To
Links
Office Button | Prepare | Edit Links to Office Buttons
Object
Double-click an object to edit it.
Clear | Series
Removed from product

Hope this helps,

Hutch

"Office Lapis" wrote:

Where is the option Edit for Microsoft Excel 2007