How To Install Excel On Ipad 2

Download Article

Download Commodity

This wikiHow teaches y'all how to search an Excel spreadsheet for a key phrase, and supercede information technology with another word, number, or character, using Android.

Steps

1. 1

   Open Microsoft Excel on your iPhone or iPad. The Excel icon looks similar a green-and-white spreadsheet icon with an "Ten" adjacent to it. You can observe it on your abode screen, or in a folder on your domicile screen.

2. 2

   Tap the Open tab. This button looks similar a binder icon in the lower-right corner of your screen.

   Advertisement

3. three

   Tap iPhone or iPad under the PLACES heading. This will open a listing of all the spreadsheet files saved to this location.

4. iv

   Tap the spreadsheet file you want to edit. This will open up the spreadsheet in total-screen.

5. 5

   Tap the white magnifier icon. This push button is located in the upper-right corner of your screen. A search bar will drop down from the top of your screen.

6. six

   Tap the light-green gear icon next to the search bar. This button is in the upper-left corner of your screen. It will open your search options on a new page.

7. 7

   Select Notice and Supersede on the Options menu. This option volition allow you to search a word, graphic symbol, or number in your spreadsheet, and replace with another give-and-take, character, or number.

   • Alternatively, you can select Find and Replace All here. This selection will find all the instances of your search keyword, and replace all of them with one click.

8. 8

   Tap Done . This button is in the upper-right corner of your screen. It will take you back to the spreadsheet. Yous volition now see two bars at the top.

9. 9

   Enter a search phrase into the top bar. The peak bar at the top of your screen is your search bar. You can enter any discussion, character, or number here to search your spreadsheet.

10. 10

    Enter a replacement term into the bottom bar. The bottom bar at the top of your screen is your replacement bar. When the search role finds your search phrase in the spreadsheet, it will exist replaced with your replacement term here.

11. 11

    Tap Supplant next to the search bar. This option is in the upper-right corner of your screen. It will observe your search phrase in the spreadsheet, and replace it with your replacement term.

    • If y'all're using the Find and Replace All function, this button will read All instead of Replace.

    Advertizing

Ask a Question

200 characters left

Include your email address to go a bulletin when this question is answered.

Submit

Advertisement

Thank you for submitting a tip for review!

Most This Article

Thank you to all authors for creating a page that has been read 12,821 times.

Is this article up to date?

Source: https://www.wikihow.com/Find-and-Replace-on-Excel-on-iPhone-or-iPad

Posted by: ellisoffearmed.blogspot.com

Share this post