Video Transcription

00:00

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

00:16

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

00:29

you your blessing to media calculation, would you want them just to see the final result?

00:36

So,

00:37

um,

00:39

here we have, ah,

00:41

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

00:51

or PC peripherals or whatever.

00:55

And they made the sales person made this simple table in which they have types of monitors. They have the list prices,

01:04

and then there is a quantity that customer has ordered,

01:10

and based on quantity, they're giving different levels of discount.

01:15

So if you look here, it's ah, it's relatively simple formula. So if a customer resort and more than 30

01:25

monitors they're off one model, then the discount is Ah, your 10.1, which means 10%

01:33

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

01:42

two

01:42

is

01:44

larger than 30

01:46

then after first comma, we have the action in this cell, which happens if

01:53

C two is larger than 30 and it's 0.1, meaning 10%.

02:00

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,

02:10

um, we're going to give them discount off 7%.

02:15

And if it's 10 units or less,

02:19

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.

02:30

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,

02:43

and they don shouldn't know what did this come? They got,

02:47

um,

02:49

sometimes it's it's open, but in this case, we just don't want him to know.

02:53

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.

03:02

And we just go here and click him hide

03:07

so nothing has changed. We haven't deleted this column. You see, here we have a and then cease obese hidden.

03:15

And, uh, if you click here

03:17

again, we can do hide.

03:21

So whoever is receiving this file, we'll see on Lee

03:24

product type

03:27

quantity And what is the price per unit they're getting?

03:30

And that's it.

03:32

So, um,

03:35

this is how we hide. Now, if we are doing this just

03:38

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,

03:46

we can click on these, do

03:50

and then just do one hide.

03:52

And now we have him this,

03:54

and we can do the same thing with this one.

03:59

So this is how we hide cells.

04:01

We can do the same thing with droves. For example, we don't want them at this point to see this robe because

04:09

we're just going to remove it. We don't want to remove it because we need it in a table for future use.

04:15

We just Sorry, we just press here hide

04:19

and this road is here so we can hide Rose. We can hide columns.

04:24

Uh, we cannot hide individual cells because then it would be difficult to for excel how to show that

04:32

he sells it conjectural attempted. So the logic is that we hide them either entire con or in a row

04:41

or multiple arose.

04:43

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.

04:59

But we're going toe talk about the way to protect these things in future lessons.

05:04

So this is about hiding cells.

05:08

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.

05:24

So we put thes in a separate sheet

05:28

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

05:40

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

05:50

it's easier to type like this.

05:54

We have the values here.

05:56

Now we go back

05:57

and now we if you instead of 0.1, we type large

06:02

and then instead of 0.7 we type medium.

06:10

And here we can just type

06:15

small. So you get this small and then

06:19

you

06:21

type double click on it

06:26

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.

06:42

But we still want to hide it so we can click on this sheet in which we have these numbers

06:47

and we can hide the entire sheet. So now we have sheets one and she three.

06:53

And if,

06:56

for example, we have renamed

06:58

thes

06:59

sheets into let's see

07:02

Nation.

07:05

And here we have nothing. But we could put here for example,

07:12

terms and conditions.

07:15

So we could have here some text explaining what the terms and conditions are. What is the

07:20

how how long do you have before you have to pay etcetera, etcetera, the usual things in sales

07:27

you have hidden the sheet, and essentially nobody knows

07:32

that it's there,

07:34

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

07:45

cells in XL, um, and this is enough for you to start doing it yourself.

Up Next

Intro to Excel

This basic Excel training course will give you knowledge of Excel and the ability to use this software to do elementary calculations, file manipulation, data manipulation, to create charts, pivot tables and templates.

Instructed By

Similar Content