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
Смотрите видео How To Lock Screen To Prevent Scrolling In Excel Worksheet онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Excel 10 tutorial 22 Ноябрь 2017, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 98,500 раз и оно понравилось 386 людям.