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.
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).
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).
Edit → Cut (shortcut key: Ctrl+X) marks the currently selected cells for a cut-and-paste operation. ...