How to do multiple or customized freeze panes

Dear forum,

Hi everyone, Good evening, Today i have come with excel worksheet formatting guidance.

1. I have a master sheet, which has 97 column (A: CS). This is dynamic data entry sheet and each row will contain each individual's various components of details, Like, Personal, Professional, Academic, Service, etc.,

2. I will foreseen the difficulty, while data entry happens because very lengthy master sheet. hence i would like to plan to do customized freeze panes for each components.

For example:

A:D - has basic information about the individual - I have to freeze permanently.
E:V - has professional details about the individual - I have to freeze separately as a page
W:AD - has academic details about the individual - I have to freeze separately as a page. like wise has to do for rest of the component.

So, Now, while i enter the data A:D always in the left side, which refer the individual name and i will move component wise data entry. It seems easy and no more tedious to entry the data.

I have tried, but i was able to freeze only in one column and one row. If any options are there.

Thanks in advance.

You can drag the split lines so that more than 1 row or column is frozen, but you can only have 1 vertical and 1 horizontal split on any single sheet.