How to Find and Replace on Excel on iPhone or iPad

Co-authored by wikiHow Staff

Last Updated: December 28, 2024

This wikiHow teaches you how to search an Excel spreadsheet for a key phrase, and replace it with another word, number, or character, using Android.

Steps

Download Article

The Excel icon looks like a green-and-white spreadsheet icon with an "X" next to it. You can find it on your home screen, or in a folder on your home screen.
This button looks like a folder icon in the lower-right corner of your screen.

Advertisement
This will open a list of all the spreadsheet files saved to this location.
This will open the spreadsheet in full-screen.
This button is located in the upper-right corner of your screen. A search bar will drop down from the top of your screen.
This button is in the upper-left corner of your screen. It will open your search options on a new page.
7
Select Find and Replace on the Options menu. This option will allow you to search a word, character, or number in your spreadsheet, and replace with another word, character, or number.
- Alternatively, you can select Find and Replace All here. This option will find all the instances of your search keyword, and replace all of them with one click.
This button is in the upper-right corner of your screen. It will take you back to the spreadsheet. You will now see two bars at the top.
The top bar at the top of your screen is your search bar. You can enter any word, character, or number here to search your spreadsheet.
The bottom bar at the top of your screen is your replacement bar. When the search function finds your search phrase in the spreadsheet, it will be replaced with your replacement term here.
11
Tap Replace next to the search bar. This option is in the upper-right corner of your screen. It will find your search phrase in the spreadsheet, and replace it with your replacement term.
- If you're using the Find and Replace All function, this button will read All instead of Replace.