You have multiple sheets (more than 10) in a workbook. After few sheets,
remaining sheets will start hiding behind the scroll bar as shown in below
picture.
Question is, how will you go to the second sheet from the last for
example?
I see most of the users clicking the sheet navigation buttons (see the arrow marks on extreme left of the picture above) again and again to go through all the sheets.
Or some click on the end buttons to reach ends and click on middle
buttons to go to the desired sheets.
Few smart users also use key board short-cuts; Ctrl+PgUp and Ctrl+PgDn
buttons to navigate through the sheets.
But there is also a little known trick to navigate through all the
sheets and activate the desired sheet in a jiffy. The trick is; just right
clicking on any of the navigation buttons. This action shows a popup list of
the sheet names with a tick mark against current active sheet. You can click on
any sheet name in the list and that sheet will be activated.
