Jump to content

Navigate between windows


Recommended Posts

Navigate between windows

Do you frequently open and work in two or more Excel workbooks simultaneously? If so, there are four basic ways to navigate between workbooks efficiently.

• Open Excel's Window menu, then either type the number corresponding to the workbook you want to view or click that workbook's name.

• Press [Ctrl][F6]. Each time you press that key combination, Excel will switch to the next open workbook.

• Press [Alt][Tab]. When you do, Windows displays a set of icons corresponding to all open applications, not just your Excel workbooks. Hold the [Alt] key and press [Tab] to cycle between icons. As you access the Excel icons, Windows will display the name of that workbook. When you find the one you want, release the [Alt] key to display it.

• Click the appropriate item in the Windows taskbar. By default, Excel displays a separate taskbar item for each open Excel window.

There's only one problem with the fourth option. If you're also running an e-mail client, a Web browser, or a word processing program, you may suffer from taskbar clutter.

If you run Excel 2000, you can eliminate some of that clutter by going to Tools | Options | View. In the Show section, deselect the Windows In Taskbar option and click OK. Excel now displays only one item in the Windows taskbar, no matter how many workbooks you open.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...