ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Using <PgDn changes active cell. (https://www.excelbanter.com/new-users-excel/175416-using-pgdn-changes-active-cell.html)

sheana

Using <PgDn changes active cell.
 
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

Using <PgDn changes active cell.
 
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)


"sheana" wrote in message
...
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?





All times are GMT +1. The time now is 07:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com