You can replace values in any cell for which you have permissions to edit except for the following: If you want to replace those values, you'll need to unhide the columns or remove the filter and re-display the rows.įor more information about using filters, see the Filter Basics article. If your sheet contains matching values in hidden columns or filtered rows, those won't be replaced instead, you will receive a message stating that matching values exist in the hidden rows.
Exceptions With Find and Replace Behavior The number of values Smartsheet replaced will be displayed under Find what. Type the value you'd like to replace it with in the Replace with field.Ĭlick Next or Previous, and then click Replace, to replace the values one at a time.Ĭlick Replace All to replace all of the values in the sheet or selection with your Replace with value.Type the value you'd like to replace in the Find field.Click Next or Previous to navigate to the next or previous instance of that value.Type the value you'd like to search for in the Find field.
To use find and replace on the entire sheet, make sure only one cell (or no cells) are selected before opening the window. You can select multiple columns, rows, or cells before using the keyboard shortcut to find and replace values in only that portion of the sheet. To use Find and Replace, open the sheet that you want to work in and press Ctrl + F (Windows) or Cmd + F (Mac) to open the find and replace window. Use Find and Replace to search for specific values in a sheet and replace those values one at a time or all at once.
0 kommentar(er)
