Set Filter in the 3rd Row

[drazendrazen]

Hello,

I would like to set a Filter in the 3rd row of the sheet so that it is possible to filter after the values starting from the 4th row to the end, though however I try the filter ends in the First row without the possibility to choose any Filter criteria.

The second thing, I would also ask if it is possible to set a filter in the merged cell "Expositionsklassen", so that as the filter criteria all the values of the columns C,D,E,F,G,H (values starting from the 4th row) can be choosen.

Kind regards

[LeoTaxi]

Merged cells causes many times problems.

exemple without merged cells

Kind regards
Leo

[Gregb11]

I try the filter ends in the First row without the possibility to choose any Filter criteria.

Are you selecting the 3rd row first? You should be able to select Row 3 and then click on "Sort and Filter", then "Filter".

[drazendrazen]

Made the mistake and did the filter with the right click, as a newby didnt know that there are differences between those.

Problem solved, thank you very much!

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.