Problem with Filter

[rwmill9716]

My Excel sheet has a vertical line with a '-' at the top and a '+' at the bottom. It's located to the extreme left with a 1&2 above it. This vertical line covers 652 of the 1000 rows in the table and limits the filter arrows to those rows. How do I get rid of this limitation, and what do the 1/2 toping the column and fronting above the rows mean? Thanks.

 

[mamady]

Hi Dear,
The range is grouped. To ungroup select the column or the row and from (Data) ribbon select the below

Regards

 

[rwmill9716]

Mamady, thank you very much. That worked great, and I learned something.

 

[mamady]

Mamady, thank you very much. That worked great, and I learned something.

most welcome, I’m glad to be of help