exceltoxl.com

Hi there,

 Share on Facebook

After a long gap, around 20 days, again I am back to share some interesting Excel tips which helps to your reporting needs. There are many reasons for why I have not attended to add new posts. Few reasons to make you understand are Addressing the Formulas Crash Course Doubts, Preparing/Adding New Videos, Relocated from Bangalore to Gudibanda, Birthday Bash, United AndhraPradesh Protests since 50+ days, Getting new Internet connection, Setting up the space for my system to start my new life (for next six months) in my native with parents and many took me these many days.

...

However, I have few interesting topics for you every day from today till the end of this month. Today, let me share how to "Navigate Excel Sheets" in a workbook. The challenge here is when we have more number of sheets in an Excel workbook which cannot be fit into the navigation bar. Below is the pic for your understanding.

HOW TO NAVIGATE WORKSHEETS?

Here we have 10 worksheets but we are able to see only four (4) sheets. This is because the scroll bar is hiding the rest of the worksheets. To see all the existing worksheets in the workbook using simple and easy way is to right click on any of the arrows next to sheet names (Sheet 1 , Sheet 2, Sheet 3, etc.,) using mouse and navigate the sheets. Magic Works!

This is how we can navigate all the worksheets in just one click.

DID YOU USE NAVIGATION BAR?

Have you used navigation bar in your work. Did you find different ways apart from this? Use this space to share your ideas and achievements using below comment section.

Do you find this topic interesting, then please do Register Here for free to encourage me for maintaining this blog and to receive latest updates through exceltoxl.com via e-mail.

SOME IMPORTANT LINKS:

Best Double Click Tricks using Mouse

Be Simple and Be Strong Like IFERROR

Convert Simple Range to Dynamic Range

Thanks