Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How can we Hyperlink all worksheets in the first sheet?

user-image
Question added by Imad Gul , Web Developer , Amana Advertising
Date Posted: 2017/05/29
md saood manzar
by md saood manzar , Lab Researcher Air Pollution Lab , university of dammam

Steps needed to create hyperlink in all cells are:

 

  1. Click Hyperlink, or you can press Ctrl+K.

  2. On the Insert tab, in the Links group, click Hyperlink.

  3. Under Link to, click Create New Document.

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

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

  6. In the Text to display box, type the text that you want to use to represent the hyperlink.

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

 

More Questions Like This