Special Edition Using Microsoft® Office XP

Finding, Replacing, and Transforming Data

Just as in other Office applications, you can use simple drag-and-drop techniques to move or copy the contents of a cell or range. Using the Windows Clipboard and the Paste Special menu, you can also change the format of information or perform mathematical transformations as you move or copy it. Most of the options are self-explanatory, but a handful are unique to Excel and truly useful.

→ For an overview of standard Clipboard techniques you can use within and between Office programs, see "How Office Extends the Windows Clipboard".

Finding and Replacing the Contents of a Cell or Range

In previous Excel versions, the Find and Replace dialog box offered no bells and whistles, just the capability to search ...