NOBLE SOFTWARE SOLUTIONS - WE MAKE IT CLICK!

Moving to a Different Sheet Tab Within the Same Workbook

By Laura Noble

Moving to a different sheet tab in Excel is relatively easy when there are only a few sheets but when there are numerous sheets and some appear "hidden" behind the scroll bar (as shown in the sample below), it can be cumbersome moving from sheet to sheet.

Solution:

  1. Right-mouse click in the middle of the Tab Scroll Bar (bottom left of screen, as shown in the sample above).
     

  2. A list of all sheets in workbook will open as shown in the sample below. The sheet name with a checkmark is the active sheet.

    In the sample below the active sheet is June.
     

  3. Left-click on a sheet name from the list and that clicked sheet will be the active sheet.

    Clicking on Totals from the list, in the sample below, would move cursor automatically to that sheet, making it the active sheet.

©Noble Software Solutions - www.NobleSoftwareSolutions.com - 519-680-2689

Home    Why NSS?    Tips & Tricks   Overview    Course Topics    Contact NSS   Training Rates  Media Room  Privacy

Copyright 2000-2008. Noble Software Solutions, London, Ontario, Canada. All Rights Reserved.

Logo Designed by Elly Fox Graphic Designer