Find and replace

Search for text across all columns or limit the search to one column.

Find and browse matches

Open Find and Replace with the magnifying glass, Edit → Find and Replace…, or ⌘F. Enter text in Find. Matching is case-insensitive by default; enable Aa to distinguish upper and lower case.

Choose All columns or one specific column. Enable Headers in the search area to include column headings. Use the arrow buttons, ⌘G and ⇧⌘G to move to the next or previous match. The counter counts individual matches, not rows. Click the magnifying glass again to close the search area. You can also close it using the cross or Esc while in the search area. ⌘F opens search or focuses the search field if it is already open.

Replace one match or all matches

Enter the new text in Replace with. Replace changes the current match; Replace All changes every match in the chosen search scope in one step. An empty replacement removes the matched text.

Checked rows do not limit replacement. The search text, column choice and header option determine its scope. Check those settings before using Replace All. Press ⌘Z to undo the entire operation.