Microsoft Excel 52 Grouping Data for Collapse and Expand

SimpleTutorials

Microsoft Excel is a powerful spreadsheet application used for organizing, analyzing, and visualizing data. In this course, you will learn the essential skills you need to get started and become confident in using Excel.  In this video lesson, we will learn about Grouping Data for Collapse and Expand in Microsoft Excel  You can access the entire Microsoft Excel Course in the following playlist: https://www.dailymotion.com/playlist/xa9hyw

Transcript

00:00So one of the things that you can actually do in Excel is group out data. For example,

00:09here you can see that I have fruits, vegetables, and beverages. So let's say I want to go ahead

00:14and group them out together so that I can collapse and expand them out. So in that case,

00:18you can select out these rows, let's say for example, and then what you can do is go to the

00:23data tab and then go ahead onto group and group it out. So you can see that I can go ahead and

00:29collapse and expand the screens. Now I can do same for the vegetable as well and group it out right

00:34here and same for the beverage as well. Group it out right here, just like this. So now I can go ahead

00:40and collapse each one of them as you can see right here and expand them out as well. You can simply

00:46go ahead and let's say, for example, select out everything and make a group of them as well. So

00:52you can go ahead and collapse and then go ahead and expand this out as you like, just like this.

00:57So you can go ahead and create multiple groups and subgroups as you want to go ahead and collapse

01:02and expand the data as you like. You can see like there's the level two, level three, level one. You

01:08can go ahead and click on it right here, just like this to go ahead and work around with it. You can

01:13even go ahead and ungroup it out right here, just like this to get the data back as it was. So that is

01:20how you can go ahead and group data to collapse and expand inside of Microsoft Excel. So if you found

01:27this video useful, be sure to hit the like button. Don't forget to share this out with your friends

01:32and family. And for more contents like these, do follow simple tutorials.

Category

Transcript

Be the first to comment

Recommended