Switch Excel Workbooks: Keyboard Shortcuts and Tips

In Excel for Microsoft 365 on Windows, press Ctrl+F6 to switch to the next open workbook window, or Ctrl+Shift+F6 to switch to the previous one. Ctrl+Tab and Ctrl+Shift+Tab also commonly cycle through open workbook windows in desktop Excel; the Ctrl+F6 pair is the direct shortcut to try first.

The Windows shortcuts and what they do

Excel treats each open workbook window as a place you can navigate to. Ctrl+F6 moves forward through those windows; Ctrl+Shift+F6 moves backward. If two workbooks are open, either direction takes you to the other one. If three or more are open, repeat the shortcut to continue around the available windows.

The shortcut changes the active workbook window, not the active worksheet inside a workbook. The active window is the one that receives typing, formula entry, and most ribbon commands. Watch the workbook’s title bar or the selected window to confirm which file is active before editing.

Next workbook window: Ctrl+F6
Previous workbook window: Ctrl+Shift+F6
Common alternative: Ctrl+Tab for next and Ctrl+Shift+Tab for previous

These shortcuts are useful when several files are open in the same Excel desktop session. They do not save changes or close a workbook; they only move your focus. If a dialog box or another interface element has focus, keyboard input can behave differently, so click into the worksheet and try again if the shortcut appears not to work.

Workbook windows versus worksheet tabs

A workbook is an Excel file, such as Budget.xlsx. A worksheet is one tab inside that file, such as January or Summary. Confusing the two is a common reason people think the workbook-switching shortcut is broken.

To move between worksheets in the active workbook, use Ctrl+Page Down for the next sheet and Ctrl+Page Up for the previous sheet. Those shortcuts do not move to a different file. For example, if Sales.xlsx contains sheets named North, South, and Total, Ctrl+Page Down can move from North to South while leaving you in Sales.xlsx.

By contrast, if Sales.xlsx and Costs.xlsx are both open, Ctrl+F6 switches between their windows. The sheet selected in each workbook is generally retained, so returning to Sales.xlsx takes you back to the sheet you were viewing there. This distinction is especially helpful when comparing two files that each contain several tabs.

There is another subtle case: one workbook can have more than one window. Those are two views of the same file, not two separate workbooks. Switching windows can therefore appear to leave the file unchanged even though the active view has changed.

Switch workbooks step by step

Open the workbooks you need in the Excel desktop app. Check that each has finished opening and is not hidden behind a prompt.
Click a cell in the worksheet you are currently using. This gives Excel a clear worksheet focus.
Press Ctrl+F6 to go to the next workbook window. Press it again to continue through other open windows.
Use Ctrl+Shift+F6 if you want to move backward through the windows instead.
Check the title bar or workbook content before entering data, especially if the files have similar names or layouts.

Suppose you have Orders.xlsx, Returns.xlsx, and Inventory.xlsx open. Pressing Ctrl+F6 moves from the active window to the next one in Excel’s window order; pressing it again moves to another. The order may not match the order in which you opened the files, so verify the filename rather than assuming the next window is a particular workbook.

When the shortcut does not take you where expected, use the View tab’s window controls or the Windows taskbar to identify the target. Those visual options are slower than a shortcut but make it easier to distinguish files with similar names.

Switching between multiple windows of one workbook

Excel can display separate windows for the same workbook. This is useful for comparing distant sections of a large sheet, such as a summary at the top and detailed transactions farther down. To create another view, choose View > New Window. Excel opens a second window for the current workbook, usually showing a name with a suffix such as :2.

After creating the second window, Ctrl+F6 can move between the views, just as it moves between different workbook windows. Changes made in either view affect the same underlying workbook. The two windows are not independent copies, so editing a cell in one view changes that cell in the other view as well.

To see windows side by side, use the controls in View > Arrange All or choose View > View Side by Side when comparing open workbooks. The exact arrangement is a display choice; it does not combine the files or change their data. When finished, close the extra window with its own Close button. Closing a view is different from closing the workbook’s only window.

This feature can also explain why Excel seems to list the same workbook more than once. Look at the full window names and the contents, not just the shared filename, to tell separate views apart.

Using the taskbar and Excel’s window controls

Keyboard navigation is quick, but a visible list is often better when many files are open. In Excel, open the View tab and look for Switch Windows. Select the workbook window you want from the list. This is particularly useful when you need a specific file and do not know its position in the shortcut cycle.

Windows may also show Excel windows on the taskbar. If you see only one Excel button, Excel might be grouping workbook windows or using its setting for showing all windows in the taskbar. In Windows Excel, the relevant option is File > Options > Advanced > Display > Show all windows in the Taskbar. Changing this setting affects how windows appear on the taskbar; it does not change the workbook-switching shortcuts.

