Microsoft Excel 2007 tutorial: show hidden sheet tab


Show hidden sheet tab

XII. Show hidden sheet tab

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:

Excel 2007 navigation buttons

The navigation buttons consist of four buttons: first, previous, next, and last.

- Excel 2007 first button (First button): This button is used to show the first hidden sheet of the workbook.

- Excel 2007 previous button (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.

- Excel 2007 next button (Next button): This button is used to show the next hidden sheet of the workbook.

- Excel 2007 last button (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.

Excel 2007 display 9 sheet tabs

The figure shows the sheet tabs when you restore down the Excel window.

Excel 2007 display 3 sheet tabs

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.

 


Comments





This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages:
C, C++, C#, Java, VB.NET, Python, VBA,PHP & Mysql, SQL, JSP, ASP.NET,HTML, CSS, JQuery, JavaScript and other applications such as MS Excel, MS Access, and MS Word. However, we don't guarantee all things of the web are accurate. If you find any error, please report it then we will take actions to correct it as soon as possible.