This wikiHow will show you how to find and replace cell values in Microsoft Excel. The Find and Replace tool is available in all versions of Excel, including the mobile Excel app.

Method 1
Method 1 of 2:

Using Excel on a Computer

  1. 1
    Open your workbook in Excel. You can open your project by clicking the File menu and selecting Open. You can also open it by right-clicking the file and selecting Open With > Excel.
    • This method should work for all versions of Microsoft Excel beginning with Excel 2007.
  2. 2
    Click the Home tab. You'll find this in the editing menu above your document.
    Advertisement
  3. 3
    Click Find & Select. You'll find this in the "Editing" grouping of the Home tab with the icon of a magnifying glass.
  4. 4
    Click Replace. This is usually the first listing in the drop-down menu.
  5. 5
    Enter the original value in the "Find what" text box field. This is the text that will be replaced.
    • You can use * to find a string of characters. For example, s*d will find "sad" as well as "started."[1]
    • You can use ? to replace a single character in a search. For example, s?t will find "sat" and "set."[2]
  6. 6
    Enter the new value in the "Replace with" text box field. This text will replace the original text.
    • You can opt to match the case, so you can change every instance of "wikihow" to "wikiHow."
    • You can chose to contain your find and replace to the current worksheet or apply it to the entire workbook.
  7. 7
    Click Replace All or Replace. If you want to decide to replace each original value individually, choose Replace, but if you want to replace all the original values at once, choose replace all.[3]
  8. Advertisement
Method 2
Method 2 of 2:

Using the Excel Mobile App

  1. 1
    Open your project in Excel. This app icon looks like a green-and-white spreadsheet icon with an "X" next to it. You can find this app on the Home screen, in the app drawer, or by searching.
    • If you don't have the Excel app, you can get it for free from the App Store (iOS) and the Google Play Store (Android).
    • Tap the Open tab in Excel to find all your recent documents.
  2. 2
  3. 3
  4. 4
    Tap to select Find and Replace or Find and Replace All. As you tap an option, you'll see the search bar at the top of the screen change to fit your selection.
    • Tap Find and Replace if you want to replace each original value individually.
    • Tap Find and Replace All if you want to replace all the original values instantly.
  5. 5
    Tap Done (iOS) or X (Android). You'll see this option at the top right of the search settings.
  6. 6
    Type your original value into the "Find" bar. This is the current value located in your document.
  7. 7
    Type the new value into the "Replace" bar. This value will replace the current value in the document.
  8. 8
    Tap Replace or Replace All. You'll see this with your "find and replace" terms.
  9. Advertisement

wikiHow Video: How to Replace Values in Excel

Video Player is loading.
Current Time 0:00
Duration -:-
Loaded: 0%
Stream Type LIVE
Remaining Time -:-
 
1x


You Might Also Like

Create a Mortgage Calculator With Microsoft ExcelCreate a Mortgage Calculator With Microsoft Excel
Make a Spreadsheet in ExcelMake a Spreadsheet in Excel
Unprotect an Excel SheetUnprotect an Excel Sheet
Create a Timeline in ExcelHow to Create a Timeline in Excel: SmartArt, Templates, and More
Create a Graph in ExcelCreate a Graph in Excel
Change from Lowercase to Uppercase in ExcelChange from Lowercase to Uppercase in Excel
Merge Cells in ExcelHow to Merge Cells in Microsoft Excel: A Quick Guide
Insert Pictures in Excel That Automatically Size to Fit CellsInsert Pictures in Excel That Automatically Size to Fit Cells
Video Player is loading.
Current Time 0:00
Duration -:-
Loaded: 0%
Stream Type LIVE
Remaining Time -:-
 
1x
Unhide Rows in Excel
Convert Excel to Word3 Easy Ways to Convert Microsoft Excel Data to Word
Use ExcelNew to Excel? Here's Super Easy Tricks to Get You Started
Find Duplicates in ExcelFind Duplicates in Excel
Calculate Age on ExcelHow to Calculate Age on Microsoft Excel Using Functions
Link Sheets in ExcelLink Sheets in Excel
Advertisement

About This Article

Darlene Antonelli, MA
Written by:
wikiHow Technology Writer
This article was co-authored by wikiHow staff writer, Darlene Antonelli, MA. Darlene Antonelli is a Technology Writer and Editor for wikiHow. Darlene has experience teaching college courses, writing technology-related articles, and working hands-on in the technology field. She earned an MA in Writing from Rowan University in 2012 and wrote her thesis on online communities and the personalities curated in such communities. This article has been viewed 18,187 times.
How helpful is this?
Co-authors: 3
Updated: May 5, 2021
Views: 18,187
Categories: Microsoft Excel
Article SummaryX

To find and replace cell values on your computer, open your worksheet in Excel and click the Home tab. Click the Find & Select button on the toolbar, and then select Replace on the menu. On the ""Find and Replace"" window, enter the text you want to find into the ""Find what"" field. You can even use wildcards for a string of text. Wildcards are special characters that replace other characters in searches, like a question mark in place of a letter or an asterisk. In the ""Replace with"" field, type your replacement text exactly how it should appear. To replace all original values at once, click the Replace All button. If you'd rather approve each replacement, click Replace instead. To replace cell values in the mobile Excel app, open Excel and select a file to edit. Tap the search icon at the top-right corner, and then tap the gear icon next to the search bar to view your options. If you want to replace multiple instances of the same text all at once, tap Find and Replace All. If you'd rather manually approve each replacement, select Replace instead. Then, Tap Done at the top-right corner. Now, type the text you want to replace into the ""Find"" bar, and the replacement text into the ""Replace"" bar. Finally, tap Replace or 'Replace All to replace the cell values.

Did this summary help you?
Advertisement