I have an excel spreadsheet with 8,000 records and about 54 columns wide. My query is when trying to filter some of the records don't appear, i.e. I may want to filter a particular name - I go to filter - autofilter, dropdown arrow on the column that has the required info, scroll down in alphabetical order but the name is missing. I know it's there as I can use Ctrl + F to find but this will only give me one record at a time.
What can I do or am I doing something wrong?
Excel 97.
What can I do or am I doing something wrong?
Excel 97.