unhide rows when cell is clicked

[lauren_roberts08]

Hi everyone,

Is it possible to unhide a selection of rows when you click on a cell.
For example, if I had a cell that said "Fruit", and I clicked it, could
it unhide 5 rows below that contained specifc types of fruit (ie apple,
pear, orange etc).

I am in the very beginning stages of understanding excel so any help
would be greatly appreciated (but could it also be as straightforward
as possible!! thank you!!!)

Thanks!
lauren

 

[Guest]

You would need to create an event macro to do what you're asking. In the
interest of keeping things more simple, perhaps the AutoFilter option might
work for you?

Simply select your range of data, then from the Data Menu, select Filter,
then AutoFilter. You'll now have small arrow-buttons in each of your header
rows. These can be used to easily sort and filter your data.

HTH,
Elkar

 

[gls858]

Hi everyone,

Is it possible to unhide a selection of rows when you click on a cell.
For example, if I had a cell that said "Fruit", and I clicked it, could
it unhide 5 rows below that contained specifc types of fruit (ie apple,
pear, orange etc).

I am in the very beginning stages of understanding excel so any help
would be greatly appreciated (but could it also be as straightforward
as possible!! thank you!!!)

Thanks!
lauren

It isn't clear exactly what you're trying to do but you
may want to take a look at data validation. It lets you set
up a list of items that can be selected from a drop down on
the cell. Search help for validate cell entries.

gls858

 

[Guest]

You might also group the data. Select the five rows below "Fruit", click
Data/Group and Outline/Group.