Page Right and Page Left… why no such keys?

Excel Tips - Page Right and Page Left.PNG

As an Excel user, have you ever wondered why there are Page Up and Page Down keys on keyboard, but not Page Right and Page Left keys?  I do.

You may probably know that you may navigate to the right of a “large” table by holding Ctrl key with Right Arrow.  However, this will lead you to the right-most of your table.  In some occasions, it just goes too far… and that’s the time you want a Page Right key.

However you won’t find that key on your keyboard.  (If you do, please tell me where you get your keyboard.)

Nevertheless, if you really want to perform an action of Page Right or Page Left, here’s the trick:

  1. Turn Scroll Lock on.
  2. Ctrl+  (hold Ctrl and Left arrow together) has the effect of Page Right
  3. Ctrl+ (hold Ctrl and Left arrow together) has the effect of Page Left


Most of the time, we don’t want to turn on Scroll Lock when we are working with Excel.  So remember to turn it off right away.

This is not a perfect solution.  But better-than-none, I believe. 🙂


Alternative approach – a better one!

Alt+Page Down ==> Page Right

Alt+Page Up ==> Page Left

Thanks David N for telling me this more direct approach!



About MF

An Excel nerd who just transition into a role related to data analytics at current company......😊 Recently in love with Power Query and Power BI.😍 Keep learning new Excel and Power BI stuffs and be amazed by all the new discoveries.
This entry was posted in Excel Tips and tagged , . Bookmark the permalink.

4 Responses to Page Right and Page Left… why no such keys?

  1. Steffy says:

    Thanks for this. The original suggestion worked for me. I had forgotten about the scroll lock. David’s update didn’t work. Possible a difference in the later versions of Excel


  2. David N says:

    Alt+PgDn = Page Right, Alt+PgUp = Page Left


Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.