How to scroll across a screen in a quicker and more controlled way

If you have data in your Microsoft® Excel® worksheet that spans across a lot of columns, you won’t see all of your data on your screen. To view different columns, you need to scroll from one side of the sheet to the other. Most people would use the scroll bar, but there’s a quicker and more controlled way to scroll using keyboard shortcuts.

Applies To: Microsoft Excel 2007, 2010 and 2013

The ‘Page Up’ and ‘Page Down’ buttons on your keyboard allow you to move up and down your worksheet in a controlled manner. But, you can also use them to move across a sheet.

1. Open your workbook. Note that, in this screenshot, column E is not fully visible.

tip-1

2. Press ‘ALT’ + ‘Page Down’.

tip-2

The window will scroll to the right, moving to allow the next complete column of data (column E in this instance) to be fully visible.

3. Press ‘ALT’ + ‘Page Up’.

tip-3

The window will then scroll back to the left, using the same principle.