How To Lock Screen To Prevent Scrolling In Excel Worksheet?

Excel scroll area has great impact on your productivity. Every unnecessary scroll can lost you time and the beauty of reporting. Sometimes we need to do reporting and for beatification or productivity we need to lock the scroll area.

Let me show you how do you stop excel from scrolling In simple steps. Here is how:

———————————————————————————————————–
Support Us: https://www.patreon.com/excel10tutorial
———————————————————————————————————–

Step 1: First Click on the “Developer” tab. If you can’t find “Developer” tab here is how to get it:
https://youtu.be/jkSLYLk0OHU

Step 2: Now click on “Properties”.

Step 3: Now specify the lock area in the “Scroll Area” option

Step 4: Now close the dialogue box.

It’s done. You have just learned how to lock scrollbar in excel.

Thanks for watching.

#excel10tutorial #preventscrolling

If you like this tutorial, please subscribe:
https://goo.gl/uL8fqQ

Here goes the most recent video of the channel: http://bit.ly/2oXmqsb

Playlists:
Advance Excel Tutorial: https://goo.gl/ExYy7v
Excel Tutorial for Beginners: https://goo.gl/UDrDcA
Excel Case: https://goo.gl/xiP3tv
Excel VBA Programming Course: http://bit.ly/excelvbacourse

Social media:
Facebook: https://facebook.com/excel10tutorial
Twitter: https://twitter.com/excel10tutorial
Blogger: https://excel10tutorial.blogspot.com
Tumblr: https://excel10tutorial.tumblr.com
Instagram: https://www.instagram.com/excel_10_tutorial
Hubpages: https://hubpages.com/@excel10tutorial *Become a member and enjoy exclusive perks while supporting the channel you love!*
https://www.youtube.com/@Excel10tutorial/join

Please take the opportunity to connect and share this video with your friends and family if you find it useful.