How to Search in Google Sheets on iPhone or iPad

Co-authored by wikiHow Staff

Last Updated: May 14, 2018

This wikiHow teaches you how to search a spreadsheet file's contents for a specific keyword, or search all your saved spreadsheets by title, using an iPhone or iPad.

Method 1

Method 1 of 2:
Searching a Sheet's Contents

1
Open the Sheets app on your iPhone or iPad. The Sheets app looks like a green spreadsheet icon on your home screen.
- If you're not automatically logged in, tap the SIGN IN button on the bottom-left, and select a Google account to sign in with.
2
Tap the spreadsheet you want to edit. Find the spreadsheet file you want to search in your saved files, and tap on the file's name to open it.
3
Tap the three dots icon on the top-right. This button is located next to the
icon in the upper-right corner of your screen. It will open a drop-down menu.
- If you're looking at a shared spreadsheet, you may not see the
  icon here.
4
Tap Find and replace on the menu. This option will allow you to search your spreadsheet's contents for a keyword or number.
5
Tap the Find in document field at the top. This is the search bar at the top of your screen. You can enter any keyword to search here.
6
Enter your search keyword. You can use your keyboard to type a search term here, or paste text from your clipboard.
7
Tap the blue Search button on your keyboard. This will search the spreadsheet and find all the matching results.
- The total number of matches will pop up below the search bar when you hit the Search button.
8
Use the
and
icons to browse all the matches. You'll find these buttons next to the search bar on the top-right corner.
- will jump you to the next matching cell, and
  will go back to the previous match.

Method 2

Method 2 of 2:
Searching All Files

1
Open the Sheets app on your iPhone or iPad. The Sheets app looks like a green spreadsheet icon on your home screen.
- If you're not automatically logged in, tap the SIGN IN button on the bottom-left, and select a Google account to sign in with.
2
Tap the
icon on the top-right. This button is located on a green navigation bar in the upper-right corner of your screen. It will let you search all your saved spreadsheet files.
3
Enter a keyword into the search bar. The search field is at the top of your screen. You can enter any keyword or number here, and search all your saved spreadsheets.
- This way, you can search the title of a spreadsheet or a keyword that comes up in multiple spreadsheets.
4
Tap the blue Done button on your keyboard. This will list all the matching results below the search bar.
5
Tap a spreadsheet to open it. You can tap any spreadsheet file in the search results, and view the spreadsheet's contents.