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:

-----------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------

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

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:

Playlists:

Social media: