O'Reilly logo

Excel 2003: The Missing Manual by Matthew MacDonald

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Edit Menu

The Edit menu has the commands you need to edit worksheet data. It includes the standard copy and paste tools, the invaluable Undo and Repeat commands that let you reverse mistaken edits, and the Find and Replace commands for hunting for important bits of information in a large worksheet.

Undo

Use this command (or the handy shortcut Ctrl+Z) to reverse the last edit you made. You can also repeatedly apply Undo to reverse a whole series of changes. Excel automatically changes the menu text to reflect the last change that you made. For example, if you delete the content in a cell, the menu text will say Undo Clear. For more information about this timesaving tool, see Section 2.2.5 (in Chapter 2).

Repeat

Use this command to repeat your last change. For example, if you hit Ctrl+B to add bold formatting to a cell, you can move to a new cell and use this command (or the handy shortcut Ctrl+Y) to apply bold formatting again. Excel modifies the menu text to reflect the last change you made—for example, after applying bold formatting, the menu text says Repeat Font. The Repeat command is also useful for reapplying a change you reversed with Undo. In other words, if you make a change, and then reverse it with Edit Undo, you can reapply it by selecting Edit Repeat immediately (before making any other changes). For the full lowdown on Undo and Repeat, see Section 2.2.5 (in Chapter 2).

Cut

Edit Cut (shortcut key: Ctrl+X) marks the currently selected cells for a cut-and-paste operation. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required