EXCEL HYPERLINK function on the problem in
[Users questions | Browse:42 | 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?
Experts answer: the following formula: = HYPERLINK ("# Sheet1! A "& ROW (A1) &": K "& ROW (A1 )&""," by the Table A" & ROW (A1) & ": K" & ROW (A1) & "come")
Experts answer: the following formula: = HYPERLINK ("# Sheet1! A "& ROW (A1) &": K "& ROW (A1 )&""," by the Table A" & ROW (A1) & ": K" & ROW (A1) & "come")
- There are several new methods of presentation, simply out of.
- What word in how to increase the special symbols
- excel how to filter and distinguish between the number of consecutive
- How will the characters in the cell and breakdown of figures show?
- How to set excel in the integer "0" format
- How to convert PDF text editable word or TXT
- How could such a problem?
- Help explain, EXCEL function of usage, there are accessories.
- Why not let me see My Network Places?
- EXCEL delivery table and more, how do
- This information provided by the users.Thanks!
Computer Knowledge Copyright 2005-2015 All Rights Reserved.