You can allow more than one pane or viewport in the spreadsheet to allow you to view data from different parts of the spreadsheet in one display. Display data in multiple viewports and allow your user to customize their own viewport view by providing split boxes along with scroll bars.
For more information about scrollable viewports and split bars, refer to Customizing Viewports.