If you have a workbook with many sheets it can be cumbersome to use the previous and next navigation buttons to find the particular sheet you want. A more expedient method is to list each spreadsheet in the book so that you can select the one you want.
- Right-click any tab in your workbook and select Display from the shortcut menu.
From the menu select Spread | Book | Display.The Sheets in Book field lists all the spreadsheets in your book.
The Columns in selected sheet field shows a preview of the columns in the current sheet and is for information only.
- Select the sheet you want to bring to the front then click OK.