Abstract

Transcript

In this video, we’re going to cover shortcuts for worksheet navigation.

These are shortcuts you could use move quickly around any single worksheet.

In this worksheet, we have several thousand rows of data.

Let me show you some shortcuts that will help you move around this data quickly.

This cell represents the bottom right corner of the used worksheet area.

To rapidly move through data, you might use Control + arrow keys on both platforms.

When you’re working with larger sets of data, this is far faster than scrolling.

On a Mac, you’re free to use Command + arrow keys if you prefer.

To scroll up and down, screen by screen, use the Page Down and Page Up keys.

On a Mac without these keys, use Function with the up and down arrows keys.

To scroll right to left by one screen, use Alt + Page Up and Page down on Windows.

On a Mac, use Option with Page up and page down if you have those keys.

Otherwise, use Function + Option + up and down arrows.

On Macs without a Home key, use Function + left arrow.