I would like to freeze multiple rows in the below work sheet so that when I scroll downwards I have the corresponding topics listed below the alphabetical header.

Is this possible and how can I achieve it?

CodePudding user response：

You can freeze all rows and columns left and above a cell. In order to do that, just select that cell, type freeze in the help bar and you'll get the possibility.

E.g. if you select cell "D8" and you press "freeze", then the three most left columns and the first seven rows will be frozen.