Skip to main content Skip to complementary content

Applying a value to all cells

Applying a certain value to many cells at once can save you a lot of time when correcting invalid cells.

The State column is the last column containing incorrect data. This column lists the States from which the customers have rented a movie, using a two-letter code. You can notice that among all the other US state codes, the occurrences of Texas stand out as errors.

Rather than simply deleting the corresponding lines with the quality bar like you did before, you are going to correct one of the invalid cells, and apply the new value to all the cells with the same error. To replace the occurrences of Texas with the correct value, proceed as follows:


  1. In the State column, double-click one of the occurrences of Texas.

    You can now edit the content of the cell, and a menu with a check box opens.

  2. Instead of Texas, type TX, which is the correct two-letter code.
  3. Select the check box Apply to all cells with this value.
  4. Press the Enter key.


All the occurrences of Texas have been replaced by the correct TX State code and the quality bar now indicates that all the data in the State column is correct.

Note that when the State column is selected, the data is visualized in the form of an interactive map of the United-States in the Data profiling panel.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!