In this tutorial I plan to show you how to create a cover page/table of contents for your Excel sheets. i.e. how to create hyperlinks to jump to another worksheet in your workbook.

I’m going to look at two options. In the first one – we are just going to use text and in the second we are going to create a shape and create  a hyperlink from that.

[flowplayer src=’https://s3-eu-west-1.amazonaws.com/the-excel-expert/creating_a_hyperlink.mp4′]

 

here is the file for you to practise on: Hyperlinks_demo

You can also quickly remove the hyperlink by right clicking on the text or shape and choosing  Remove Hyperlink

 

Also if you are in the mood to upgrade your skills – check out some of the resources here.