Makes working with them so much easier

Excel is one of those applications in the Office suite that is just as useful in the workplace as it is at home or in the office. Excel can store large amounts of information; sometimes that information becomes too unmanageable, making it increasingly difficult to use the data stored in an Excel worksheet as the file grows.

More commonly used in commercial environments, home users are often unaware that you can group and collapse both rows and columns in an Excel worksheet to hide information until it is needed. This is especially useful when you are using formulas in a spreadsheet to summarize information and you are usually only interested in those summaries.

Suppose you have an Excel worksheet that looks like the worksheet below. Notice that there are a number of cells that contain data, and each set of data is summarized in a separate cell (B6, B13, and B20).