View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
gr_jafari gr_jafari is offline
external usenet poster
 
Posts: 6
Default Having 2 header in a list

i have this data :

A B C
1 ID Summer Fruit Date Quantity(kg)
2 1 watermelon /4/9 20
3 2 pear /4/11 13
4 3 peach /4/13 50
4 4 peach /4/14 24
5 5 pear /4/16 70
6 6 graps /4/15 80
7 ID Winter Fruit Date Quantity(kg)
8 1 orange /10/12 45
9 2 graps /10/14 50
10 3 graps /10/15 70
11 4 orange /10/12 45
12 5 quince /10/14 35


when use filter in this list for "graps" , i want to fix both 1 and 7 rows
as headers and not to be hide in any case, any help considerated