Collapse and expand data

E

Eliz

How do i collapse and expand data without adding or doing any mathematical
formulae? for example:

- Countries
Nigeria 10
England 20
US 30

Collaspe into:
+ Countries
 
F

FSt1

hi
to"collapse".....
hi lite the rows then on the menu bar...
format>row>hide.
to "expand"...
hi lite the row above and below the hidden rows then on the menu bar..
format>row>unhide.

Regards
FSt1
 
S

ShaneDevenshire

Hi,

Suppose your data is in cells A1:B4, one way is to highlight the rows 2:4
and choose the command Data, Group and Outline, Group. Then you can collapse
and expand using the +/- signs that will appear to the left of the column
letters.

An other alternative is to use AutoFilter. Select the same range as above
and choose the command Data, Filter, Auto Filter. Then open up the dropdown
in column A (I am assuming the title Country is in column A) and choose
Custom and from the first drop down pick Contains and in the box to the right
enter 1 and click OK. This will hide all the entries. To redisplay them
open the same drop down and choose All.

You can also do this with a pivot table, but that's a little overkill here.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create form with checkbox les that expand and collapse sections of the form? 0
Expand/Collapse in Pivot Tables 2
Collapse/Expand Buttons in a Pivot Table 0
Grouping on protected worksheets 4
Allowing expanding and colapsing of groups in a protected workshee 1
Pivot table in excel 2007 – default the data to collapsed? 0
Collapsing/expanding grouped areas on multiple pages 1
Expanding and Collapsing Groups within a Protected Workbook 1

Top