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.