I have inherited a large excel file nearly 4000 rows long
The first column is a reference number and can be between 1 and 750
inclusive.

For information, the number repesents an electronic programable key
for use in a computerised fuel monitoring / issue system. The other
columns are used to record what vehicle is set up against each key,
other columns record similar data, ie. user departments, fuel type
etc.

If a fuel key is returned it can be reprogramed with different
references, the details of the original references are kept in the
spreadsheet.

Therefor if a filter is applied to the first column for say key number
5, all rows with the figure 5 in the first column should be displayed.

Unfortunately all rows are not shown, is there a limit to the number
of rows allowed in a spreadsheet. There does not appear to be any
blanks in the first column. If for instance I enter a unique figure in
the first column of the row following the last row this is picked up
when applying a filter

I know excel is not the best way of recording this data but as stated
I inherited the spreadsheet

Many Thanks

Steve