In my book, I stick to solutions that work. But when I teach an Excel course, I take time to point out things that can go wrong. For example, has your screen ever had crosshairs in the middle of the worksheet? If you’re not sure what I’m talking about, please click this link to open an Excel 2007 file (zipped, no macros) named “Freeze-Panes-Problems-1.xlsx” to view the problem. Or, have you ever opened a spreadsheet and tried to move down the spreadsheet using either the scroll bar or keyboard down arrow but nothing seemed to happen? Please click this link to open an Excel 2007 file (zipped, no macros) named “Freeze-Panes-Problems-2.xlsx” to view this situation.
Both of these problems are a result of someone incorrectly applying the Freeze Panes feature. In the first case, the crosshairs in the middle are a result of someone applying the Freeze Panes feature while Cell A1 is the active cell. In the second case, this can happen if someone applies the Freeze Panes feature while the data is filtered.
To fix the problem in the first case, Unfreeze the Panes, click some cell other than Cell A1, and reapply the Freeze Panes feature. To fix the problem in the second case, Unfreeze the Panes, make sure the data is not filtered, and reapply the Freeze Panes feature.
For more information on the Freeze Panes feature, please see Chapter 2 of "Simply learning Excel 2007."