Hi
I am using MS Excel 2003. The sheet in question has approx. 176 rows and Columns till BB that are populated.
Problem- I have enabled the autofilter option for about 10 columns. I have used some rows as separators and have highlighted them yellow or grey, however these are not merged. The sheet is not protected either. When I select a parameter for filtering in one of the columns the first few items are as per the filter selected but the rest are random i.e not as per the filter selected. So I gues sthe filtering is working only for a few rows from the top.
Please let me know a way to correct this.
Thanks
I am using MS Excel 2003. The sheet in question has approx. 176 rows and Columns till BB that are populated.
Problem- I have enabled the autofilter option for about 10 columns. I have used some rows as separators and have highlighted them yellow or grey, however these are not merged. The sheet is not protected either. When I select a parameter for filtering in one of the columns the first few items are as per the filter selected but the rest are random i.e not as per the filter selected. So I gues sthe filtering is working only for a few rows from the top.
Please let me know a way to correct this.
Thanks