Another feature in Excel related to viewing worksheets in alternative ways is “Split”.
Split is in the Window group on the View tab.
While Split has its uses, it is very different from Freeze Pains in 2 ways:
1: Split allows you to view the entire worksheet contents in each of its panes. Contrast this with Freeze Panes where you can only view a slice of the worksheet in each pain.
2: Split allows you to change the position of the split on the fly by grabbing and moving it with your mouse. Contrast this with Unfreeze/Freeze by highlighting the cell where you want the “freeze point”.
So, if you wanted to view data for AUSTIN and TAMPA for Q1 and Q2 2015, you could split the sheet horizontally and do so.
Note that each split window has its own independent horizontal scroll control.