#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Edit?

Where is the option Edit for Microsoft Excel 2007
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,069
Default Edit?

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

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 28
Default Edit?

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

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,069
Default Edit?

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I edit this macro? Mallers Excel Discussion (Misc queries) 5 April 24th 06 07:32 PM
Formula edit sunderland27 Excel Discussion (Misc queries) 12 April 21st 06 11:02 PM
fx-edit teddkilroy New Users to Excel 1 April 3rd 06 05:58 PM
I cannot edit in a cell Kelli Excel Discussion (Misc queries) 1 September 28th 05 08:25 PM
Why can't I edit my excel document? Edit buttons shaded. Arl @ CBC New Users to Excel 3 September 7th 05 01:18 AM


All times are GMT +1. The time now is 12:06 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"