The Excel workbook is included with our video training.

Abstract 

In this lesson, we cover shortcuts you can use to navigate workbooks.

Transcript 

In this video, we'll look at shortcuts you can use the navigate through one or more workbooks.

In a workbook that contains multiple worksheets, you can go to the next worksheet using Control + PgDn on Windows, Fn + Control + down arrow on a Mac.

To move to the previous worksheet, use Control + Page up on Windows, Fn + Control + up arrow on a Mac.

On a Mac, you can also use Option plus right and left arrow keys to move through worksheets.

To open a menu that lets you navigate through all worksheets on a workbook, right-click the worksheet navigation area, then select a sheet.

To add a new worksheet to a workbook, use Shift + F11. On a mac, add the function key.

To select multiple worksheets, you can hold down the shift key and click. To select 
multiple non-adjacent worksheets, use the control key in Windows and the Command key on a Mac.

Be careful when you have multiple worksheets selected. Any change you make will affect all worksheets!

When you have multiple workbooks open, you can move to the next workbook using control + tab.

Add the shift key to reverse direction.

In Windows, you can also switch workbooks by using the ribbon, with Alt + WW. Then type the number for the worksheet you want.

There is no dedicated shortcut in Excel to split the screen, but you can use Alt + W + S in Windows to toggle a split screen on and off.

Move the active cell to row 1 to split vertically into 2 panes.

And move the active cell to column A to split horizontally into 2 panes.

Move the active cell to row 1 to split vertically into two panes.

And, move the active cell to column A to split horizontally into two panes.

If the active cell is in the middle somewhere, you'll get 4 panes.

When you have a worksheet that's split, use F6 to move to the next pane. Add Shift to reverse direction.

Again, on a Mac, add the function key this shortcut.

To toggle the window size for the current worksheet, use Control + F10. On a Mac, addthe function key.

On a Mac, this will toggle the window to full screen. In Windows, this will toggle the windows inside the Excel application.

To minimize the current worksheet window, use Control + F9 in windows, and Command M on a Mac.

These shortcuts do different things.

In windows, the shortcut minimizes the current worksheet. You can use Control + F10 to maximize it again.

On a Mac, Command M minimizes the current worksheet into the dock. To bring a worksheet back again, you can click icon in the Dock, or select the workbook from the Window menu. 
 

Dave Bruns Profile Picture

AuthorMicrosoft Most Valuable Professional Award

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.