Edit the hyperlink by adding Go to BLS website as a ScreenTip on excel
To add a ScreenTip to a hyperlink in Excel, please follow these steps:
1. Select the cell that contains the hyperlink.
2. Right-click on the selected cell and choose "Hyperlink" from the context menu.
3. In the "Insert Hyperlink" dialog box, enter the URL of the BLS website in the "Address" field.
4. Then, click on the "ScreenTip" button.
5. In the "Set Hyperlink ScreenTip" dialog box, enter "Go to BLS website" (or any desired text) as the ScreenTip.
6. Click "OK" to apply the changes.
7. Finally, click "OK" again in the "Insert Hyperlink" dialog box to close it.
Now, when someone hovers over the hyperlink cell, they will see the ScreenTip "Go to BLS website" displayed as a tooltip.