Press Ctrl+A or click the small triangle in the top-left corner of the worksheet to select everything, then - Right-click on any column letter and choose "Unhide." - Right-click on any row number and choose "Unhide."
If for some reason you need to clear the scroll area limits, you can remove the restriction with this statement: Me.ScrollArea = "" Or simply create a standard macro that will reset your scroll area back to the full sheet: Sub ResetScrollArea( ) ActiveSheet.ScrollArea = "" End Sub For detail, please visit: brainbell.com/excel/limit-the-scrolling-range.html#macro
Thank you for your feedback! The methods shown should generally work in Excel 2021. If you're experiencing issues, here are a few things to check: For Hiding Rows and Columns: - Ensure that you've selected the correct rows or columns to hide. - After selecting, right-click and choose 'Hide' from the context menu. You should not be able to scroll beyond the visible rows and columns. For VBA Scroll Area: - Make sure you have saved the workbook as a macro-enabled file (*.xlsm). - Check that the code Me.ScrollArea = "A1:H13" is placed correctly in the Worksheet_Activate event of the correct sheet. If these steps don't resolve the issue, it could be specific to your Excel setup or configuration. Please let me know more details about the problem you're encountering, and I'll do my best to help you troubleshoot it!
Great tip! Freezing the panes is an excellent way to lock the view and keep the important part of the sheet visible while restricting scrolling. Thanks for sharing that suggestion!
How to remove the limit of scrolling area, means how to unhide?
Press Ctrl+A or click the small triangle in the top-left corner of the worksheet to select everything, then
- Right-click on any column letter and choose "Unhide."
- Right-click on any row number and choose "Unhide."
thank you ! you are so great!
Thanks a lot! Your support means the world to me!
Thank you so much
You're most welcome
Thank you!....
You're welcome!
One question. How do you "undo" the script. I noticed if you put it and delete it still won't remove the script.
If for some reason you need to clear the scroll area limits, you can remove the restriction with this statement:
Me.ScrollArea = ""
Or simply create a standard macro that will reset your scroll area back to the full sheet:
Sub ResetScrollArea( )
ActiveSheet.ScrollArea = ""
End Sub
For detail, please visit:
brainbell.com/excel/limit-the-scrolling-range.html#macro
Does not work in Excel 2021
Thank you for your feedback! The methods shown should generally work in Excel 2021. If you're experiencing issues, here are a few things to check:
For Hiding Rows and Columns:
- Ensure that you've selected the correct rows or columns to hide.
- After selecting, right-click and choose 'Hide' from the context menu. You should not be able to scroll beyond the visible rows and columns.
For VBA Scroll Area:
- Make sure you have saved the workbook as a macro-enabled file (*.xlsm).
- Check that the code Me.ScrollArea = "A1:H13" is placed correctly in the Worksheet_Activate event of the correct sheet.
If these steps don't resolve the issue, it could be specific to your Excel setup or configuration. Please let me know more details about the problem you're encountering, and I'll do my best to help you troubleshoot it!
Before hiding the Rows and Columns I will “freeze the panes” in the lower right cell so the view cannot be scrolled off screen.
Great tip! Freezing the panes is an excellent way to lock the view and keep the important part of the sheet visible while restricting scrolling. Thanks for sharing that suggestion!