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" wrote:

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