Hyperlink using name definitions in Excel
Hyperlinks using name definitions in Excel.
See the following illustration. Click on “Define Names.”
Click to open the following screen.
Enter “aiueo” as appropriate for the name and press “OK”.
If you look at the upper left corner, “I3” has changed to “aiyueo”.
Next, place the cursor on “M3” and press “Hyperlink”.
The following screen will open
aiueo” is displayed in “Defined Names”. Select “aiueo” and press “OK.
Then a hyperlink will be created in “M3” with “aiueo”.
Click on “aiueo” to go to “I3” (aiueo).
コメント