Forum Discussion
Unable to delete empty rows and columns
I am unable to delete empty cells / rows / columns from my worksheet - I choose Delete and nothing happens. I have tried just cutting and pasting my data to a new document, but all of the empty cells...
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!!!
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.Yes, the regular delete rows and column function doesn't work - the extra rows and columns remain Amjeth
- None of the suggestions have worked unfortunately - saving, reopening, deleting again, nothing. I can't remove the formats and resave as data then clear and reopen - it will remove too much work that has been completed