Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I drag a hyperlink series to fill instead of copy?
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I drag a hyperlink series to fill instead of copy?
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I drag a hyperlink series to fill instead of copy?
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 "Pete_UK" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want to use a fill series to copy down a pattern of dates. | Excel Discussion (Misc queries) | |||
if you drag the fill handle will it decrement the series | Excel Discussion (Misc queries) | |||
if you drag the fill handle will it decrement the series | Excel Discussion (Misc queries) | |||
Can I create a hyperlink to another page and then FILL series? | Excel Worksheet Functions | |||
excel auto fill needs to be have default action (series,copy...) . | Excel Discussion (Misc queries) |