Grouping and Ungrouping Cells

Video Activity
Join over 3 million cybersecurity professionals advancing their career
Sign up with
Required fields are marked with an *
or

Already have an account? Sign In »

Time
6 hours 3 minutes
Difficulty
Beginner
CEU/CPE
6
Video Transcription
00:00
Let's now talk about grouping and grouping cells. So in this lesson, I will show you this lovely, visual aided Excel has.
00:10
And when I say this is a visual aid, this is because
00:14
this actually is intended mainly for viewing. So let's clear the filtering you we had before. Let's delete these,
00:25
um,
00:27
extra cells we don't need.
00:29
And let's go to our old same table.
00:32
Ah, and let's look at it. And, for example, we're doing some analysis and imagine that this has, like, 100 throws or something like that,
00:42
and we're looking at just the revenue generated shift and who's sells person. So we're not really interested
00:50
in profit and every gym. Arjun. Now what we can do is we can hide them,
00:57
Uh, and we cannot hide them later.
01:00
But we also can do is we can go and group them,
01:06
and if we grouped them, they become grouped
01:11
and we can just remove them from the
01:15
screen
01:17
and they're still here.
01:19
And also what we have here
01:22
is levels off displaying or showing what's grouped. So we have level one in which were were displaying.
01:32
We're removing from the view the group sells
01:36
and also a level two when we're where we are showing them.
01:41
Ah, the good thing about groping is that we can do that also for Rose. So we can, for example, sort this
01:53
table,
01:53
Let's say, by shift. So it's a, uh,
01:57
afternoon shift in morning shift. Yeah, we made a mistake. So
02:01
let's click here
02:04
on Dhe do this
02:07
and this will also
02:08
make this thing bad. So let's select all of these cells
02:14
was do sorting
02:15
and we want to sort by calm sea
02:20
and we want from A to Zed
02:23
And now we can select the morning shift
02:28
and group. It's as well,
02:30
and now we can also click here on one and cook your own one,
02:36
and we get just what we wanted to look, which is
02:39
the revenue in morning shift is every afternoon shift.
02:45
So if we want to one group these so we don't need grouping anymore.
02:50
We have to show all of the table
02:55
like here
02:57
and then select group rose or columns and click Anon group.
03:02
So let's do it. The same thing here
03:06
was do the young group and we're back where we started. So this stable is now
03:10
fully visible. Nothing is grouped off course. You can say with grouping, but it's Ah
03:19
unless it's absolutely needed. It's not really necessary.
03:25
So this is all about grouping and and grouping grows and corns in Excel.
Up Next