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
***
2 Responses
Great time saver, doc!
Permit me to contribute one of my own:
To scroll between worksheets, use CTRL + PgUp or CTRL + PgDn.
Reblogged this on SutoCom Solutions.