Hiding Cells and Sheets

Video Activity
Join over 3 million cybersecurity professionals advancing their career
Sign up with
or

Already have an account? Sign In »

Time
6 hours 3 minutes
Difficulty
Beginner
CEU/CPE
6
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