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

"PCRONE" wrote in message
...
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?