1
vote
1answer
132 views

Excel, Pasting text with hyperlinks, conditional formatting for doubles

I have a list of names that I paste, individually, from a site into a column of cells in a table. I have conditional formatting to tell me if there are doubles. However, when I copy straight from ...
0
votes
2answers
4k views

Excel 2007 - Hyperlink Text Within A Cell

Is it possible to insert a hyperlink which affects text within a cell? For example: ----------------- | See this link | <-- Only the word "link" should be highlighted here. ----------------- ...
1
vote
1answer
576 views

Open Excel files from Hyperlink in new window

Much like this question but I want to be able to insert a Hyperlink into one sheet that opens another sheet in a new window. P.S. Using Excel 2007
13
votes
14answers
81k views

How to easily remove hyperlinks from multiple cells?

I have data exported from a tool as XLS. In this, one of the column has text which is a hyperlink to information in the tool. I can remove the hyperlink for each cell. But I want to remove the ...
2
votes
1answer
1k views

Hyperlink in Excel

I am using MS Excel 2007 (previously familiar with Excel 2003). I create a simple hyperlink in cell A1 (in sheet Sheet1) so when I click cell A1, the cursor moves to cell B10. It's very easy, no ...
4
votes
4answers
48k views

Hyperlink to other worksheet using hyperlink function in excel

I'm having problems using the Hyperlink function of Excel. I have a name in cell A1, In cell a2 I want a hyperlink that links to the worksheet that is named the same as the name in cell A1