You can freeze a row in Excel through the "Freeze Panes" menu. This lets you scroll through a spreadsheet without that frozen ...

You can freeze columns in Excel with a few clicks, and then unfreeze them when you no longer need to view them statically.

I have a large data table, lets say 100 rows and 20 columns. This is say a data table of student test results. The first column is the student names, the next 19 columns are if they got the question ...