| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hyperlink does not adjust or move as rows are added and deleted
I have an excel worksheet.
Sheet one acts as a table of contents. Sheet two contains 8,000 rows of part numbers I have set hyperlinks from sheet one to sheet two. In sheet one you click on a prodcut category and it takes you to the start of that section on sheet two. As I add rows or delete rows in sheet two the hyperlink remains constant and does not move. Thus the hyperlinks becomes inaccurate. How do I make the hyperlink move/flaot with the cell as I add and delete rows to sheet two. My cell links for information flaot/automatically adjust just fine. Its just the hyperlinks which never adjust. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Links do move when a row is added | Excel Discussion (Misc queries) | |||
| Moving rows with Hyperlink doesn't move hyperlink address | Excel Discussion (Misc queries) | |||
| Hyperlink added to an activex control button | Excel Discussion (Misc queries) | |||
| automatically adjust numbers in a column when data is deleted | Excel Worksheet Functions | |||
| How do I keep a formula from changing if a row is added or deleted | Excel Discussion (Misc queries) | |||
Threaded Mode
