Okay, Now I'm going to talk about hiding cells and hiding sheets in Excel, and it is very important feature because it allows you to have some intermediary calculations you need for your sheet for your spreadsheet
to be hidden just because they're unimportant for the look of the final report or you want to send it to somebody and you don't want them to look, too. Whatever
you your blessing to media calculation, would you want them just to see the final result?
one typical table that somebody that's doing sales could be done. So let's assume that this is a company's doing wholesale monitors
or PC peripherals or whatever.
And they made the sales person made this simple table in which they have types of monitors. They have the list prices,
and then there is a quantity that customer has ordered,
and based on quantity, they're giving different levels of discount.
So if you look here, it's ah, it's relatively simple formula. So if a customer resort and more than 30
monitors they're off one model, then the discount is Ah, your 10.1, which means 10%
and ah, let me just remind you how this if works. So if and then we have a condition. And the condition is if C
then after first comma, we have the action in this cell, which happens if
C two is larger than 30 and it's 0.1, meaning 10%.
And if it's not, then we have another condition, which is if C two is larger than 10. So if we have ah, quantity larger than 10 units,
um, we're going to give them discount off 7%.
And if it's 10 units or less,
we're going to give them this count. Tow the list price of just 3%. This is this is a practice that is normal in a wholesale.
And then here we have a sales price. So we want to send it to the customers. Say, Okay, these are the prices and giving you. Now what? What is the case here is that the customer doesn't know list price,
and they don shouldn't know what did this come? They got,
sometimes it's it's open, but in this case, we just don't want him to know.
So we're going toe select this column here or we can just sell excels. But it's better to select entire column because this is what makes sense.
And we just go here and click him hide
so nothing has changed. We haven't deleted this column. You see, here we have a and then cease obese hidden.
And, uh, if you click here
again, we can do hide.
So whoever is receiving this file, we'll see on Lee
quantity And what is the price per unit they're getting?
this is how we hide. Now, if we are doing this just
to make this clearer, so if we're not trying to hide this from somebody, we just don't want to look at these cons,
we can click on these, do
and then just do one hide.
And now we have him this,
and we can do the same thing with this one.
So this is how we hide cells.
We can do the same thing with droves. For example, we don't want them at this point to see this robe because
we're just going to remove it. We don't want to remove it because we need it in a table for future use.
We just Sorry, we just press here hide
and this road is here so we can hide Rose. We can hide columns.
Uh, we cannot hide individual cells because then it would be difficult to for excel how to show that
he sells it conjectural attempted. So the logic is that we hide them either entire con or in a row
And you see here in the row numbers we see three and five, so that means we have a hidden broke here. Now, of course, this is not enough to hide some data from somebody because that person can just do the and hide and see this.
But we're going toe talk about the way to protect these things in future lessons.
So this is about hiding cells.
Now, Can you imagine here that we don't want to to have these numbers here? Because sometimes these discount can change. For example, we can say that this week if you ordered more than 30 units, you get 12% discount.
So we put thes in a separate sheet
and we have named the cells. You remember the naming of cells. So this is large and now large is no longer. Is there a point? One is going to be 0.12
and the other two, which are called medium and small. So large discount medium. This can't small discount. I could have put here a small discount, but
it's easier to type like this.
We have the values here.
and now we if you instead of 0.1, we type large
and then instead of 0.7 we type medium.
And here we can just type
small. So you get this small and then
type double click on it
and you got the same result and, you know, expanded to all of these cells. And you see now here we get this bill. Okay, so here the customer cannot see low, no longer the values of discount.
But we still want to hide it so we can click on this sheet in which we have these numbers
and we can hide the entire sheet. So now we have sheets one and she three.
for example, we have renamed
sheets into let's see
And here we have nothing. But we could put here for example,
terms and conditions.
So we could have here some text explaining what the terms and conditions are. What is the
how how long do you have before you have to pay etcetera, etcetera, the usual things in sales
you have hidden the sheet, and essentially nobody knows
unlike wood cells, where you see that it's simply missing. So this is how you hide sheets. So this is all about hiding sheets and
cells in XL, um, and this is enough for you to start doing it yourself.