I am using a excel as a data base and scheduling program, lately I have noticed that the sheet has over 1 million lines at the bottom of my page I can't delete.
When I try to use the search bar over to the right of the screen the search bar is really small and as soon as I move it I drag the page down to over 10,000.
My database is only around 300 and the million line thing is new (not sure if my 2 year old had something to do with it).
I think it is slowing down the program and it is making searching difficult, don't want to start a new excel file because I have a number of complex sheets reading from it.
Has anyone got a solution.

Thanks Paul