Searching through a spreadsheet can be a daunting task, especially when dealing with large amounts of data. MobiSheets offers powerful search features that make finding specific information quick and efficient.
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.
3. 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 spreadsheet, 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.
5. Click Replace to replace the highlighted occurrence, or click Replace All to replace all occurrences.
We hope this article has equipped you with the knowledge to efficiently search spreadsheets in MobiSheets.