scroll bar within excel sheet

How can we make scroll bar (horizontal and vertical )within excel sheet so that we can restrict an area where data can be shown.

Here I am attaching a file through which we all can get as an idea , what exactly I want.

As in this sheet1 red border is showing area for total data.
Green Border is showing the area within which we want to show data of this pivot table.
This means that there should be scroll bar after green border
So how should I do this.

AttachmentSize
issue.xlsx27.07 KB

RE: Scroll bar

Hello,

As far as I know you can not scroll the pivot table in the way you want. But in the Vishesh's blog there is a something which can help you to solve your problem or give you a hint of some solution.

excelexperts.com/scroll-large-data

If that does not meet your requirements, share more details about what actually trying to achieve. Maybe there is a solution.

 

Best regards.

scrollbar bar within excel

Well this is a good example and i need to do the same using pivot table.
But the method given in this blog can't be used.

As we do in our web page , that we just assign some space for showing data and other space is meant for displaying graphs or image.
The same i need to do in excel .
I need to assign a space in excel where our data will be shown and as this data can be large (n rows and n columns)so i want to place scroll bar (horizontal / vertical) so that user can view same data in small space

Scroll bar on Pivot Table

Hello, Shivam,

Please excuse me for my insistence of this, but I still think that the Vishesh's example is what you need. Of course I could be wrong. Please, see what I mean here:

excelexperts.com/reply-kumarshivamguptas-blog-questions

 

Best regards.