When you insert many sheets into a workbook, you are actually difficult to see all sheet tabs (names) because Excel 2007 cannot show all sheet tabs in the workbook; some sheet tabs are hidden. However, you can use the navigation buttons to show the hidden sheet tabs. Excel 2007 displays the navigation buttons on the left of the workbook's sheets. See the figure:
The navigation buttons consist of four buttons: first, previous, next, and last.
- (First button): This button is used to show the first hidden sheet of the workbook.
- (Previous button): This button is used to show the previous hidden sheet ( previous sheet: the sheet is on the left of next sheet) of the workbook.
- (Next button): This button is used to show the next hidden sheet of the workbook.
- (Last button): This button is used to show the last hidden sheet of the workbook.
The example workbook below contains 13 sheet tabs. But some sheet tabs you cannot see because they are hidden; there are only 9 sheet tabs you can see even though you maximize the Excel window. If you restore down the Excel window, you can see the sheet tab less than 9 sheets.
The figure shows the sheet tabs when you open Excel 2007 in full screen.
The figure shows the sheet tabs when you restore down the Excel window.
Therefore, you need to use the navigation buttons to show hidden sheet tabs. If you want to see the first hidden sheet tab, click the first navigation button. If you want to see the previous, next or last hidden sheet tab, click the previous, next or last navigation button.
This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages: