/How To Lock Screen To Prevent Scrolling In Excel Worksheet

How To Lock Screen To Prevent Scrolling In Excel Worksheet

Video: How To Lock Screen To Prevent Scrolling In Excel Worksheet

Subtitles

hello everyone welcome to excel 10 tutorial in this tutorial I will show you how to lock screen to prevent scrolling in Excel take a look at this worksheet here I have a worksheet full of data and I want to stop scrolling okay I want to lock scrolling area to this that means from A 1 to E 34 cell number E 34 ok now how do you stop Excel from scrolling let me show you how first click on the Developer tab and click on properties and now take a look at here scroll area okay all you need is to specify the scroll area here and I want my scroll area is from A1 to E 34 let me specify it a 1 to e 34 okay now close it and you see if I try to scroll I can't I have simply locked the scroll area from here to here okay I can't scroll it this is what I wanted to show and this is really simple thanks for watching if you are new here please subscribe because this channel is all about learning excel properly so that you can be productive feel free to leave a comment and share this video with your friends it means a lot to me this is Kazi signing out from Excel 10 tutorial thank you.

READ  Gangstar Vegas Hack - Gangstar Vegas Hack iOS / Android