I opened a file which was created and altered by someone else and cannot
figure out how to restore all excel functions to default settings. My
biggest issue at the moment is filtering. When I select auto-filter and
choose the information I want to filter for it filters only a portion of all
the information then skips a line and the rest of the information is below
unfiltered. Of 3780 lines only 1648 are filtered. I know only basics of
excel and only want this file to return to default settings where I know what
I'm doing. Thank you to anyone who can help.