Let’s take a look.
In this case, we can see that we’re in a workbook called Forecast 2013.
The current worksheet is always the tab that’s highlighted at the bottom.
Control page-up moves left in the worksheet tabs, control page-down moves right.
When you move to a new worksheet, you may or may not be able to see the cursor.
However, Excel will always display the current location of the cursor as an address in the name box.
This address is called the active cell.
In this case the cursor is on cell E100, which is not visible on the screen.
Another way to bring the cursor into view is to press an arrow key.
To move to another workbook, just select it in the menu.
Note that the window title will change to display the new workbook name.
it’s possible for you to move between open workbooks using the keyboard shortcut control-tab.
Control tab will cycle through all open workbooks.
Add the shift key to move the other direction.