Forum Discussion

reneegmol29's avatar
reneegmol29
Copper Contributor
Jul 20, 2021

How to reset UsedRange on an Online Excel Worksheet

I used the UsedRange all the time in Excel 2016 but I have a spreadsheet that is only online?  How do I reset the used line as when I hit CTRL+END it goes all the way down to Row 1048576 which is crazy.

 

Thanks for any help 🙂

Excel for web
Macros and VBA

1 Reply

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Jul 22, 2021
    Are you not able to edit the workbook in Excel desktop?
    Alternatively, deleting the extraneous rows should also fix the large used range problem.

Resources