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

Disadvantage:

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. 🙂

Edit:

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 doesn’t work on Excel most of the time at current job...... 🤔 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.

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

  1. David N says:

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

    Like

Comments, suggestions, corrections are welcome.

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

WordPress.com Logo

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

Google photo

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

Twitter picture

You are commenting using your Twitter 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.