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)

Default number of worksheets

What is the default number of worksheets in Microsoft Excel?
How many worksheets can I have in Microsoft Excel?

The default number of worksheets in a workbook is three (3).
You can have a maximum of two hundred and fifty five worksheets(255) in a workbook (though the same is limited by the available amounot of memory in your computer. Anyway, you cannot have more than 255 worksheets)

Thus, when you create a new file in Microsoft Excel, it would have three worksheets. To change the default number of worksheets when you create a new workbook,

• Goto TOOLS->OPTIONS
  
• Select the GENERAL tab
• Under the SHEETS IN NEW WORKBOOK option, change the number of worksheets you want to have in a new workbook.
• Click OK

The next time you create a new workbook you would have your choice of worksheets.

Note:
If you have changed the default option in Microsoft Excel, for your changes to take effect, you must restart Microsoft Excel.
This does not apply to workbooks already created.