Forum Discussion
Unable to delete empty rows and columns
Hi G_Torres,
I hope you got a solution already; this is for others who haven't yet. I tried everything possible and found online, but nothing could actually remove those unused but non resetable last cell in Excel sheet which made the sheet a lot (really lot!) bigger than it actually its. SO HERE IS THE WORK AROUND (might sound silly but this works; worked for me and made my Excel the optimum size😞
- Find the actual last used row in the sheet (with either a formula or a value). Select all the rows beneath it. Now comes the strange part - resize all the rows to 13 (or any other size), then back to 12.75 (standard Row height) and now try deleting (right click, then delete) the selection.
- Do the same for the last used column - select all the columns to the right of actual used column - resize it to 9 (or any random size), then to 8.43 (standard Column width) and now delete the selection.
- Now, press CTRL+END to check the last used CELL. If nothing changes, SAVE the file and REOPEN it to check the last used CELL again. This worked for me and nothing else did!
CHEERS!!!
- wow this solution worked for me!
- Thank you. That worked for me when nothing else did.
Amjeth super and mass veralevel
Amazing, thank you! made my spreadsheets 13mb smaller by doing this trick! Although it can be time consuming. But if you have multiple sheets with the same formatting you can copy and paste format and it works too.
- That worked! What a strange workaround, and thanks for sharing!
Mahdy1234No luck after saving the file and reopening it?
Hope you did delete the selection by Right-Clicking and then selecting Delete in the pop-up menu.
Pressing the Delete key on the keyboard or Clearing the contents alone won't help.
