Freezing only half of spreadsheet

[jagsingh86]

Hey Guys,

I am trying to freeze only a specific part of my excel spread sheet.

Please see the link below. I am trying to Freeze the table I have created on the right side. So I want to be able to scroll up and down on this sheet but only want the left side to actually scroll. I want the monthly total chart to stay. Is this possible?

Also, I have freeze panes Row 1 and 2 so they do not get hidden while scrolling through the list which will continually grow as the year goes one.

http://imgur.com/Mpfs31B

[Beattle Juice]

Will Something like this work ?

[Beattle Juice]

i think that first one was not what you wanted and this may not be it either but i think it is closer using 2 tables freeze panes and delete the Columns on left to get tables closer to the left it would work great if the freeze panes would just split the table up and down and not side to side to but it looks like the table on the right can be made bigger to keep on scrolling down though if this helps you any

[jagsingh86]

no sorry this will not work.

thanks though!