Accessing a specific worksheet in large workbooks with multiple worksheets
How to access a specific worksheet in a large workbook with multiple worksheets.
Today we’ll learn how to quickly access a worksheet in a large workbook with multiple worksheets that are not visible to the user and save time without having to scroll left and right!
Here we have an example of a workbook with a large number of worksheets. To view a specific worksheet we would have to click on the navigation arrows left to the worksheets and click on the left navigation arrow to go to the left one by one or click on the right navigation arrow to go to the right step by step. Of course, we can go to the first worksheet by clicking on the first navigation arrow >| or we could go to the last worksheet by clicking on the right navigation arrow >|.
The process of scrolling left or right step by step can be cumbersome if you have hundreds of worksheets.
What is a better solution to access a specific worksheet quickly? Right click on the navigation arrows and you can view many worksheet names immediately. If you don’t find the worksheet you are looking for immediately click on ‘More worksheets…’ and a new window called ‘Activate’ will pop up and you can quickly find the worksheet you are looking for by scrolling up or down and click on it to select it, click OK and activate it.
We have selected the worksheet Total Income in this manner and activated it.
Of course you can write a macro or Excel VBA code to access a specific file. The process can be quite tedious and anyway you’ll have to create a list of all worksheets with their names. Using this list in a macro you would then be able to access a specific sheet.