Wednesday, January 28, 2009
Unhide in Excel won't let you scroll
I had a user with an odd problem today. They received a spreadsheet from one of our other offices, and one of the sheets had a bunch of hidden rows. The information she needed was in those hidden rows, so she had to unhide them. As soon as she did that, the sheet she was on would freeze. Everything was responsive, and she could click on cells, but she couldn't scroll any direction to see any other information. Other sheets within that same workbook were working fine. I did a quick search and found this, which solved her problem:
1. Unhide the hidden rows/columns like you normally would
2. On the menu bar, go to Windows->Unfreeze panes
For some reason the sheet was freezing the visible data into a single pane after it was unhidden, which gave the illusion that the sheet was locked up.
*Note: If you go to the Windows menu in Excel and you don't have the option to Unfreeze panes (you'll see Freeze panes instead), then you're having a different issue. Sorry, but I don't have a solution for that, at least not yet