Excel 2007 woes – hidden rows and cell references
So let’s say you’re working in Excel 2007. You’ve got a workbook with many worksheets inside, and you need to create a cell reference from one sheet to another. But what happens if you have hidden rows in the sheet you’re referencing from?
Depends on how your options are set. One of the things I noticed is that if you have the Lotus 123 compatibility options selected, Excel will not only unhide the hidden rows in the sheet you’re referencing, but it will also not hide them again.
It should be mentioned that this behavior is not enabled by default, but if you should run across it, here’s how to turn it off:
Click the Office Button -> Excel Options. Click the Advanced section, and scroll all the way to the bottom. Uncheck Transition navigation keys, Transition formula evaluation, and Transition formula entry.
Did you find this information useful or helpful? If so, buy me a cup of coffee. 
Did you find this information helpful? If you did, consider donating to the author.