The Search panel provides options for search, replace, and results filtering.

  • Search Text Box—Enter the text you want to find. The search runs and returns all relevant results.
  • Next/Previous Result—Use the Next button (<F3>) to navigate to next matching cell. Use the Previous button (<Shift+F3>) to navigate to the previous matching cell. A message displays indicating the current match position and the total number of results.
  • Match Case—Enable this option to make Search case sensitive.
  • Match Whole Word—Enable this option to allow only matches for whole, stand-alone words. This option considers any words separated by spaces as whole, stand-alone words.
  • Filter Rows—Enable this checkbox to show only rows that contain matching cells. This option dynamically filters the data grid to show only relevant rows.
  • Replace Text Box—Enter the value to replace the matched search text.
  • Replace—Replaces matches in the currently highlighted cell (<Alt+R>).
  • Replace All—Replaces all matches (<Alt+A>).