How to Find and Replace on Excel on iPhone or iPad

PDF download Download Article
PDF download Download Article

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

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/99\/Find-and-Replace-on-Excel-on-iPhone-or-iPad-Step-1.jpg\/v4-460px-Find-and-Replace-on-Excel-on-iPhone-or-iPad-Step-1.jpg","bigUrl":"\/images\/thumb\/9\/99\/Find-and-Replace-on-Excel-on-iPhone-or-iPad-Step-1.jpg\/aid9636840-v4-728px-Find-and-Replace-on-Excel-on-iPhone-or-iPad-Step-1.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    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.
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/fe\/Find-and-Replace-on-Excel-on-iPhone-or-iPad-Step-2.jpg\/v4-460px-Find-and-Replace-on-Excel-on-iPhone-or-iPad-Step-2.jpg","bigUrl":"\/images\/thumb\/f\/fe\/Find-and-Replace-on-Excel-on-iPhone-or-iPad-Step-2.jpg\/aid9636840-v4-728px-Find-and-Replace-on-Excel-on-iPhone-or-iPad-Step-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    This button looks like a folder icon in the lower-right corner of your screen.
    Advertisement
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/fe\/Find-and-Replace-on-Excel-on-iPhone-or-iPad-Step-3.jpg\/v4-460px-Find-and-Replace-on-Excel-on-iPhone-or-iPad-Step-3.jpg","bigUrl":"\/images\/thumb\/f\/fe\/Find-and-Replace-on-Excel-on-iPhone-or-iPad-Step-3.jpg\/aid9636840-v4-728px-Find-and-Replace-on-Excel-on-iPhone-or-iPad-Step-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    This will open a list of all the spreadsheet files saved to this location.
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/cb\/Find-and-Replace-on-Excel-on-iPhone-or-iPad-Step-4.jpg\/v4-460px-Find-and-Replace-on-Excel-on-iPhone-or-iPad-Step-4.jpg","bigUrl":"\/images\/thumb\/c\/cb\/Find-and-Replace-on-Excel-on-iPhone-or-iPad-Step-4.jpg\/aid9636840-v4-728px-Find-and-Replace-on-Excel-on-iPhone-or-iPad-Step-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    This will open the spreadsheet in full-screen.
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/f0\/Find-and-Replace-on-Excel-on-iPhone-or-iPad-Step-5.jpg\/v4-460px-Find-and-Replace-on-Excel-on-iPhone-or-iPad-Step-5.jpg","bigUrl":"\/images\/thumb\/f\/f0\/Find-and-Replace-on-Excel-on-iPhone-or-iPad-Step-5.jpg\/aid9636840-v4-728px-Find-and-Replace-on-Excel-on-iPhone-or-iPad-Step-5.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    This button is located in the upper-right corner of your screen. A search bar will drop down from the top of your screen.
  6. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/76\/Find-and-Replace-on-Excel-on-iPhone-or-iPad-Step-6.jpg\/v4-460px-Find-and-Replace-on-Excel-on-iPhone-or-iPad-Step-6.jpg","bigUrl":"\/images\/thumb\/7\/76\/Find-and-Replace-on-Excel-on-iPhone-or-iPad-Step-6.jpg\/aid9636840-v4-728px-Find-and-Replace-on-Excel-on-iPhone-or-iPad-Step-6.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    This button is in the upper-left corner of your screen. It will open your search options on a new page.
  7. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/f9\/Find-and-Replace-on-Excel-on-iPhone-or-iPad-Step-7.jpg\/v4-460px-Find-and-Replace-on-Excel-on-iPhone-or-iPad-Step-7.jpg","bigUrl":"\/images\/thumb\/f\/f9\/Find-and-Replace-on-Excel-on-iPhone-or-iPad-Step-7.jpg\/aid9636840-v4-728px-Find-and-Replace-on-Excel-on-iPhone-or-iPad-Step-7.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    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.
  8. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/e0\/Find-and-Replace-on-Excel-on-iPhone-or-iPad-Step-8.jpg\/v4-460px-Find-and-Replace-on-Excel-on-iPhone-or-iPad-Step-8.jpg","bigUrl":"\/images\/thumb\/e\/e0\/Find-and-Replace-on-Excel-on-iPhone-or-iPad-Step-8.jpg\/aid9636840-v4-728px-Find-and-Replace-on-Excel-on-iPhone-or-iPad-Step-8.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    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.
  9. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/3f\/Find-and-Replace-on-Excel-on-iPhone-or-iPad-Step-9.jpg\/v4-460px-Find-and-Replace-on-Excel-on-iPhone-or-iPad-Step-9.jpg","bigUrl":"\/images\/thumb\/3\/3f\/Find-and-Replace-on-Excel-on-iPhone-or-iPad-Step-9.jpg\/aid9636840-v4-728px-Find-and-Replace-on-Excel-on-iPhone-or-iPad-Step-9.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    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.
  10. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/5e\/Find-and-Replace-on-Excel-on-iPhone-or-iPad-Step-10.jpg\/v4-460px-Find-and-Replace-on-Excel-on-iPhone-or-iPad-Step-10.jpg","bigUrl":"\/images\/thumb\/5\/5e\/Find-and-Replace-on-Excel-on-iPhone-or-iPad-Step-10.jpg\/aid9636840-v4-728px-Find-and-Replace-on-Excel-on-iPhone-or-iPad-Step-10.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    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. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/ed\/Find-and-Replace-on-Excel-on-iPhone-or-iPad-Step-11.jpg\/v4-460px-Find-and-Replace-on-Excel-on-iPhone-or-iPad-Step-11.jpg","bigUrl":"\/images\/thumb\/e\/ed\/Find-and-Replace-on-Excel-on-iPhone-or-iPad-Step-11.jpg\/aid9636840-v4-728px-Find-and-Replace-on-Excel-on-iPhone-or-iPad-Step-11.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    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.
    12. Advertisement

Expert Q&A

Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Tips

      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Submit
      Thanks for submitting a tip for review!

      You Might Also Like

      How to
      Recover a Corrupt Excel File
      How to Merge Cells in Microsoft Excel: A Quick Guide
      Easily Create a Drop-Down List in Microsoft Excel: Setup & Customization
      How to Use If‐Else in Microsoft Excel: Step-by-Step Tutorial
      How to
      Unprotect an Excel Sheet
      How to Create a Graph in Excel
      How to Fix Ethernet Doesn't Have a Valid IP Configuration on Windows
      How to
      Link Sheets in Excel
      How to
      Create a Mortgage Calculator With Microsoft Excel
      How to
      Make a Spreadsheet in Excel
      How to
      Insert Pictures in Excel That Automatically Size to Fit Cells
      How to Unhide Multiple Rows in Microsoft Excel
      How to Password Protect a Microsoft Excel Spreadsheet
      How to Create an Inventory List in Microsoft Excel: Step-by-Step Guide
      Advertisement

      About This Article

      Thanks to all authors for creating a page that has been read 27,808 times.

      Is this article up to date?

      Advertisement