This is a reply to the following blog topics:

 - Scroll bar within excel sheet:

excelexperts.com/scroll-bar-within-excel-sheet

 - Insert sheet within sheet:

excelexperts.com/insert-sheet-within-sheet

 - Freeze shapes in excel:

excelexperts.com/freeze-shapes-excel

Hello, Shivam,

Because your questions are related, I decided to answer of all of them in one post. And because I think they are also related to your previous question about chart click event, I extend the example file from this topic with examples of your current questions. I hope if this does not give you the solution, at least to give you some hints.

Back to front...

There is no option to freeze shapes in the way you want. To workaround this, you can use either Freeze Panes option or Split option. This is on Ribbon -> View - > Window. In the example file I use the first one.

To insert sheet within sheet you use again a workaround way. I created a two example files each of which represent a different way to do it.

The first example also is an answer to your first question about scroll bar on pivot table, where I use a method, which is originally presented by Vishesh and can be seen here: Scroll Large Data. I just reference the scrolling range to actual pivot table, added a second scroll bar for vertical scrolling, and use some Conditional Formatting to make it look as an actual pivot table. You may notice that the first row and the first column not scrolling. I do it just for this example. You can change all of this in the way that meet your requirements. Something in addition - the scroll bar I use is a Form Controls object and it has a limitation of maximum scroll value - 30 000 (30 thousand). If you expect your data to exceed that number of rows, use an ActiveX Controls scroll bar instead.

In the second example I use the options from Ribbon -> View -> Window. Firstly, I add two additional windows from New Window - press it two times. In each window, select the desired sheet to be presented. Then use Arrange All -> Tiled -> OK. In the example file there is already two additional windows with selected Chart1 and Chart2 sheets. Just arrange them in the way you want. Here I not use any additional scroll bars or reference to another range - just the actual pivot table and worksheet scrolling features. However, this method it is not a good idea to present a chart until you have a large screen display.

Look at the attached files and if you have some questions - ask me.

Best regards.