Finding and replacing cell contents

You can search the selected range, current sheet, or all sheets in a spreadsheet for the text or numbers.

About this task

When performing the following procedures, you can narrow or broaden your search by selecting one or more of these options:

  • Match case – Cell contents are a match only if they have the same case as the Find entry.
  • Entire cell – Cell contents are a match only in cells that include no other content besides the Find entry.
  • Search all sheets – All sheets in the current spreadsheet are included in the search.

You can also search within a specific range by selecting the cells before performing the Find and Replace.

Note: Find and Replace does not currently support the use of regular expressions.

Procedure