• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 21. Excel Essentials > Finding, Replacing, and Transforming Data

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


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint