Activating a worksheet

[Guest]

Hello

Here'a my questions:

I'm opening Workbook A.xls and activate worksheet #
the
I'm opening Workbook B.xls and activate worksheet #
the
I'm opening Workbook C.Xls and activate worksheet #
How do I get back to Workbook A.xls and re-activate worksheet # 1
How do I get back to Workbook B.xls and re-activate worksheet # 1
et
Thanks

 

[Doug Kanter]

I'm assuming you are trying to navigate between workbooks using either a
mouse or the keyboard. Based on that assumption, click on every menu choice
you see in Excel. Within 10 seconds, you will have your answer. It will be
one of several ways of achieving your goal.

Hint: Houses have them, but most people use the door to enter or exit.

 

[Dave Peterson]

You can go through the worksheet menubar:
Window|and select the workbook you want

Or you can cycle through the open workbook with a couple of shortcut keys:

Ctrl-f6
ctrl-shift-f6
or
ctrl-tab
ctrl-shift-tab

(and you can use ctrl-pgup & ctrl-pgdn to cycle through the worksheets of the
activeworkbook.)