EXCEL: Remove empty rows at the end

Question

Hello,I have an Excel file with 1 million empty rows at the end of my table, how can I delete them? I can select them using CTRL + SHIFT + End, but I can't delete them using the usual methods...Does anyone have a solution?Thanks in advance!Configuration: Windows DC8 / Firefox 61.0

Patrice33740 · Accepted Answer

Hello,

Maybe:
Left click on the number of the first empty row to select the entire row, Shift + Ctrl + Down Arrow to select down to the last row of the sheet, right-click on a row number, Delete.

--
Best regards
Patrice

eriiic · Answer

Hello,

they should only be deleted if Excel sees them as used rows; they unnecessarily bloat the file.
You can see the last cell in use by pressing Ctrl+End.

But deleting them doesn’t make them disappear; a sheet always has its set number of rows.
However, you can hide them.
Eric

--
By trying continuously, we eventually succeed.
So the more it fails, the more chances we have that it works. (the Shadoks)
Besides saying thank you (yes, it happens!!!), remember to mark it as resolved. Thanks

EXCEL: Remove empty rows at the end

2 answers

Retrieve an email address

Phone alarm plus connected

Select text

Very slow computer

Message saying that my phone is compromised

No sound on my laptop

Chronology

What does sata mean when it’s displayed on my hp laptop?

Unlock toshiba 32rl933 tv pin code

Microsoft 365