How to Search in Google Sheets on iPhone or iPad
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. Open the Sheets app on your iPhone or iPad. The Sheets app looks like a...
Method 1 of 2:
Searching a Sheet's Contents
- 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.
- 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.
- Tap the three dots icon on the top-right. This button is located next to the
- If you're looking at a shared spreadsheet, you may not see the
- If you're looking at a shared spreadsheet, you may not see the
- Tap Find and replace on the menu. This option will allow you to search your spreadsheet's contents for a keyword or number.
- 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.
- Enter your search keyword. You can use your keyboard to type a search term here, or paste text from your clipboard.
- 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.
- Use the
-
Method 2 of 2:
Searching All Files
- 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.
- Tap the
- 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.
- Tap the blue Done button on your keyboard. This will list all the matching results below the search bar.
- Tap a spreadsheet to open it. You can tap any spreadsheet file in the search results, and view the spreadsheet's contents.
Update 05 March 2020
You should read it
- The new Google Search buttons have appeared in beta for some people
- How to Set Up RCA Controls Without a Code Search Button
- Hide the Search button and the Task View button on the Taskbar on Windows 10
- How to hide the search button on the Windows 11 taskbar
- Instagram Doesn't Have Filter Search Button [REPAIR INSTRUCTIONS]
- Create Button in CSS
- Turn your Google spreadsheet into a brilliant rainbow
- How to print an Excel spreadsheet in a page
- How to create Google Spredsheet automatically updates data
- How to add Google Search options on Microsoft Edge
- How to Make a Shared Spreadsheet
- How to change worksheet size in Excel