How to insert hyperlink in a workbook against sheet names

[AFZAL SOHAIL]

Dear Team,
Kindly guide me how to insert hyperlink in a workbook against sheet names in excel.
Thanks in advance.

 

[SanjayGMusafir]

I think one of the ways can be to hyperlink to any cell say "A1" on the sheet you want to hyperlink to...

 

[AFZAL SOHAIL]

I think one of the ways can be to hyperlink to any cell say "A1" on the sheet you want to hyperlink to...

Sir, it is not complete information please.

 

[SanjayGMusafir]

Sir, it is not complete information please.

what else you want to know. I would help if I can...

 

[AFZAL SOHAIL]

Dear Team,
I need help how to insert hyperlink in excel sheet against sheet names.

 

[offthelip]

Your question is not clear what do you want to happen when you click the link?

 

[AFZAL SOHAIL]

Sir,
I want to know how insert the hyperlink in a sheet, against sheet names:-
e,g.
1. sheet name1 ---hyperlink to jump the certain sheet

 

[offthelip]

post 2 from SanjayGMusafir is correct, that is all you need to do : in detail
Right click on the cell where you want the link, select Hyperlink, select "place in this document" and select the sheet you want to jump to, it defaults to putting cell A1 in, but any cell will do.

​

 

[SanjayGMusafir]

This is how we do... Hope this helps...

 

[AFZAL SOHAIL]

Thank you, but i need hyperlink formula