Main Profile

At A Glance

Group/Ungroup Data in Excel - How to Easily Hide Data

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
Length: 04:48

Contact

Questions about Group/Ungroup Data in Excel - How to Easily Hide Data

Want more info about Group/Ungroup Data in Excel - How to Easily Hide Data? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question