Split screen

[Manonaboat]

Is it possible to split the screen between columns G and H in the example above? I want Columns A:G to scroll up and down but H: onwards to remain. The list in the pivot table won't always be this short, so putting the PT above Row 10 and Freezing won't work as the PT may extend too far down. At the moment I have created a duplicate window and Tiled both vertically, but I wondered if there was a way to avoid doing this every time I open the workbook. Or is it possible to float the pivot table/Slicers?

 

[DanteAmor]

You have already tried the Window / Split option:

 

[Manonaboat]

Thanks Dante.
I isn't a perfect solution, but is a better work around than I had.

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.