Over 1 million lines showing on my worksheet

Hello Dugasyl,

There may be many reasons for this to occur. You do not mention if any Macros are at play or not. It could also have to do with previous selections.

On the Sheet with this issue, just above and to the left of cell A in Row 1, click on the triangle or arrow to select the whole Sheet> In the Ribbon Click one Home, and then to the far right Click on Clear, and in the Dropdown, Click on Clear All.

HTH,

Regards.