Excel hyperlinks to other cells in workbook must be relative

B

BarryB00

I've created an Excel spreadsheet with a few hundred hyperlinks to other
cells, spending hours fixing references because they're all !absolute. Now I
find I've left out two columns in different places. If I insert the columns,
the hyperlinks refer to the wrong cell. Is there a way to to fix the
references, such as copy from destination cells (about 33 cells) and paste
hyperlinks into destination cells so the references carry over for all the
cells?
Now, if I select a column of cells and copy, then select the matching
destination and select edit/Paste hyperlink, it still only pastes the
destination of the top cell, and the reference is !absolute.
 

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

Similar Threads

Linking data in MS Word into Excel 5
Excel 97 error copying cell containing 'IF' function and labels 2
Excel help needed: Skipping cell without skipping cell reference 1
Array with many cells from a row but not in order or together 11
Hyperlink to cell within a sheet breaks when cells are sorted 1
indirect referencing cells with hyperlinks brings text not link- any solution? 4
Table Preferred width is changed when pasting 1
Insert Row also adds formulas and moves cursor 2

Top