Creating a drop down like menu for row of cells?

[the_OM]

I have a bit of a problem with an excel worksheet that I have going, th
whole sheet is about 450 rows with various bits of input data, an
sub-totals for various sections calculated throughout it.

In order to reduce the size and make it a little bit easier to navigat
through, I am wondering if there is anyway to make rows drop down, lik
say with an arrow to the side that a user can click on to have a grou
of cells drop down, that way I can only have sub totals and su
headings showing. Is this possible to do and how?

I've tired searching through help but can't find anything, and don'
want to use the hide feature because it just makes it too complicate
and I can see people missing out on data if they aren't paying clos
attention to the row numbers. And the whole aim of what I am doing i
putting all the data a user has to input on the one worksheet wit
subsequent sheets calculating and presenting results so I want to kee
all the cells that require input on the one sheet.

Any help would be great if anyone can tell me a way around this

 

[Loxley]

Have you tried using the following ?
...
select the rows to 'group'

click on

DATA
.....
Group and Outline
.....
Group

then select 'by rows'

this will put a + sign in the column next to the row number indicating
that some rows are hidden and therefore clicking on it will display all
those rows.

Hope that helps
Mark

 

[Ron Coderre]

Take a look at Data>Group and Outline, then post back if you have mor
questions.

Regards,
Ro

 

[Dave Peterson]

If your data is grouped nicely and it's sorted by that grouping, you could use
Data|Subtotals
Then you could use the outlining symbols to the left to hide/show the rows you
want.

You may have to remove the subtotals you've added manually and use the ones that
Data|Subtotal inserted.