H
hndbrk
I have a strange problem on one installation of Excel (2000 SP3). Hidden
Rows can be scrolled through when using the down-cursor key. The
values appear in the formula bar, while the highlighted cell is simply
a thick border between the two visible cells. Once on the other side of
the hidden cells the highlight cell returns to a thick border box and
it scrolls down the page as normal.
Starting from the other side of the hidden rows - If I cursor up, it'll
skip the hidden rows and go right to the next visible row. If I hide
columns and move left and right it works correctly too. I don't have
any macros, it happens on a fresh workbook, I do have a couple of
plug-ins though they are active on some other installations of excel
withot the behaviour.
It's getting irritating having to scroll through hundreds of hidden
rows, help!
Thanks in advance for any advice!
Rows can be scrolled through when using the down-cursor key. The
values appear in the formula bar, while the highlighted cell is simply
a thick border between the two visible cells. Once on the other side of
the hidden cells the highlight cell returns to a thick border box and
it scrolls down the page as normal.
Starting from the other side of the hidden rows - If I cursor up, it'll
skip the hidden rows and go right to the next visible row. If I hide
columns and move left and right it works correctly too. I don't have
any macros, it happens on a fresh workbook, I do have a couple of
plug-ins though they are active on some other installations of excel
withot the behaviour.
It's getting irritating having to scroll through hundreds of hidden
rows, help!
Thanks in advance for any advice!