Find and replace in Google Sheets - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the 'Find and replace' feature do in Google Sheets?

It helps you quickly search for specific text or numbers in your sheet and replace them with something else.

beginner

How do you open the 'Find and replace' dialog in Google Sheets?

Press Ctrl + H (Windows) or Cmd + Shift + H (Mac), or go to the Edit menu and select 'Find and replace'.

intermediate

How do you replace text only in a selected range?

Select the range before opening 'Find and replace'.

beginner

True or False: 'Find and replace' can change text inside formulas in Google Sheets.

True. You can find and replace parts of formulas if you check 'Search within formulas'.

beginner

What happens if you click 'Replace all' in the 'Find and replace' dialog?

All instances of the found text in the chosen scope will be replaced at once.

Which shortcut opens the 'Find and replace' dialog in Google Sheets on Windows?

A Ctrl + H

B Ctrl + F

C Ctrl + R

D Ctrl + Shift + F

Ctrl + H opens the 'Find and replace' dialog, while Ctrl + F opens just the find box.

If you want to replace text only in formulas, what should you do?

A Check 'Match case'

B Check 'Search within formulas'

C Select 'Search using regular expressions'

D Select 'Match entire cell contents'

Checking 'Search within formulas' lets you find and replace text inside formulas.

What does the 'Match case' option do in 'Find and replace'?

A Finds text regardless of uppercase or lowercase

B Replaces text with uppercase letters

C Finds text only if the case matches exactly

D Ignores numbers in the search

'Match case' makes the search sensitive to uppercase and lowercase letters.

How can you limit 'Find and replace' to only a part of your sheet?

A It is not possible to limit the search

B Use the 'Match entire cell contents' option

C Use the 'Search using regular expressions' option

D Select the range before opening 'Find and replace'

Selecting a range before opening 'Find and replace' limits the search to that area.

What happens if you click 'Replace' instead of 'Replace all'?

A Only the first found match is replaced

B All matches are replaced at once

C No changes are made

D The sheet is saved automatically

'Replace' changes only the current found match and then moves to the next.

Explain how to use 'Find and replace' to change all instances of a word in a Google Sheets document.

Think about the steps from opening the tool to completing the replacement.

Describe the difference between 'Replace' and 'Replace all' in Google Sheets 'Find and replace'.

Focus on how many matches each button changes.