Have you ever had the pleasure (or displeasure) of working with an extra large Excel workbook with many, many different sheets? This happens frequently, especially if you are working with a large amount of data that needs to be analyzed periodically. This may be due to multiple tables, lookups, references, charts, graphs etc. This has the tendency to have you create many different sheets—each one having its own specific function and purpose. You may notice however, that as the data grows, the number of sheets increases—forcing you to have to scroll through the list of tabs to get to the specific sheet desired. But what if business is so good that you now have around 10, 20 or more sheets? Having to scroll back and forth through the tabs to get to each sheet to verify and hence analyze information would be a nightmare. This is where a linked dashboard (or a landing page) comes in handy, and is a very quick fix for this quandary. This has the effect of taking you to the desired sheet by just one click of a button and back to the dashboard with another.
Let's get started: What I have here is a workbook with multiple sheets consisting of tables, charts, graphs, raw data etc. Each sheet in the workbook serves its purpose. I would like to access the information in each workbook without having to scroll through the tabs at the bottom of the workbook all the time.
Notice the tabs at the bottom of the page denoting each sheet (this can get quite bothersome as they increase in number): So how do we accomplish this?
I have created a very simple, but effective, landing page called "Dashboard" and added the names of sheets I would like to link to. For best practices, it is often handy to name them after the tabs they are going to point to. Hence, I have named them after the tabs in the workbook respectively.
We are going to start by inserting a link for the "Home" worksheet (not to be confused with the landing page). This is how we do this:
When clicking on the "Home" link, it takes me to the sheet labeled "Home", which you can customise as you see fit.
Do this for the rest of the sheets you would like your dashboard to link to. Points to ponder:
Hopefully this should help save you time and limit the needless scrolling when working with multiple sheets in one workbook.