If your Excel workbook contains a large number of worksheets, you have to scroll through them one tab at a time in order to view the sheet names. This is especially annoying if you use the Vertical or Horizontal to split your worksheet window in half.
There is a quick way however, to display all of your sheet tabs in one window. Simply right-click the scroll buttons on the lower-left corner of the worksheet window to display the Activate dialog. All of the sheets in your workbook are displayed in the window for easy access.
Our Up to Speed guides are now available as downloadable PDF files, directly from this site . Click the Up to Speed Guides tab to see all of our latest ebooks designed to help you to become more productive, faster.