How to reset UsedRange on an Online Excel Worksheet

%3CLINGO-SUB%20id%3D%22lingo-sub-2566053%22%20slang%3D%22en-US%22%3EHow%20to%20reset%20UsedRange%20on%20an%20Online%20Excel%20Worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2566053%22%20slang%3D%22en-US%22%3E%3CP%3EI%20used%20the%20UsedRange%20all%20the%20time%20in%20Excel%202016%20but%20I%20have%20a%20spreadsheet%20that%20is%20only%20online%3F%26nbsp%3B%20How%20do%20I%20reset%20the%20used%20line%20as%20when%20I%20hit%20CTRL%2BEND%20it%20goes%20all%20the%20way%20down%20to%20Row%201048576%20which%20is%20crazy.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20any%20help%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2566053%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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

1 Reply
Are you not able to edit the workbook in Excel desktop?
Alternatively, deleting the extraneous rows should also fix the large used range problem.