Refer to the case study workbook and tutorial here:
https://spreadsheetvault.com/freeze-p...
This video and tutorial will show how to freeze panes in all worksheets in a workbook. Excel only permits a user to freeze panes in one worksheet at a time.
Goal: Enable Excel users to freeze panes in the same position, across all worksheets in an active workbook.