Moving Among Open Workbooks

Sometimes you may have more than one workbook open at a time. If so, you can switch back and forth as necessary to view or edit their contents. There are several ways to move among open workbooks:

  • If part of the desired workbook window is visible, click it.

  • Open the Window menu and select the name of the workbook to which you want to switch.

  • Press Ctrl+F6 to move from one workbook window to another.

The Active Window

If you have more than one workbook open, only the one where the cell selector is located is considered active. The title bar of the active workbook will be darker than the title bars of other open workbooks.

Get Ten Minute Guide to Excel 97 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.