Filter issue

I have an excel document that I recieved from another employee who forgot to add an extra column for the name of the person who handling the case. So I added the extra column and filter the top row. But when I uses the filter to sort the print only the one I needed filter, the drop down box doesn't display an of the information that i've enter into the cells below it. did I miss something? I have designed several spreedsheet for the pass 5 years and never seen anything like this. Can anyone help?

Try removing the filter, highlight the heading, plus all of the data below this heading and re-apply the filter, this should resolve your problem. The issue maybe to do with blank lines between your heading and data.

Thank you so much. Your information helped and it resolved my issues. <clap> <clap> <clap>