Worksheet navigation

How to navigate through worksheets?

In case you have lesser number of worksheets, say 4 or 5, you can easily navigate through them by clicking the sheet tab. In case you have a large number of worksheets, say 10 or more, you can use the worksheet navigation tab.



The above bar is located on the top left of the sheet tabs. Right click on the sheet tab to display the list of all worksheets. The worksheet navigation tab has four buttons. The first button takes you to the first worksheet and the last button to the last worksheet (similar to the Home and end key). The second button takes you to the next worksheet and the third button the the previous worksheet.

It is advised not to keep too many worksheets in a workbook, unless it is absolutely necessary, since they may result in navigation problems (not for the computer)