Feb 17 2020 08:36 AM
Feb 22 2022 05:03 AM
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
Mar 08 2022 06:54 AM - edited Mar 08 2022 06:55 AM
That did the trick after a few hours trying other solutions I tried your solution that worked for me.
File size went down from 3 Mb to 365 kb, last cell is now on row 1000 as it should and scrollbar can be used.
Mar 08 2022 08:22 PM
@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.
Mar 09 2022 05:06 AM
Mar 09 2022 06:36 AM
Mar 09 2022 11:33 PM
I too tried deleting the rows the regular way, but it did not work. Strangely, the problem was resolved when I resized the unused rows and columns to their standard size and then deleted it. Try saving the file after deleting them, then reopen again to check (CTRL + END) the last used cell.