🤔How to Lock 🔐 Scrolling in Excel | Excel Practical Tips and Tricks |
Sometimes while working with Excel we require to Limit or lock the scrolling within our data. Here is the Video for this requirement.
Hello all excel lovers, Welcome to my channel @digital walkway.
In this short YouTube Excel related video I am going to teach you two method to lock or limit the scrolling of Excel data. In method one you have to hide all columns and all rows except your data and by doing this you can lock the scrolling within data. In method two we are going to use a small VBA code as per below.
VBA code to Lock scrolling
Me.scrollarea = ”Type your data range within double quote”
Outcome of this video as per below….!
1) How to Limit or lock scrolling area
2) Excel tips and tricks
So now enjoy excel learning through our @digital walkway channel.
If you really like the content of our channel then please do like, share and subscribe to this channel. If you're new here, hit the subscribe button so you make sure to never miss upcoming excel related videos.
Start watching this video and I will catch you there goodbye have a nice day.
Your Search //---
how to lock screen to prevent scrolling in excel worksheet
how to lock scrollbar in excel
scroll lock in excel
how to unlock scroll lock in excel
how to stop excel from scrolling too far
how to lock scroll area in excel
excel
prevent scrolling in excel
how to disable scroll lock
excel scroll lock
microsoft excel
how to keep the top row visible while scrolling down in excel
scroll lock
excel tips
how to lock screen to prevent scrolling in excel
how to
#shorts #viral #excel #digitalwalkway