Find, replace and go to a cell

Updated November 13, 2026

Find

  1. Choose Edit › Find… (Ctrl+F) or Home › Find & Select.
  2. Type what you’re looking for. Under the options you can search the Sheet or the whole Workbook, by rows or columns, in Formulas or Values, and turn on Match case or Match entire cell contents.
  3. Choose Find Next or Find All.

Replace

  1. Choose Edit › Replace… (Ctrl+H).
  2. Type what to find and what to put instead, then Replace or Replace All.

Go to a cell

  • Choose Edit › Go To… (Ctrl+G) and type an address such as B12, a range, or a name.
  • Or type the address in the name box on the left of the formula bar and press Enter.

Was this article helpful?