Efficiency Test 8: Excel: Scrolling Horizontally

Scrolling is inevitable. But there is a catch. If you press Page Down, the next screen of rows are shown. The problem is, we also need to scroll horizontally. What do you do then?

What is the most efficient way of scrolling horizontally?

Most of us will press right or left arrow key repeatedly. That’s all.

We never tried to find out a faster way – something like Page Down – but in horizontal direction.

Of course it is available. In fact it also uses Page Up and Page Down keys – but with Alt key.

Open a broad Excel sheet and try it … Alt Page Down (moves one screen to right ) or Alt Page Up (more one screen to left).

More about navigation and selection

Here are some articles which will show many useful ways of moving around and selecting things in Excel:

Selecting things in Excel
How to create Table of Contents in Excel
Scroll horizontally with Alt Page Down in Excel

***

3 thoughts on “Efficiency Test 8: Excel: Scrolling Horizontally

  1. Great time saver, doc!
    Permit me to contribute one of my own:
    To scroll between worksheets, use CTRL + PgUp or CTRL + PgDn.

  2. Pingback: (in)Efficiency Tests | Efficiency 365

Leave a Reply

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