Editing and cleaning data

You use the Manipulation Tools panel to edit and format values in a column. The panel is available in the Grid and Facets views.

Some data actions on the Manipulation Tools panel are also accessible by selecting the gear icon in a column name or by right-clicking the column name.

  1. Perform one of the following actions:
    Option Description
    To edit all values in a single column Select the column header.
    To edit all values in multiple columns Press Ctrl and select each column header.
    To edit an individual value Select a cell.
    To edit multiple values in a column Press Ctrl and select each cell.
    To edit a range of characters or a word within a cell (cell inner selection) (Character values only) Double-click in the Grid view or slow double-click in the Facets view, and select a range of characters or a word.
  2. Open the Manipulation Tools panel to the right of the Data pane.
    Unique column values appear in a Values box at the top of the panel. You can select one or more values to edit in this box, or enter a search string in the Find box. Selections in the editor panel override the value selections made directly in a column. The data actions available for a column depend on the data type of the column and on whether a column, cell, or range of characters within a cell is selected.
  3. Select an editing option on the Manipulation Tools panel, modify the values as needed, and select Apply.