hi,
a workbook i am using has 40+ plus tabs. whats the quickest way of scrolling through these (finding the one you want) without manually flicking through each one sequentially.
hi,
a workbook i am using has 40+ plus tabs. whats the quickest way of scrolling through these (finding the one you want) without manually flicking through each one sequentially.
Try (from a Google search!)
The easiest way to jump sheets is to display a pop-up list of sheet names by right-clicking the sheet tabs navigation bar (the one with arrows) to the left of the sheet tabs that are located at the bottom of the worksheet window. Select a sheet from the list, and you're there in a flash.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Not an answer to your question, but why use 40 tabs at all.
1 worksheet with all data makes it a lot easier to analyse the data.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
perfect - thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks