Search

Search a spreadsheet

 

Search a spreadsheet Windows

Search a spreadsheet for text, phrase, number, or characters

1. Open a spreadsheet. Press CTRL+F, or 
In the Edit tab, select Find & Replace.

2. In the popup dialog, in the Find tab, type what you want to find.




Optionally, check the search filter criteria box:

  • Match case. Finds only occurrences of the text that match the capitalization you type.
     
  • Match entire cell. Search for that contain just the characters that you typed in the Find what: box. 

  • Search within: To search for data in a worksheet or in an entire workbook, select Current Sheet or Entire Workbook.

  • Look in: To search for data with specific details, in the box, click Formulas, Values.

4. Press Enter or navigate the highlighted search results with the Find Next and Find Previous buttons.

Find and Replace
1. Press CTRL+F, or 
In the Edit tab, select Find & Replace.

2. In the popup dialog, in the Replace tab, type the word or number you want to locate in the Find box.

3. Type your new text in the Replace box.

4. Optionally, check the search filter criteria box. 

6. Click Replace to replace the highlighted occurance, or click Replace All to replace all occurances. 

 

Search a spreadsheet Android

Search a spreadsheet for text, phrase, number, or characters

  1. Open a spreadsheet. In View mode, tap the menu in the top right. 

  2. Tap the Search icon. 

  3. Type what you want to find. Optionally, tap the search filter criteria icon:
  • Match case. Finds only occurrences of the text that match the capitalization you type. 

  • Match entire cell. Search for that contain just the characters that you typed in the Find what: box. 

  • Look in: To search for data with specific details, in the box, tick Search in results of Formulas. 




Find and Replace

  1. Open a spreadsheet. In Edit mode, on the Home tab, swipe the toolbar to reveal more options. 

  2. Tap Find & Replace. Optionally, tap the search filter criteria icon. 

  3. Type what you want to locate in the Find box.

  4. Type your new text in the Replace box.

  5. Tap Replace to replace the highlighted occurance or tap All to replace all occurances. 

 

Search a spreadsheet iOS

Search a spreadsheet for text, phrase, number, or characters

  1. Open a spreadsheet.

  2. Tap the Search icon.

  3. Type what you want to locate in the Search box.

  4. Type your new text in the Replace box.

  5. Tap Replace to replace the highlighted occurance or tap All to replace all occurances.