EasySpreadsheet allows you to quickly search though a sheet. This is especially useful for sheets that contain a large amount of data.
Finding Data
To search for data or text in your spreadsheet:
Go to the Edit menu, and select Find. Or, simply press Ctrl+F on your keyboard.
A Find window will appear.
Type the data (or text) that you are looking for in the Find What box. Do NOT press the Enter key.
If the Match Case box is checked off, the search will be case-sensitive - that is, lower and upper case letters will be treated differently. Be sure to type the text exactly as it should appear in your sheet (e.g., a search for 'easyoffice' will not find 'EasyOffice'). If you do not want the search to be case-sensitive (e.g., a search for 'easyoffice' will also find 'EasyOffice'), un-check the Match Case box.
If you only want to find cells whose data matches the Find What box exactly, check off Find Entire Cells Only. In this case, a search for 2 will not find cells that contain numbers such as 2.0 and 222. Only cells that contain a single 2 will be located.
To allow partial matches, un-check Find Entire Cells Only. In this case, a search for 2 will find any cell that contains a 2. Numbers such as 2.0 and 222, or even 4235, will be located.
In the Search box, choose to perform your search By Rows or By Columns.
To replace the data (or text) that you are searching for with other data, click the Replace button. The Replace Data window will appear. See "Replacing Data" below for further details.
When you are finished your search, click Close.
Replacing Data
To search replace data (or text) in your sheet with other data:
Go to the Edit menu, and click Replace. Or, simply press Ctrl+H on your keyboard.
A Replace window will appear. This window contains most of the options that the Find window has.
When you are finished, click Close.
See Also: