Navigation of sheets

[Bruce Roberson]

If I have two or more workbooks open at the same time in
Excel 2000, how do I navigate between them without
selecting Window, and the particular workbook I want.

I thought there was a setting at one point that caused the
workbook icons to be minimized above the start button, and
you would just click those when you wanted to activate the
next one. But it isn't displaying that way now, and I
don't know what I did to mess that up.

In QPW, I would also click shift + F6 to naviagate between
workbooks.

 

[Michael J. Malinsky]

One option is to press Ctrl+Tab. This will cycle through all of the
workbooks much like Alt+Tab cycles through all open windows.

Not sure if this is in option in XL2000, but it is in XP...Select
Tools>Options. Under the View tab, make sure the Windows in Taskbar box is
checked. This will cause each open spreadsheet to have its own button in
the taskbar so you can easily choose which workbook you want to use.

 

[Gord Dibben]

Bruce

CRTL + F6 cycles through open workbooks.

Tools>Options>View "Windows in Taskbar" will place open windows on your
taskbar.

Gord Dibben Excel MVP - XL97 SR2 & XL2002