Comment on page
Find and Replace
The quickest way to check if values exist in your data, and substitute them with others.
The search bar can be used to quickly jump to a column header or cell, or just to see how many matches there are in your sheet.
The search bar can be opened by pressing command+F, or clicking the "Search" button in the toolbar.
Cells and Column headers that include the search term will be highlighted autoomatically.
To replace the search value in the open sheet, expand the search bar by clicking on the arrow button to the left of the search bar.
You can choose to replace the value in the entire sheet, or just in the selected columns. To select specific columns, click on the column header of that column.