How do I drag a hyperlink series to fill instead of copy?

[PCRONE]

I'm trying to fill (not copy) a series of hyperlinks within MS Excel 2007.
It works with regular formula's but not with hyperlinks. For example:
If I type "=A10" in cell "A1", the cell "A1" now returns the contents of
cell "A10". Now if I drag the corner of cell "A1" down to "A5" it will fill
the series and the content will be displayed for cells "A10 to A15".
That's all good.
Now if I create a hyperlink in Cell "A1" to jump to "A10" it also works
fine. However when I try to drag the series down to A5 as with the above
example, it copies the hyperlink instead of filling the series. Each cell
from A1 to A5 hyperlinks back to A10 instead of A10, A11, A12 etc.

How do I drag a hyperlink to fill a series of cells in a column instead of
copying?

 

[Pete_UK]

Put this formula in A1:

=HYPERLINK("#A"&ROW(A10),"A"&ROW(A10))

It will show A10 and if you click on the cell you will jump to A10. Using
the arrow keys, position the cursor on A1 and copy the formula down into
A2:A5 - it will show A11, A12, A13, A14 etc, and if you click on the cell
that is where you will jump to.

Hope this helps.

Pete

 

[Pete_UK]

I should have added that if you put the 10 inside the quotes, i.e.:

=HYPERLINK("#A10","A10")

it will not increment when you copy or drag it down because it is treated as
text - that is probably how you had it before (although you might not have
put the formula in directly).

Hope this helps.

Pete