Find and Replace

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:

  1. Go to the Edit menu, and select Find. Or, simply press Ctrl+F on your keyboard.

  2. A Find window will appear.

  3. Type the data (or text) that you are looking for in the Find What box. Do NOT press the Enter key.

  4. 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.

  5. 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.    

  1. In the Search box, choose to perform your search By Rows or By Columns.

  2. Click Find Next. Once the data is found, you can click Find Next again to search for the next occurrence.  (Tip: If the Find dialog box obscures your view, simply drag it to the side.)

  3. 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.

  4. When you are finished your search, click Close.

 

Replacing Data

To search replace data (or text) in your sheet with other data:

  1. Go to the Edit menu, and click Replace. Or, simply press Ctrl+H on your keyboard.

  2. A Replace window will appear. This window contains most of the options that the Find window has.

  3. Type the data (or text) that you would like to find in the Find What box. In the Replace With box, type the data that you would like to replace the Find What data with.

  4. Click Find Next to locate occurrences of your Find What data.

  5. If you would like to replace the located data, click Replace. Replacing data one by one is a very safe method.

If, however, your spreadsheet contains a lot of data, and you are certain of all replacements, it is possible to automatically replace all occurrences simultaneously. If you would like all of the occurrences of your Find With data to be changed to the Replace With data at once, click the Replace All button.

  1. When you are finished, click Close.

 

See Also:

Find and Replace Functions