Keep Block of Cells from Scrolling

[dgeorge]

For my golf league, I have a scorecard worksheet where I enter scores weekly. I have a "template" I use to copy down for each match and this "template" is in rows 4 thru 11. I'm using Freeze Panes (between rows 11 and 12) to keep this "template" always at the top of my screen but I have a list of players, player numbers, team numbers and handicaps in 4 columns running down the right side of my screen that scrolls up and out of view. I always want to have this list visible.

I want to still keep the Freeze Panes at the top but I want my list of players to not scroll up. How do I have a Freeze Panes active and still keep this block of cells (CK5:CN43) from scrolling? Is this possible?

Thanks!!

 

[Youngdand]

HI,

You Could use split. Basically allows you to view 2 copies of the same document in different positions. Any amendments made in either screen will be made to both.

Regards,

Dan.

 

[dgeorge]

Thanks Dan. It won't, however, let me use Freeze Panes and split screen. I need the Freeze Panes turned on to keep my "template" where it is at all times. I'll keep playing with it to see if I can get it to work the way I'd like.

Thanks again!