Unable to delete empty rows and columns

G_Torres None of the previous solutions worked for me, but I had two tables side by side.

My solution was to resize each table to the correct height, by changing the range of the tables.
Table Design -> Resize Table.

As soon as the tables were resized, I was able to delete the lines, without saving and re-opening the file.

Hope this helps someone.  I am using the latest Office 365 Version 2311 Build 17029.20000

G_Torres Had the same issue and when I removed all my filters it worked.

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😞

1. 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.
2. 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.
3. 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!!!

G_Torres 

Select them, try

and click on Save.