According to my book, if I make C11 the active cell by selecting it, then hit
<PgDn> to navigate the worksheet, C11 should still remain the active cell.
However, that isn't the case. When I press <PgDn> my active cell reference
changes to C40, then C69, etc. Could you please explain what I'm doing
incorrectly?
Ron Coderre - 03 Feb 2008 15:43 GMT
If SCROLL LOCK is engaged
....Pressing PAGEDOWN changes the viewed area of the sheet without changing
the active cell.
If SCROLL LOCK is NOT engaged
....Pressing PAGEDOWN changes the active cell
Does that help?
--------------------------
Regards,
Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
> According to my book, if I make C11 the active cell by selecting it, then
> hit
> <PgDn> to navigate the worksheet, C11 should still remain the active cell.
> However, that isn't the case. When I press <PgDn> my active cell reference
> changes to C40, then C69, etc. Could you please explain what I'm doing
> incorrectly?