How do I put more than one hyperlink into one Excell cell? I know there are hard ways; what is the easiest?

tt2,

Are you suggesting that cells (Row X, Col Y) be used for our written analysis, providing citations as needs, etc. and that the links be placed in what you call Header 4 (with a reference that particular text), perhaps a "library" of sorts?

Not sure where to begin to play with the cell merging & moving borders method, but the graphical clarity of what your example looks like is dead on. After a "master template" (may be the wrong word) is created, are there issues that might occur such as in moving major border lines, adding columns, etc?

Is the start of your suggestion, i.e., merge, border hiding (I assume merging border lines to appear as one line), etc. as simply as this (start here and begin to merge cells & hide lines?

Last, some have suggested imbedding text boxes in cells & place active links there. Haven't tried it yet. At the client end, the spreadsheets we work with are in a format provided to use w/little room for change (some cells have drop-down menus, etc.) because once the client receives the spreadsheets, they are put into the company's much larger dB which includes ranges of different subjects than what we track & analyze. I would have to ask the client if placing text boxes within cells is OK, i.e, would that be acceptable in terms of merging into larger dBs. Any thoughts on that?

Graphically, I like your suggested method.

Separate Reality

tt2,

Are you suggesting that cells (Row X, Col Y) be used for our written analysis, providing citations as needs, etc. and that the links be placed in what you call Header 4 (with a reference that particular text), perhaps a "library" of sorts?

Not sure where to begin to play with the cell merging & moving borders method, but the graphical clarity of what your example looks like is dead on. After a "master template" (may be the wrong word) is created, are there issues that might occur such as in moving major border lines, adding columns, etc?

Is the start of your suggestion, i.e., merge, border hiding (I assume merging border lines to appear as one line), etc. as simply as this (start here and begin to merge cells & hide lines?

Last, some have suggested imbedding text boxes and/or objects in cells & place active links there. Haven't tried it yet.

Clients have suggested that adding columns (as needed) to the right & placing a link/box there is acceptable insofar as how our spreadsheets mesh with their larger dB, however, an "text analysis" cell may have many links (10 - 15 & up).

They have also OK'ed embedding objects in cells to add links. I've heard there can be problems with that (but do not know the specifics). Advantage/disadvantages in using "Objects" v. "Test Boxes"?

Graphically, I like your suggested method. It may also address another issue, that being calling out when hyperlinks no longer work, have been replaced by (___), or additional links added to analysis, i.e., Header 4 could also serve as a "Hyperlink Tracking" system. Seems that your Header 4 column might also serve that purpose and w/o expanding the sheet laterally?

Separate Reality

Thanks much. Have not seen nor heard of trying this. Amazes me how many people have...or allege to have solutions. The biggest culprit I think is Excel. There seems to be no lack of people who wish that more than 1link/cell could be put in it, or even a version of Excel that allows >1 link. I have a basic understanding of how Excel works, however, would be nice to have an option to "Increase Cell Hyperlink Options."

I'll try you suggestion. Thanks.

You are SO correct re: other programs not only being more hyperlink friendly but as you point out, table use in Word is great. As I mentioned in my post (I think), the client dictated the Excel format because it fits into a larger corporate dB; they're kind of stuck with it (even though not liking it themselves).

I've read that Word can be embedded into Excel files with more than 1 active hyperlink. I've not taken the time to pursue it because I've gone down so many dead end alleys, inc. paying $$ to "professional IT consultants" (where I knew more than they did and that was BAD!!) that I blew that one off too.

Thoughts on embedding a Word doc in a cell & have working link functionality?

tt2,

Have tried 4 times now to try to reply to your suggestion, ask a couple of questions & included several screenshots of what ours looks like. For reasons I do know now, my message(s) disappear. Perhaps my Enima is not working....again. Will have a word with Bletchley next time I'm in the U.K.

Until I get back to this (sleep time in the U.S.), I assume what you are suggesting is creating a "hybrid" Excel spreadsheet that will perform like the less-than-desirable current one, i.e., can be manipulated, cells added, etc. We do no graphical, accounting nor math in the work we do: all text, much of it our original analysis of certain subjects that are placed in certain cells. We have about 100 cells to populate in about 20 separate spreadsheets; amount of info we have to ID, access, analyze and pretend to understand is rather unbelievable. No cells have active links because if we started doing that, our client would wonder why all of them are not so? No dummies, they know Excel's limitations but if we can do a work around, great.

Your graphical interface is fabulous: the only thing uglier than embedding Word into Excel (which I would not have the faintest idea how to do) is trying to cloak active hyperlinks with "Shapes" and then freak out when you can't quite cover up the link real estate. If a hint of the original white cell background shows, mousing over it defaults to the original link (that's our experience anyway). May the fleas of a thousand camels infest the mustache of someone who suggested we try that.

Tom, you've weighed in on this subject before.....thanks for suggesting I check out MS's community. Did so and found nothing re: this subject, proving that Darwin is alive & well, culling out the recidivist Excel blessed-with-one-hyperlink/cell program. Unbelievable that there is not a simple command such as "Insert more than one hyperlink/cell".

I DID however, find a potentially interesting resource; did not have time to pursue it but both of you might take a look. Two guys developed a resource they call "PUP":

Power Utility Pak for the Mac, Add-in Tools for Excel 2011

Free download. They claim it adds about 60 new commands to Excel & 53 worksheet functions. Didn't have to time to take a look and besides, wouldn't know what I was after except "add hyperlinks" (which they may well have figured out).

They have a drop-down menu of main categories......take a look.

http://www.rondebruin.nl/mac/addins/pupmac.htm

Will be back tomorrow.

Separate Reality

tt2,

Perfect, exactly what we need. Thanks much for taking the time with this.

Separate Reality