O'Reilly logo

Special Edition Using Microsoft® Office XP by Woody Leonhard, Ed Bott

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

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 ...

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