Office 2008 for Macintosh: The Missing Manual

Edit Menu

The Edit menu gathers together all of Excel’s editing tools in one handy place. Many of these commands are similar to, but not identical to, those in other Office programs.

Undo

As in other programs, this command restores the last change you made; in Excel, you can undo (or redo) many steps, taking your spreadsheet all the way back to the way you found it. Keyboard shortcut: ⌘-Z.

Repeat/Redo

When you’ve done something that Excel can do over and over again, you can do so just by selecting the Repeat command. If you’ve just used the Undo command, the Repeat menu item turns into Redo, which undoes the undo you just did. Keyboard shortcut: ⌘-Y.

Cut, Copy, Copy to Scrapbook

Cuts or copies to the clipboard, or copies to the Office Scrapbook, the selected cell, cells, or object. Keyboard shortcut: ⌘-X, -C, and Shift-⌘-C.

Paste, Paste from Scrapbook, Paste Special

Pastes what you’ve just copied to the clipboard or to the Office Scrapbook. Paste Special lets you exercise some control when pasting, by pulling up the Paste Special window, where you can apply formatting. It also lets you link or embed the clipboard contents. Keyboard shortcut: ⌘-V, Shift-⌘-V.

Paste as Hyperlink

Pastes the clipboard contents into Excel as a hyperlink, either to a Web site or to a Word document. (Requires that you’d first copied an Internet address or some text out of a Word document.)

Fill

Fills the selected range of cells in the manner you specify in the Fill submenu. There are several different kinds of fills: ...