Rule 5: Links to content within the same excel file must point to the right cell reference
Lets say you have an Index Page and you want to link the January cell to the January spreadsheet.
Click the January cell. Right click it and click insert Hyperlink
In the Insert Hyperlink box, click Link to Place in this Document. In text to display, type in January. In type the cell reference, type A1 or which ever cell you want the link to go to. Then in “Select a place” click January.
The link has been formed and now you can click it and the link will take you to the designated sheet.
Rule 6: When inserting a link to another file, the workbook and the linked file must be on a shared network drive or a similar location.
Rule 7: Email address links should have the full name of the person
Just having contact as a name will not tell a reader anything about who they are trying to contact.
A full name has been used. Now students will know who they are contacting with the link.