Earlier this week I was asked a question that I’d like to share with you.  The question was to do with Microsoft Excel and navigation in a workbook that has dozens of worksheets. 

“Is there an easy way to get to a named tab rather than having to scroll through the many tabs going backwards and forwards?”

If you're already using the arrow buttons to the left of the sheet tabs to skip one by one or to the end and start of the sheets, you may like this quick tip.

• Hold your CTRL + left click on the arrow buttons to the left of the sheet tabs to skip to the last worksheet. 

But even better than that, I hope you're going to love my favourite tip to reveal a list of your sheets.

• Right-click on the arrow buttons to the left of the sheet tabs to view a list of the sheets.  Double-click to select the sheet. 

If you're willing to give macros a try, you could add a button to the main worksheets so you can jump to it in a click.  See this tip to walk you through how. How to Create an Excel Macro Button