Blank rows I can't delete in Excel — the spreadsheet scrolls forever
You delete the blank rows, save the file, and Ctrl+End still jumps down to row 400,000. The rows look empty because they are — but Excel's memory of where your data "used to be" doesn't shrink just because you pressed Delete. Drop your file in below to see how far your sheet's real used range actually extends.
What Ctrl+End is actually telling you
Ctrl+End jumps to the last cell in a sheet's used range — the bottom-right corner of everything Excel considers "touched." That's determined by data or formatting that was ever applied, not by what's currently visible. A cell that once had a fill color, a border, a number format, or even just got pasted into and then cleared, still counts. If your real data ends at row 400 but you once selected down to row 100,000 and applied bold or a border by accident, Excel remembers row 100,000 as the edge of the sheet.
Why deleting the rows doesn't fix it
The Delete key clears cell contents only. It leaves any formatting on those cells untouched, so the used range doesn't shrink — Excel still thinks those rows are "used" because they're still formatted, just with nothing visible in them. This is the single most common reason a spreadsheet keeps scrolling far past its real data even after a thorough-looking cleanup.
How to actually reset it
Select the entire row range from just below your real data down to the old used-range boundary (Ctrl+Shift+End finds the far edge), then right-click and choose Delete — not the Delete key — which removes the rows themselves, formatting included, rather than just their contents. Save the file afterward; Excel recalculates the used range on save, and Ctrl+End should now land close to your actual last row.
How to check before you go looking row by row
Upload your file above and it will report exactly where the real data ends versus where the sheet's used range extends to, so you know how much dead space you're actually clearing before you touch anything.