How To Lock Screen To Prevent Scrolling In Excel Worksheet
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: / excel10tutorial
-----------------------------------------------------------------------------------------------------------
Step 1: First Click on the “Developer” tab. If you can’t find “Developer” tab here is how to get it:
• How to add developer tab in excel
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: / excel10tutorial
Twitter: / excel10tutorial
Blogger: https://excel10tutorial.blogspot.com
Tumblr: / excel10tutorial
Instagram: / excel_10_tutorial
Hubpages: https://hubpages.com/@excel10tutorial
Watch video How To Lock Screen To Prevent Scrolling In Excel Worksheet online without registration, duration hours minute second in high quality. This video was added by user Excel 10 tutorial 22 November 2017, don't forget to share it with your friends and acquaintances, it has been viewed on our site 98,500 once and liked it 386 people.