All right.
So I'm doing our work on the editor.
Suppose there are instances where you want to change certain values of particular do so.
One thing here is you cannot simply click on any cell and right click on it or double click on it.
The cell values.
It's not possible up here.
Suppose you are in this particular column by mistake.
I have ridden motorcycles and I want to convert the values of motorcycles into motorbikes so to do that
to the name all those new what I do is simply click on the column and I will find the option of replacing
values.
So when you click on Replace values it will ask us to find the values which we want to replace.
So I just simply write down cycles and I have to replace it with more bytes.
So when I click on OK it will simply replace all the values of motorcycles into motorbikes.
So this is one way of replacing all the values in this format just by simply clicking on replace spending.
Now another instance is suppose will be a column of prices I suppose in the price each what I have to
do is simply add 10 or 20 more rise in each of the cells.
What I want to do is for each program I want to add 20 more to this like for even one reviver I want
to add 20 more so it will turn into 1 0 1 point.
If I see my Kabui with each and every one you here so we can build those values as well.
So we do that what we have to do is simply transform.
And here you'll find this option of transforming values of some in some calculations.
So when you click on standard it will last what you have to do.
So suppose for in this particular column I want to add some value to the next window that you open it
will ask us to enter the amount to enter the number which we have to add to each value in the column.
So if I want to add plenty to each value of this particular column when I click OK all the values of
the column will be added with 20.
So that's one way of changing values here.
So these are some ways to change the values to add the values what you place values in the row.
You cannot just simply click on any particular cell to replace those.
So these are the only way to replace the values in rows.
So that's all for now.
We'll continue in our next session.
Thank you.