We are big fans of using Hyperlinks when navigating through large spreadsheets. One of the big problems is creating the hyperlinks. It is easy enough to create but very manual. So below in our Excel training file, the front page has hyperlinks to all the underlying examples. This would take hours to do if we had to do it manually.
As a result we recommend you look at this link to see some code that creates a reusable macro that you can run on a workbook. It will, on the sheet you are on, create a hyperlink to every other sheet in the spreadsheet. We tend to then move them around (Cut/ Paste) to use a few columns instead of one long column.
Create a navigation list with Hyperlinks (opens in a new window)
Want to learn more about Microsoft Excel? If you prefer attending a course and live in South Africa look at the Johannesburg MS Excel 3 Day Advanced Course or the Cape Town MS Excel 3 Day Advanced training course. If you prefer online learning or live outside South Africa, look at our online MS Excel training courses.