Hyperlink using name definitions in Excel

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).

高橋