An Index or a Contents sheet are required for Excel files that have multiple tabs.
The techniques covered in this session can also be applied to Instruction sheets and other sheets to improve the general navigation around your Excel files.
Includes a custom function that displays the sheet name.
Six techniques are covered
- Manual hyperlinks
- Using cell links to navigate
- Applying the HYPERLINK function
- Using range names (including an unbreakable hyperlink)
- Macros
- Using an old Excel macro plus new dynamic arrays
As always lots of shortcuts will be shared along the way.