Mastering Data Grouping and Ungrouping in Excel

http://www.TeachMsOffice.com

This tutorial shows you how to group and ungroup rows and columns in excel. This is a way to hide and unhide data in excel which is much easier to use than other ways to hide data. This method allows you to click a visible button to unhide or hide certain parts of the spreadsheet.

This example shows you how to group and subsequently hide data that is being charted or graphed, but still plot the hidden data and also how to hide data used in a VLOOKUP(). The VLOOKUP() function will still work even on hidden or grouped data.

To get more excel related stuff including free macros, more video tutorials and forums, go to:

http://www.TeachMsOffice.com