Follow the steps below to switch between hyperlinks in Microsoft Excel: Click on Sheet 2, then Right-click the cell where you want to create the hyperlink. Select Link from the context menu.