Steve_Brady
asked on
Understanding the syntax in =HYPERLINK() in Excel
Hello,
I am struggling with the syntax for using the function: =HYPERLINK() in Excel (2007). In the help file, it shows the syntax for this function as:
=HYPERLINK(link_location,f riendly_na me)
However, I have a hunch that my struggles have more to do with designating Excel folders, workbooks (files), worksheets (tabs), and cell references than it does with the actual syntax. The following template has been useful in several links I have created in the past:
=HYPERLINK("[C:\Users\User Name\Docum ents\UserF older\User FileName.x lsx]'Sheet Tab'!A1"," CellDispla yText")
However, at other times I have not been able to get it to work. One thing that would help me immensely is if someone could explain a few of the components in this template if it is dissected. For example, the beginning and end:
=HYPERLINK(
and
,"CellDisplayText")
are straightforward and if eliminated from the help file example above, leave only the "...link_location...," in this case, represented by:
"[C:\Users\UserName\Docume nts\UserFo lder\UserF ileName.xl sx]'SheetT ab'!A1"
which can be abbreviated as:
"[C:\...\File.xlsx]'SheetT ab'!A1"
or
"[Pathway]'SheetTab'!A1"
Now, my first question is: What is the purpose of the quotation marks and brackets:
"[...............]........ .......... ......"
and why are they adjacent to each other in the beginning but separated (by the sheet tab and cell reference) at the end?
The next question is: What is the purpose of the apostrophes:
'..........'
on either side of the SheetTab?
Finally, what is the role of the exclamation mark:
......!......
between the sheet tab and the cell reference? Is it a modifier for the preceding SheetTab or for the cell reference which follows?
Thanks
PS I have a more specific follow-up question but I will ask that in another thread.
I am struggling with the syntax for using the function: =HYPERLINK() in Excel (2007). In the help file, it shows the syntax for this function as:
=HYPERLINK(link_location,f
However, I have a hunch that my struggles have more to do with designating Excel folders, workbooks (files), worksheets (tabs), and cell references than it does with the actual syntax. The following template has been useful in several links I have created in the past:
=HYPERLINK("[C:\Users\User
However, at other times I have not been able to get it to work. One thing that would help me immensely is if someone could explain a few of the components in this template if it is dissected. For example, the beginning and end:
=HYPERLINK(
and
,"CellDisplayText")
are straightforward and if eliminated from the help file example above, leave only the "...link_location...," in this case, represented by:
"[C:\Users\UserName\Docume
which can be abbreviated as:
"[C:\...\File.xlsx]'SheetT
or
"[Pathway]'SheetTab'!A1"
Now, my first question is: What is the purpose of the quotation marks and brackets:
"[...............]........
and why are they adjacent to each other in the beginning but separated (by the sheet tab and cell reference) at the end?
The next question is: What is the purpose of the apostrophes:
'..........'
on either side of the SheetTab?
Finally, what is the role of the exclamation mark:
......!......
between the sheet tab and the cell reference? Is it a modifier for the preceding SheetTab or for the cell reference which follows?
Thanks
PS I have a more specific follow-up question but I will ask that in another thread.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER