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

  1. How to Search in Google Sheets on iPhone or iPad Picture 1How to Search in Google Sheets on iPhone or iPad Picture 1
    Open the Sheets app on your iPhone or iPad. The Sheets app looks like a green spreadsheet icon on your home screen.
    1. 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. How to Search in Google Sheets on iPhone or iPad Picture 2How to Search in Google Sheets on iPhone or iPad Picture 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. How to Search in Google Sheets on iPhone or iPad Picture 3How to Search in Google Sheets on iPhone or iPad Picture 3
    Tap the three dots icon on the top-right. This button is located next to the
    How to Search in Google Sheets on iPhone or iPad Picture 4How to Search in Google Sheets on iPhone or iPad Picture 4
    icon in the upper-right corner of your screen. It will open a drop-down menu.
    1. If you're looking at a shared spreadsheet, you may not see the
      How to Search in Google Sheets on iPhone or iPad Picture 5How to Search in Google Sheets on iPhone or iPad Picture 5
      icon here.
  4. How to Search in Google Sheets on iPhone or iPad Picture 6How to Search in Google Sheets on iPhone or iPad Picture 6
    Tap Find and replace on the menu. This option will allow you to search your spreadsheet's contents for a keyword or number.
  5. How to Search in Google Sheets on iPhone or iPad Picture 7How to Search in Google Sheets on iPhone or iPad Picture 7
    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. How to Search in Google Sheets on iPhone or iPad Picture 8How to Search in Google Sheets on iPhone or iPad Picture 8
    Enter your search keyword. You can use your keyboard to type a search term here, or paste text from your clipboard.
  7. How to Search in Google Sheets on iPhone or iPad Picture 9How to Search in Google Sheets on iPhone or iPad Picture 9
    Tap the blue Search button on your keyboard. This will search the spreadsheet and find all the matching results.
    1. The total number of matches will pop up below the search bar when you hit the Search button.
  8. How to Search in Google Sheets on iPhone or iPad Picture 10How to Search in Google Sheets on iPhone or iPad Picture 10
    Use the
    How to Search in Google Sheets on iPhone or iPad Picture 11How to Search in Google Sheets on iPhone or iPad Picture 11
    and
    How to Search in Google Sheets on iPhone or iPad Picture 12How to Search in Google Sheets on iPhone or iPad Picture 12
    icons to browse all the matches. You'll find these buttons next to the search bar on the top-right corner.
    1. How to Search in Google Sheets on iPhone or iPad Picture 13How to Search in Google Sheets on iPhone or iPad Picture 13
      will jump you to the next matching cell, and
      How to Search in Google Sheets on iPhone or iPad Picture 14How to Search in Google Sheets on iPhone or iPad Picture 14
      will go back to the previous match.
Method 2 of 2:

Searching All Files

  1. How to Search in Google Sheets on iPhone or iPad Picture 15How to Search in Google Sheets on iPhone or iPad Picture 15
    Open the Sheets app on your iPhone or iPad. The Sheets app looks like a green spreadsheet icon on your home screen.
    1. 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. How to Search in Google Sheets on iPhone or iPad Picture 16How to Search in Google Sheets on iPhone or iPad Picture 16
    Tap the
    How to Search in Google Sheets on iPhone or iPad Picture 17How to Search in Google Sheets on iPhone or iPad Picture 17
    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. How to Search in Google Sheets on iPhone or iPad Picture 18How to Search in Google Sheets on iPhone or iPad Picture 18
    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.
    1. This way, you can search the title of a spreadsheet or a keyword that comes up in multiple spreadsheets.
  4. How to Search in Google Sheets on iPhone or iPad Picture 19How to Search in Google Sheets on iPhone or iPad Picture 19
    Tap the blue Done button on your keyboard. This will list all the matching results below the search bar.
  5. How to Search in Google Sheets on iPhone or iPad Picture 20How to Search in Google Sheets on iPhone or iPad Picture 20
    Tap a spreadsheet to open it. You can tap any spreadsheet file in the search results, and view the spreadsheet's contents.
3.9 ★ | 13 Vote