4 Suitable Methods to Create Hyperlink to Another Sheet Based on Cell Value in Excel 1 Create Hyperlink Based on Cell Value from the Context Menu in Excel In the following table, we have a list of successive month names starting from January 21 Now let's say, we want to create hyperlinks for all months under the Sales Report headerTo get the name of the current worksheet (ie current tab) you can use a formula based on the CELL functionCELL retrieves the workbook name and sheet, and the MID and FIND functions are used to extract just the sheet name In the example shown, the formula in E5 isExcel Details Note that once we click a cell in Week1, Excel shows the sheet name in the formula along with the cell address Sheet names always appear with an exclamation point at the end, before the cell referenceTo complete the formula, there's no need to go back to the original sheet Just press Enter
Insert And Name Sheets From Cell Values Excel University