Skip to content

Instantly share code, notes, and snippets.

@MrSimonC

MrSimonC/ExcelResetUsedRange

Created August 22, 2017 08:53
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save MrSimonC/ff1ea0f5b004b7ac221c09e849e06779 to your computer and use it in GitHub Desktop.
Save MrSimonC/ff1ea0f5b004b7ac221c09e849e06779 to your computer and use it in GitHub Desktop.
Download ZIP
Excel Reset Used Range
Raw
ExcelResetUsedRange
If your Microsoft Excel scroll bars scroll for a lot of cells, but you have a small amount of data, it is likely the used range needs to be reset.
Press Ctrl+End. If this doesn't jump to the end of your data, then follow the below guide:
To reset the used range in Excel, find the end of your data, then delete all the columns to the right, and all the rows below.
Press Alt+F11 to go to Microsoft Visual Basic, then press Ctrl+G to bring up the Immediate window.
In the Immediate window, type: `ActiveSheet.UsedRange` then hit Enter.
This will make Excel re-check the used range. Press Ctrl+End again and Excel will now jump to the end of your data.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment