Merlin Archer
New Member
- Joined
- Sep 25, 2016
- Messages
- 8
- Office Version
- 365
- Platform
- MacOS
Hi guys - numptie here again...
I've got a club membership and payments spreadsheet which works its way down the screen as the year goes on. The column headings stretch over five rows as there's more data there than just a title; I'd like to be able to freeze those five rows but the 'Freeze' options only offer 'Freeze First Row' and 'Freeze First Column'. There is a third option, 'Freeze Pane' and I suspect that would do what I want, but for the life of me i can't see how to define rows 1 - 5 as a pane. Can anybody put me out of my misery please?
I've got a club membership and payments spreadsheet which works its way down the screen as the year goes on. The column headings stretch over five rows as there's more data there than just a title; I'd like to be able to freeze those five rows but the 'Freeze' options only offer 'Freeze First Row' and 'Freeze First Column'. There is a third option, 'Freeze Pane' and I suspect that would do what I want, but for the life of me i can't see how to define rows 1 - 5 as a pane. Can anybody put me out of my misery please?