Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

In Word I can use Ctrl+Click on the rare occasion that I want to follow a link rather than, you know, do the editing that Word is actually for.

Is there some way to get similar behaviour in Excel 2010, 2003, 2013?

I am sick of accidentally switching to IE or Outlook every time I try and select a cell that has a hyperlink attached.

Results of my prior research here on SuperUser and via popular search engines have not been very fruitful (e.g. http://blogs.office.com/b/microsoft-excel/archive/2011/04/12/hyperlinks-in-excel-hot-or-not.aspx) I am not interested in hearing how I can click and hold to select the cell, or run VBscript or Macros to strip all hyperlinks from a workbook. I want something that conforms with the UI I expect from a non browser application and applies to documents other people have created.

share|improve this question
1  
We are interested in what you have researched and tried already. Also, what version of Excel are you using? –  CharlieRB May 14 '13 at 12:47
    
I've Googled and searched on SuperUser and come up with plenty of suggestions for how you can click and hold, create VBscripts or Macros to strip hyperlinks, but so far nothing about making Excel behave like Word. To be honest I thought that would be obvious from the question. I'm running Excel 2010, but is potentially annoying for anyone running Excel 2003, 2007, 2010, and possibly 2013. –  dunxd May 14 '13 at 14:06
    
We may be super users, but not not super mind readers. Details help us help you. You've done a good job of explaining what you expect for answers. Only problem I see is there aren't any settings which make Excel act like Word. The behavior you've described has been part of Excel for many versions, so I don't expect it to change any time soon. From what I've researched, and given your criteria, you don't have many options, except maybe turning off automatic hyperlinks. –  CharlieRB May 14 '13 at 16:35
    
That there isn't a setting would be a valid answer. Turning off automatic hyperlinks would work for all documents I create, but not for any created by other people who haven't also turned this off. If you know for certain that there isn't UI to turn this off, then say so, Otherwise, please don't deter other people from answering by criticising the question. –  dunxd Dec 9 '13 at 13:11
4  
I echo the original poster's request. I want to be able to create a spreadsheet with hyperlinks in it, but I don't want to FOLLOW said hyperlinks every time I merely click on the cell. I want an option (like in Word) where you can ctrl-click the link and THEN it follows it, and not just clicking on the cell (and not even on the link) and it following. –  Kevin Anderson Dec 17 '13 at 18:04

5 Answers 5

Refer to Microsoft's website:

  • To remove a hyperlink and the text that represents it, right-click the cell that contains the hyperlink, and click Clear Contents on the shortcut menu.
  • To remove a hyperlink and the graphic that represents it, hold down CTRL and click the graphic, and then press DELETE.

If you are looking to disable a hyperlink for a single cell, here is the solution:

  • Right-click the hyperlink you want to deactivate, and then click Remove Hyperlink on the shortcut menu.
share|improve this answer
3  
The user said he doesn't want to remove the links, just the way that the program UI deals with them. This does not answer the question. –  ilinamorato Mar 19 at 15:05

How I do this: Set the hyperlink with the URL in the second portion:

=HYPERLINK("","http://example.com")

In the VBA Editor make a module:

Declare Function GetKeyState Lib "User32" (ByVal vKey As Integer) As Integer
Global Const CTRL_KEY = 17

Then the worksheet code:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    On Error GoTo Error1
    If Left(Target.Formula, 10) = "=HYPERLINK" Then
        If GetKeyState(CTRL_KEY) < 0 Then 'Check if CTRL is held in
            Application.EnableEvents = False
            ThisWorkbook.FollowHyperlink Mid(Target.Formula, 16, Len(Target.Formula) - 17)
            Application.EnableEvents = True
        End If
    End If

    Exit Sub

Error1:
    Application.EnableEvents = True

End Sub

To make it work, click on the cell, then CTRL+Click on the cell to visit the link. You could do other things like have text in the second portion of HYPERLINK then a SELECT CASE in the code, that opens a url based on the text. Other keystrokes are available as well:

Global Const SHIFT_KEY = 16
Global Const ALT_KEY = 18

http://msdn.microsoft.com/en-us/library/aa243025(v=vs.60).aspx

share|improve this answer

Try this:

  • Select the entire sheet, copy
  • Open new workbook, right click any cell, paste options, paste values

This will give you a new sheet with none of the old formatting, including all hyperlinks removed.

share|improve this answer

I don't know if this is a workaround or an answer, but just make the width of your hyperlink column wider than the hyperlink text.

When you want to select the cell just click anywhere in the whitespace to the right of the link.

Alternately, by increasing the height of rows and clicking in the whitespace above (or below, depending on your alignment settings) the link you get the same effect - but with a metro looking interface :-)

Checked (and working) with Excel 2010.

share|improve this answer
    
-1 in excel 2010 this opens the hyperlink anyway –  Chris Marisic Aug 4 at 13:37
    
No it doesn't. You did it wrong. –  mcalex Aug 6 at 1:21
    
i can tell the difference between text and whitespace where i'm clicking –  Chris Marisic Aug 6 at 12:59

There are a few ways to do this:

  • One way (which is valid but I don't recommend) is to put a ' (single quote) as the very first character of a cell. This tells Excel "do not format this cell even if it's a hyperlink or formula". I use this if I need to have a formula as a reference for documentation purposes. I don't recommend it because you want to disable the auto-link creation feature. This works on any version of Excel, even Mac.

To disable auto-link creation:

Excel versions 2003 and up

  1. On the Tools menu, click Autocorrect Options.
  2. On the Autoformat As You Type tab, click to clear the Internet and network paths with hyperlinks check box.
  3. Click OK.

    • Note You can also gain access to the Autocorrect Options feature when you type a hyperlink and then click Stop Automatically Creating Hyperlinks on the smart tag button that appears.
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.