This is a video tutorial for Microsoft Excel which will show you how to group and ungroup data in excel. This is basically another way to hide data in excel in a way which allows it to be readily accessible. When the rows or columns are hidden, you can see to the left and top of the spreadsheet that these rows or columns are hidden and then, with a click of the mouse, unhide the data.
This is also a nice way to clean up a spreadsheet. You can use this method to hide unsightly calculation cells or data while still allowing for the data to remain on the same worksheet.
Topics Covered
 How to Group and Ungroup Data in Excel
Hiding and Unhiding Data
Streamline a spreadsheet and clean it up without deleting data.
Difficulty: Easy
Video: Yes
Spreadsheet: No
|
