Do want to add a hyperlink to another sheet in excel? Well, there are several ways in which you can create a hyperlink in excel. In today’s discussion, we will look into how to create a hyperlink in excel that will navigate you to another sheet of the same excel file.
- Using Link Option
- Using Link Button in Header
- Hyperlink to Defined Names
- Hyperlink Using Formula
- Modify the Hyperlink
Step to Add Hyperlink to Another Sheet in Excel:
As you can see in the image below we have four sheets in the Book1 excel file namely Sheet1, Weekly_Sale, Regional_Sale, Price_Table. On Sheet1 we will be hyperlinking three cells B2, B3 and B4 to sheets Weekly_Sale, Regional_Sale, Price_Table respectively.
Method 1: Using Link Option
Step 1: Right-click on the cell to which to add hyperlink and from the displayed menu click on ‘Link’.
Step 2: An Insert Hyperlink dialog box will pop up where you have to click on “Place in This Document” in the navigation panel on the left-hand side. This is because we need to add hyperlinks to another sheet in the same excel file.
Next on the Right-hand side of the workspace, in the “Text to display” field you have to enter the text that will appear as a clickable hyperlink.
In the “Type the cell reference” field you have to enter the cell reference of that another sheet where the hyperlink must land.
In the Cell Reference section, you can see the number of sheets in this excel file so can select another sheet where the hyperlink must navigate you. And now click on OK.
In this example, I have selected the Weekly_Sales sheet. So, whenever I will click on Weekly Sales in cell B2 of Sheet1 it will navigate me to cell A1 of the Weekly_Sales sheet of the same excel file.
Method 2: Using Link Button in Header
Let’s say we need to add a hyperlink to Regional Sales text in cell B3 that must navigate to the Regional_Sales sheet of the same excel file.
Step 1: Click on the Regional Sales in cell B3. Now go to Insert>Links and click on the Link button.
Step 2: Again, an Insert Hyperlink dialog box will pop up. Now select the sheet Regional_Sales in the Cell Reference. And now click on OK.
So, whenever I will click on Regional Sales in cell B3 of Sheet1 it will navigate me to cell A1 of the Regional_Sales sheet of the same excel file.
Method 3: Hyperlink to Defined Names
Here we will add a hyperlink to the text Price Table in cell B4 of Sheet1 that must navigate us to the defined name Fruit_Rate that occurs in the Price_Table sheet.
Step 1: Go to the Price_Table sheet and select the cell range. And in the name box at the top left side define a name for this cell range. I have defined the selected cell range as Fruit_Price.
Step 2: Select the text Price Table in cell B4 of Sheet1. We will be creating the hyperlink of the text Price Table.
Step 3: Now to get the Insert Hyperlink dialog box we have a shortcut, press Ctrl+K.
Step 4: In the Insert Hyperlink dialog box under the Cell Reference>Defined Names, click on Fruit_Price.
Method 4: Hyperlink Using Formula
Step 1: Click a cell in the sheet where you want to create a hyperlink. Start writing the formula:
- link_location is the place in the document (a specific cell in the excel sheet or a defined name) where the created link must land.
- friendly_name is the name that we have given to the hyperlink that we have created. It can be a value, a text string, or even a cell containing the jump value.
Here the formula HYPERLINK will become:
=HYPERLINK(“#Price_Table!A1”, “Price Table”);
This formula will create a hyperlink with the jump text Price Table which when clicked will land you to the cell A1 of the Price_Table sheet of the same excel file.
The number sign (#) indicates that the sheet belongs to the same excel file.
Modify the Hyperlink
By default, when you create any hyperlink its font is underlined in Calibri (Body) with font size 11 and the colour of the font is blue. If you feel you can modify the appearance of Hyperlink text.
Click on the cell with hyperlink. Go to the Home tab and in the Styles group, click on the Cell Styles. From the provided option right click on the Hyperlink.
Now again from the provided option click on Modify.
A Style window will pop up, where you to click on the Format button.
Here I have changed the font size to 14 and the font colour to red. You can change as per your choice.
Repeat the same for the Followed Hyperlink.
Here I have changed the format of the text of Followed Hyperlink. The font size of Followed Hyperlink is changed to 40 and the font colour is changed to green.
Thus the hyperlink appears in red colour and the followed hyperlink appears in green colour.
So, these are the ways in which you can add hyperlinks to another sheet in Excel.