I'm entering information into a spreadsheet. I use the filter option to find
the rows that I need quickly, however when I search, some of the info is not
found. For example: I enter the last name smith in the column A. When I click
on the arrow at the top of the column to go to 'Smith', the name is not an
option in the drop down menu. Where did it go? But when I use the arrow and
search the spreadsheet, it's there. So confused.