Fixing Excel when it stops scrolling

Sometimes I track system health for huge networks with huge Excel spreadsheets. And every once in a while, I run into problems with the Excel spreadsheet not scrolling. I move the cursor, and the cursor moves, but the sheet doesn’t, so I can’t see.
The problem is freeze panes. I always have the top row frozen, since I’m typically trying to track 14 or 15 things and the rows tend to blend together if I don’t freeze my header row. But sometimes Excel gets confused and freezes more than I initially told it to freeze–like, an entire screen’s worth of data. The solution is to unfreeze everything, then freeze the top row again. Then Excel behaves again.
%d bloggers like this:
WordPress Appliance - Powered by TurnKey Linux