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

Lesson 6. Editing Entries > Finding and Replacing Data

Finding and Replacing Data

With Excel's Find and Replace features, you can locate certain data and replace it with new data. When you have a label, a value, or formula that is entered incorrectly throughout the worksheet, you can use the Edit, Replace command to search and replace all occurrences of the incorrect information with the correct data.

To find and replace data, follow these steps:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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