If Excel filter is not working after certain row, for merged cells, on large files or on protected sheet, then see this post.

It is really easy to unhide all rows and/or columns in Excel, but make sure that the cells are not frozen and the sheet is not locked.