For a small number of files, the shortcut is usually the fastest method. For a larger set, use Switch Windows or the taskbar because a list lets you choose by name instead of cycling repeatedly. If names are hard to distinguish, rename files clearly in File Explorer before opening them, or check each title bar as you switch.

Excel for Mac and Excel for the web

On a Mac, the usual macOS shortcut for moving between windows of the same app is Command+` (Command plus the grave-accent key). The key’s location and printed symbol vary by keyboard layout, and macOS or keyboard settings can affect the behavior. Excel for Mac also has its own window controls, so use the Window menu to select a workbook when the key combination is inconvenient. Do not assume that Windows Ctrl shortcuts map directly to Mac shortcuts.

Excel for the web runs inside a browser, so switching between separate browser tabs is not the same as switching between workbook windows in desktop Excel. In many Windows browsers, Ctrl+Tab moves to the next browser tab and Ctrl+Shift+Tab moves to the previous tab. On a Mac, the browser has its own tab-navigation shortcuts. These actions switch browser tabs, which may contain Excel workbooks, rather than cycling among windows inside the desktop Excel application.

If multiple sheets are open in one Excel for the web browser tab, use the sheet tabs or the workbook’s navigation controls to move within that file. If separate workbook files are open in separate browser tabs, use the browser’s tab controls or shortcut. A shortcut’s behavior can therefore depend on whether you are using desktop Excel, a browser, or another window that currently has keyboard focus.

Common problems and quick checks

The shortcut changes sheets, not files: You may be using Ctrl+Page Down or Ctrl+Page Up. Use Ctrl+F6 to switch workbook windows.
Nothing seems to happen: Confirm that another workbook window is open, click a worksheet cell, and try Ctrl+F6 again. A single open window gives Excel nowhere else to switch.
You see the same workbook again: The file may have multiple windows open. Check the window name or use View > Switch Windows to see the available entries.
The wrong workbook becomes active: Excel cycles through windows in its current order, which may not be the order you expect. Use Switch Windows or the taskbar to select by filename.
The shortcut switches browser tabs: You are likely using Excel for the web, or the browser has focus. Decide whether you need to switch browser tabs or desktop Excel windows.
A shortcut conflicts with a laptop key: Some keyboards require an Fn key for function-row keys, and system settings may reserve keys. Try the appropriate Fn combination or choose the workbook through Excel’s View controls.

Also check whether the workbook is minimized or hidden behind another application. A workbook can remain open without being immediately visible on screen. If a protected-view banner, save prompt, or other dialog is active, resolve or dismiss it before testing the shortcut again.

Choosing the quickest method

Use Ctrl+F6 when you know you want the next workbook window and have only a few open. Use Ctrl+Shift+F6 to go backward rather than cycling forward through the whole list. Use View > Switch Windows when you need a specific named file, and use the taskbar when you are moving between Excel and other applications.

For comparisons, opening separate windows and arranging them side by side can be clearer than repeatedly switching back and forth. For ordinary data entry, however, one window per workbook is simpler and reduces the chance of editing the wrong file. A small habit helps: after switching, confirm the workbook name before making a substantial edit or saving.

Finally, remember that switching is not the same as saving. If you have changed a workbook, save it with Ctrl+S before closing it or moving to another task. Excel can keep multiple unsaved files open, but the shortcut itself does not protect those changes.

Frequently Asked Questions

What is the shortcut to switch between Excel workbooks?

In desktop Excel for Windows, press Ctrl+F6 to move to the next workbook window. Use Ctrl+Shift+F6 to move to the previous window. Ctrl+Tab and Ctrl+Shift+Tab are also commonly used alternatives.

How do I switch to the previous workbook in Excel?

Press Ctrl+Shift+F6 in Excel for Windows. If you want to choose a particular workbook rather than move backward through the window order, use View > Switch Windows and select its name.

How do I switch between Excel sheets instead of workbooks?

Use Ctrl+Page Down to move to the next worksheet and Ctrl+Page Up to move to the previous worksheet in the active workbook. These do not switch to another Excel file.

Can I switch between two windows of the same workbook?

Yes. Create another view with View > New Window, then use Ctrl+F6 or the View tab’s window controls to move between the two. Both windows show the same workbook, so edits affect the same file.

Why does Ctrl+Tab switch browser tabs instead of workbooks?

That usually means you are using Excel for the web in a browser. Ctrl+Tab is then handled as a browser-tab shortcut. In desktop Excel for Windows, try Ctrl+F6 to switch workbook windows.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.