Scroll horizontally with Alt Page Down in Excel

This is a small but useful post.

Spreadsheets become large very quickly. Lot of scrolling is required to navigate it.

Scrolling vertically is easy.

SNAGHTML35c2c578

This way you can scroll one screen of data at a time.

When it comes to scrolling horizontally, we just use right or left arrow keys. That is inefficient because it moves one column at a time. Not one SCREEN at a time.

 

Scrolling horizontally is ALSO easy

image

 

SNAGHTML35c62443

image

 

Move between sheets

While we are at it there is another useful shortcut you should know.

SNAGHTML35d2a02f

Too many sheets?
Can’t find the one you want?

This is another common problem. The solution is to right click on the bottom left navigation arrows. In order versions of Excel, there were four arrow buttons (First, Previous, Next and Last). In 2013 there are only two buttons.

But in either case you can right click in that area to open a list of sheets.

image

Now you can find the sheet you want easily.

image

Related Posts

How to create table of contents in Excel?

2 thoughts on “Scroll horizontally with Alt Page Down in Excel

  1. Pingback: Excel: Reading List | Efficiency 365

  2. Pingback: Efficiency Test 8: Excel: Scrolling | 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