Download ArticleDownload ArticleThis article was co-authored by How.com.vn staff writer, Darlene Antonelli, MA. Darlene Antonelli is a Technology Writer and Editor for How.com.vn. 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 25,793 times.
Learn more...
This How.com.vn 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.
Steps
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.
Click the Home tab. You'll find this in the editing menu above your document.Advertisement
Click Find & Select. You'll find this in the "Editing" grouping of the Home tab with the icon of a magnifying glass.
Click Replace. This is usually the first listing in the drop-down menu.
Enter the original value in the "Find what" text box field. This is the text that will be replaced.
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 "How.com.vn."
- You can chose to contain your find and replace to the current worksheet or apply it to the entire workbook.
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]
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.
Tap the search iconthat looks like a magnifying glass. You'll see this in the top right corner of your screen.
- A search bar will appear at the top of your document.
Tap the gear icon. You'll see this next to the search bar that dropped down. Search options will appear.
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.
Tap Done (iOS) or X (Android). You'll see this option at the top right of the search settings.
Type your original value into the "Find" bar. This is the current value located in your document.
Type the new value into the "Replace" bar. This value will replace the current value in the document.
Tap Replace or Replace All. You'll see this with your "find and replace" terms.
Expert Q&A
Tips
How.com.vn Video: How to Replace Values in Excel
References
About This Article
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.
Is this article up to date?
⚠️ Disclaimer:
Content from Wiki How English language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.
- - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
- - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
- - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
- - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.
