Squishing Data Down.

F

f4i6008594

I have recently received some coporate documents made in Excel format that
have a very nice "1-2-3" tool bar on the left side of the screen at the top.
Below each of them are a plus sign. When you click on the plus sign, more
data appears in a designated row; and then a little minus sign appears when
you want to close it, click it.

Makes huge spreadsheets more manageable.

I want to know how to make that little section appear for a spreadsheet I am
working on. Thanks.
 
T

tjtjjtjt

To get an overview, Search the Help Files for Outline Data. This should yield
several good topics.

Depends on how your data is structured. You can Select a number of Rows or
Columns and Choose Data | Group and Outline | Group. You may have to Insert
some blank rows to make the groupings more apparent.
If you use the Data | Subtotals Feature, this wil usually create an outline.

Some other Excel Features, like Data | Consolidation (with Links) wil create
outlines, and you can generate AutoOutlines--Data | Group and Outline |
AutoOutline when you have formulas in your Workbook.

tj
 
Top