Freeze Excel headers while you scroll

Question

I have a very long spreadsheet that uses multiple headers for different sections of a table. I want to make it so that as you scroll the most recent header freezes at the top of the screen. Then, as you scroll to the next section, it is replaced by the next header. This would make it so much easier to read as each section can get somewhat long. Is there a way to do this in excel?

Answer 1

I believe the most effective solution is to convert each range of your data into a table by pressing Ctrl+T. When you do this, Excel automatically assigns headers for each table while you scroll down.