Hyperlink Function on Grouped Sheets

[Shay A]

Hello,
Is it possible to use this function on multiple sheets?
i want to create a link to the "Home" sheet that will be shown on sheets 1-3.

Thanks,
Shay

 

[NARAYANK991]

Hi ,

Why not ?

To enter the function on multiple sheets , do the following :

1. Press CTRL C to copy the formula , from the cell A1 in the Home tab.

2. Select Sheet2.

3. Press the SHIFT key , and keeping it pressed , click on the tab named Sheet3 ; the three sheets Sheet1 , Sheet2 and Sheet3 will be selected.

4. Press the ENTER key ; this enters the copied formula in all 3 tabs' cells A1.

5. Press F2 to enter EDIT mode ; replace the text B1 by the text "Home" , inclusive of the double quotes.

6. Press ENTER.

Narayan

 

[Shay A]

Hi,
In clause no.1, do you mean the "Home tab"or the "Home sheet"?

TY

 

[NARAYANK991]

Hi ,

Sorry , all usages of the word tab refer to the worksheet tab , not the Ribbon tab.

So Home tab refers to the worksheet tab named Home.

Narayan