EXCEL: Remove empty rows at the end

plagoutte -
MCLow - 13 Jun 2023 at 10:33

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

2 answers

Answer 1 / 2

Best answer
The best answer is the one that has been validated by our teams.
Patrice33740 Posted messages 8400 Registration date Status Member Last intervention 1 784

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
11
1. plagoutte
  
  Hello,
  
  Thank you for your response, but unfortunately, it didn't have any effect... After clicking on Delete, Excel loaded for a few seconds, but it didn’t delete anything. I tried saving, closing, and reopening, but nothing worked.
  
  0
2. plagoutte
  
  I uploaded a video to clarify things: https://youtu.be/7KlvSYPJ47w
  
  0
3. MCLow
  
  Big recurring problem ...
  
  With Excel 2016, the procedure from the first answer works! Thank you
  
  0
Answer 2 / 2
eriiic Posted messages 24581 Registration date Status Contributor Last intervention 7 281

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
2
1. plagoutte
  
  Hello,
  
  My file is 2.5MB and takes a long time to open, even though I only have two sheets with around 50 rows each.
  
  0
2. eriiic Posted messages 24581 Registration date Status Contributor Last intervention 7 281
  
  What matters after performing the action indicated by Patrice is where a Ctrl+End takes you.
  To line 50 or to line 1,000,000?
  And if it contains images or many objects, it can considerably increase its size.
  If that's not the case and nothing has changed, your file might be infected.
  The simplest and safest thing to do then is to copy and paste your data into a new workbook.
  Eric
  
  0
3. Patrice33740 Posted messages 8400 Registration date Status Member Last intervention 1 784
  
  While watching his video, I find that Excel takes too long to delete the blank rows (on the 2nd attempt), which indicates that they are still not empty: the file is most likely infected.
  
  0

EXCEL: Remove empty rows at the end

2 answers

Xiaomi redmi note 140 -

Several computer components

Missing lock icon

Blocked app icons on the screen image

Gotek information

How to connect an android phone to a tv via

Texture issues in enshrouded

Printer port error on canon ts3100 printer

Project phone onto tv screen

System restore from bootable windows 11 usb drive