EXCEL HYPERLINK function of depth in
[Users questions | Browse:283 | Favorites]
Users questions: In the same workbook, there are two worksheets, I need a second worksheet in a cell to enter a formula, such as "HYPERLINK (" # Sheet1! A1: K1 "," Table-A1 to K1 come "), enter the formula after the hyperlink function can be achieved, but The problem is that I enter the formula in Table II of this cell down one cell also need to enter the same formula, but the difference is the table area to become one of the A2 to K2, ie = "HYPERLINK (" # Sheet1 ! A2: K2 "," Table A2 to K2 by the come ") to And so forth, I passed the first two drop-down list cell enter the formula, find links to the area has not changed, or the Table of A1 to K1 in this area, there is no good way to achieve regional bulk hyperlink ah? Your answer is: the following formula: = HYPERLINK ("# Sheet 1! A "& ROW (A1) &": K "& ROW (A1 )&""," by the Table A" & ROW (A1) & ": K" & ROW (A1) & "come") I saw a rough about, some half-comprehended, can explain the details, mainly to talk about "& ROW (A1) & "This part, in fact," & ROW (A1) "a little bit to understand, but why adding a & it? Want to let us know! Since the" & ROW (A1) & "as a whole to understand, then this part of the final result is 1 (1 as text format), is now asking the role & is connected, "" is Number 1 into the text, then & there before and after the number 1 mean ah? Some want to understand more thoroughly! Mainly behind this part of the K, is not into misunderstanding it? Thank you and pleasant it! Want to continue to answer! The more detailed the more welcome!
Experts answer: "plus a &" is the change (ROW ( A1)) and constant (: K) together. "& ROW (A1) &" as a whole to understand, and convert them to text.
Experts answer: "plus a &" is the change (ROW ( A1)) and constant (: K) together. "& ROW (A1) &" as a whole to understand, and convert them to text.
- operationsystemnotfound
- How to change XPGHOST CD inside the content?
- Blue screen problems
- WINDOWS permanently activated, you on behalf of genuine
- windows7 the img file to install
- What depth of XP, DOS installation method
- windows startup items in liunx
- The problem with UltraISO installed windows7
- How to adjust the virtual memory
- After booting, the keyboard can not be used to windowsxp.
- This information provided by the users.Thanks!
Computer Knowledge Copyright 2005-2015 All Rights Reserved.