[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Collapse]WPF Controls
  Prerequisites
 [Expand]What's Installed
 [Expand]Common Concepts
 [Expand]MVVM Framework
 [Collapse]Controls and Libraries
   Reporting
  [Expand]Data Grid
  [Expand]Ribbon, Bars and Menu
  [Expand]Charts Suite
  [Expand]Pivot Grid
  [Expand]Scheduler
  [Collapse]Spreadsheet
    Product Structure
   [Expand]Getting Started
   [Expand]Spreadsheet Document
    Supported Formats
   [Expand]Cell Basics
   [Expand]Formulas
    Defined Names
    Data Binding
    Data Validation
   [Expand]Data Presentation
   [Expand]Pivot Table Overview
   [Expand]Charting Overview
    Shapes
    Printing
    Protection
    Find and Replace
   [Expand]Mail Merge
   [Collapse]Visual Elements
    [Collapse]Dialogs
      Format Cells Dialog
      Paste Special Dialog
      Edit Hyperlink Dialog
      Symbol Dialog
      Create Table Dialog
      Change Chart Type Dialog
      Find and Replace Dialog
      Encrypt Document Dialog
      Password Dialog
      Protect Workbook Dialog
      Protect Sheet Dialog
      User Permissions Dialog
      Insert Function Dialog
      Function Arguments Dialog
      Name Manager
      New Name Dialog
      Create Names from Selection Dialog
      Subtotal Dialog
      Data Validation Dialog
      Properties Dialog
      Page Setup Dialog
      Header and Footer Dialog
      Create PivotTable Dialog
      Move PivotTable Dialog
      Change PivotTable Data Source Dialog
      PivotTable Field List
      PivotTable Value Field Settings Dialog
      PivotTable Field Settings Dialog
      PivotTable Sort Dialog
      Insert Calculated Field Dialog
      Insert Calculated Item Dialog
      PivotTable Solve Order Dialog
      PivotTable Options Dialog
      New Formatting Rule Dialog
      Conditional Formatting Rules Manager
     Pop-up Menus
    Services
    Themes and Templates
   [Expand]Shortcuts
   [Expand]Examples
  [Expand]Rich Text Editor
  [Expand]Tree List
  [Expand]Gauge Controls
  [Expand]Map Control
  [Expand]Layout Management
  [Expand]Windows Modern UI
  [Expand]Printing-Exporting
  [Expand]Data Editors
  [Expand]Navigation Controls
  [Expand]Spell Checker
  [Expand]Property Grid
  [Expand]PDF Viewer
  [Expand]TreeMap Control
  [Expand]Diagram Control
  [Expand]Windows and Utility Controls
   Dialogs, Notifications and Panels
  [Expand]Scheduler (legacy)
 [Expand]Scaffolding Wizard
 [Expand]Localization
  Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Reporting
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Find and Replace Dialog

The Find and Replace dialog allows end-users to perform a search in the active worksheet and optionally replace the search term with another value. This dialog box includes two tabs: Find and Replace.

To invoke the Find and Replace dialog, click Find or Replace item from the Find & Select drop-down menu. To enable the menu, add the Editing ribbon group. See the Lesson 1 - Create a Simple Spreadsheet topic for a demonstration on how to provide a Ribbon UI for the SpreadsheetControl.

End-users can also invoke the dialog using the following short keys:

  • CTRL+F - to invoke the dialog with the Find tab selected.
  • CTRL+H - to invoke the dialog with the Replace tab selected.

Expanded Find Tab

End-users can use the Find tab to search for information in the active worksheet.

To start a search, an end-user should enter the search term in the Find what field, and then click the Find Next button.

The Find tab provides end-users with the following advanced options to fine-tune a search:

Option

Description

Search Specifies the search direction. Select By Rows to search each row from left to right, or By Columns to search each column from top to bottom.
Look in Allows end-users to select what to examine in each cell when searching. Select Formulas to search for cell values and formula expressions, excluding the calculated results, or Values to search for cell values only (including values calculated from formulas).
Match case Enables a case-sensitive search.
Match entire cell contents Allows end-users to search for a complete match of the search term.

Expanded Replace Tab

End-users can use the Replace tab to replace the data they are searching for with another value.

To replace a value, end-users should enter the search term in the Find what field and the replacement text for this search term in the Replace with field, and then click the Find Next button to find the first occurrence of the search term.

Clicking the Replace button replaces only the value of the selected matching cell. Click Replace All to replace all occurrences of the search term.

The Replace tab contains the same advanced options as the Find tab. The difference is that only the Formulas option is available for end-users in the Look in box.

Tip

To perform a search in code, use the Range.Search, Worksheet.Search or IWorkbook.Search method, depending on where you wish to search for your data: in the specific cell range, the current worksheet or the entire document. To set options affecting a search, create an instance of the SearchOptions class and pass it as a parameter to the Search method. For an example, refer to the Find and Replace document.

Is this topic helpful?​​​​​​​