Thursday, April 3, 2014

Navigating Through Multiple Sheets Made Easy


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.

No comments:

Post a Comment