1-866-245-5224 sales@keystonelearning.com

Excel 2003: Go To, Find & Replace

Excel 2003: Go To, Find & Replace

You’ve already learned how to enter data into your worksheet and you even know how to edit data that is already there. But, let’s look at a scenario:

It’s Monday morning and your boss just walked into your office to let you know your company is merging with another. Effective immediately, your company is no longer called ABC Corporation. Now, you’re a member of XYZ Industries. Not to worry, though. Your paychecks will be uninterrupted because you’re the only one who knows how to quickly change every existing spreadsheet to reflect the new company name. Right?

It’s a good thing you’re taking this course because I’m about to show you how to tackle this project. We’re going to look at three different areas:

     
  • Go To
     
  •  
  • Find
     
  •  
  • Replace
     

Go To

The Go To feature quickly moves your cursor to a desired location. All you need to know is the cell address or range name.

Using Go To to Locate a Cell

     
  1. Click Edit on the Menu bar
     
  2.  
  3. Choose Go To…
     

Figure 10. Go To Dialog Box

   3.      Choose a Range Name or enter a cell reference

   4.      Click OK

 Find

The Find feature quickly searches your worksheet (cell by cell) for a specific word, phrase or data in your worksheet. This is particularly useful when searching for data that appears more than once.

Figure 11. Find Dialog Box

Using Find to Locate Data

     
  1. Click Edit on the Menu bar
     
  2.  
  3. Choose Find…
     
  4.  
  5. Click Options to expand the Dialog box
     
  6.  
  7. Enter your data in the Find What: box (such as ABC Corporation)
     
  8.  
  9. Set your options. For instance, you may want to search the entire workbook and not just the current sheet next to Within.
     
  10.  
  11. Click Find Next or Find All
     
  12.  
  13. When you are finished searching your worksheet or workbook, click Close
     



Replace

The Replace feature actually works in conjunction with the Find feature by first searching for specific data and then replacing it with new data.

Figure 12. Replace Dialog Box

Using Replace to Modify Data

     
  1. Click Edit on the Menu bar
     
  2.  
  3. Choose Replace…
     
  4.  
  5. Click Options to expand the Dialog Box
     
  6.  
  7. Enter your data in the Find What: box (such as ABC Corporation)
     
  8.  
  9. Enter your data in the Replace With: box (such as XYZ Industries)
     
  10.  
  11. Set your options.
      (For instance, you may want to search the entire workbook and not just the current sheet next to Within.)
     
  12.  
  13. Click Replace All or Replace
     
  14.  
  15. When you are finished searching your worksheet or workbook, click Close