Limit the Scrolling Area Range of Your Worksheet

This hack comes very useful when you don’t want your viewers to see all the data in your excel worksheet. You can easily define a scrollable range for each of your worksheet.
To do this:
Open up Excel’s Visual Basic Editor(Alt+F11). Or right click on the sheet name you want to set scroll area and select View Code.


Now go to Project Explorer(Ctrl+R) and select the sheet you want to set scroll area.

Define the scroll range in the properties window(F4)


Save it and see the result.

About the author Rabin Biswas

Blogging and PHP programming are what make me feel alive. Other than that party with friends and music.

Find Rabin Biswas on: Twitter, Google+, Facebook or Email.