freeze panes so the top AND right half of sheet stays "on screen"

Hi,
i would appreciate very much your help with this.

i have a pivot table that is 10000 rows in it but i was wondering if i could have the worksheet set up so the top rows AND the right hand side of the screen is visible at all times
when i am scrolling down.

i have attached an example of my file ( couldn't attach original due to data protection),

basically, could i arrange the sheet so that the blue shaded cells are visible at all times (i.e frozen on the screen), yet the orange shaded ( which is a pivot table ) can move down with the curser like it normally would.

i have played around with FREEZE PANES , and i have frozen on cell H7, but when i scroll down its just freezing the top rows 1to7 and the "test" text in row 12 does not freeze when i scroll down.

basically i would like the text "test" in row12 to be frozen on screen as well as the text Alan1 in row5.

hope someone knows a way i can deal with this,

with many thanks - very grateful for your help

regards, steve r

Hi Tms, thanks

cant seem to do it with splitting the screen. and ill need just the one workbook really. (otherwise ill need to change a ton of codes i think)