Register now or log in to join your professional community.
Steps needed to create hyperlink in all cells are:
Click Hyperlink, or you can press Ctrl+K.
On the Insert tab, in the Links group, click Hyperlink.
Under Link to, click Create New Document.
In the Name of newfangled document box, type a name for the new file. Tip To stipulate a location other than the one shown under Full path, you can type the new location preceding the name in the Name of new document box. Or you can click Change to select the location that you want and then click OK.
Under When to edit, click Edit the new document later or Edit the new document now to specify when you want to open the new file for editing.
In the Text to display box, type the text that you want to use to represent the hyperlink.
To display supportive information when you rest the pointer on the hyperlink, click ScreenTip, type the text that you want in the ScreenTip text box, and then click OK.