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


P

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?
 
Ad

Advertisements

P

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
 
Ad

Advertisements

P

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top