View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
lauren_roberts08 lauren_roberts08 is offline
external usenet poster
 
Posts: 3
Default unhide rows when cell is clicked

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