unhide rows when cell is clicked

  • Thread starter Thread starter lauren_roberts08
  • Start date Start date
L

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
 
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
 
lauren_roberts08 said:
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
Click to expand...
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
 
You might also group the data. Select the five rows below "Fruit", click
Data/Group and Outline/Group.
 
Back
Top