Hot answers tagged

22

The URL you're using needs some more information from a cookie to display the search results rather than the search page. Paste the URL into a different browser (or remove your cookies) and you'll get the same results. Clicking a URL in Excel seems to open it in your default browser. But that's not really true. Before opening it in your browser, Excel first ...


19

An option would be to let a VBA Macro do the donkey work. Press Alt-F11, double-click This Workbook, then copy this code into the resulting window (essentially only one line of code!): Sub RemoveHyper() Selection.Hyperlinks.Delete End Sub Press Alt-F11 to go back to your spreadsheet, select all the cells with hyperlinks, then do Alt, T, M, M (or Alt-...


17

Resetting the style of all Hyperlinks back to default requires a VBA Macro. Code: Sub RestoreHyperlinkStyle() Dim hl As Hyperlink For Each hl In ActiveDocument.Hyperlinks hl.Range.Style = wdStyleHyperlink Next End Sub Steps: Press Alt+F11 to open Microsoft Visual Basic for Applications. Double-click on "ThisDocument". Paste the code ...


14

Take a look at Hyperlink worksheet function. Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet. When you click the cell that contains the HYPERLINK function, Microsoft Excel opens the file stored at link_location. Syntax HYPERLINK(link_location,friendly_name) For example: =...


14

Open the history by pressing Ctrl + H, search for the URL that you want to remove, click on the time that is displayed left of it and then click Remove selected items. Note: Since Chrome history doesn't hold too many entries you may not find that link in there if you visited that page long time ago, yet it still will show up as "visited" in your browser. To ...


13

To select link text in Firefox, hold Alt while dragging the mouse. Note that this does not currently work in Chrome or Safari.


13

You can use a macro: Open up a new workbook. Get into VBA (Press Alt+F11) Insert a new module (Insert > Module) Copy and Paste the Excel user defined function below Get out of VBA (Press Alt+Q) Use this syntax for this custom Excel function: =GetURL(cell,[default_value]) Function GetURL(cell As range, Optional default_value As Variant) 'Lists the ...


12

=HYPERLINK("#'linked sheet name'!linked cell number","your message") For example =HYPERLINK("#'Page 2'!A4","TEST") The linked sheet name is Page 2 and linked cell number is A4 and message is TEST.


10

Press ALT+F9. You're in "Field Codes Mode", where Word displays field codes instead of the values of the fields. More info: most dynamic data within MS Word is controlled by what Word calls "Fields", and fields are defined by programmatic data called "Field Codes". Field Codes are interpreted commands that Word processes in order to calculate data that is ...


10

It's unclear if this is a bug; but Excel seems to be making the entire cell clickable just because there's a HYPERLINK function in the formula in order for it to work. Right-clicking on the cell & selecting Remove Hyperlink does not seem to work either. I can't seem to find a non-VBA solution to prevent Excel from creating those "phantom" hyperlinks, ...


9

The following is based on the assumption that you've already set up headings (e.g. Heading 1, Heading 2) that include numbering, so that the 4.2.5 in your example will get updated automatically, when you add or remove a section. The feature you are looking for is called Cross-reference. Position the cursor just after "as seen in section" Select the ...


9

Create a new shortcut (Right-click->New->Shortcut) Point the shortcut to the executable of your browser of choice (e.g., "C:\Program Files\Mozilla\Firefox\firefox.exe") Add the URL you wish to go to after the executable ("http://kongregate.com") Name the shortcut whatever you want. Double-click the shortcut to open your webpage in the designated browser.


9

If they are occurring on sites like stackoverflow it's most likely from a browser extension or some type of malware installed on your computer. Start by looking at the enabled browser extensions and disabling those you don't recognize. Then find a good spyware and anti-virus program and run those. It was apparently a Google Chrome extension called ...


9

Try the following, it works in Word 2013 and I think it should work in 2010 as well: From the Home tab on the ribbon, choose Find -> Advanced Find... Leave Find what blank. At the bottom, choose Format -> Style... Choose Hyperlink and press OK to close the dialog and return to the previous one. Choose Find In -> Main Document All the hyperlinks will be ...


8

All I had to do was hit Alt+F9. If you want to fix this hyperlink problem in Microsoft Word 2007 or 2010 you’ll need to take the following steps: Click on the Office button Select Word options Select Advanced. Scroll down and in the section “show document content” you need to uncheck “show field codes instead of their values”. Click OK Your ...


8

Desktop link checkers Xenu's Link Sleuth. Free. Windows only. DeepTrawl. Commercial. Windows & Mac. InSpyder. Commercial. Windows only. SortSite. Commercial. Windows only. LinkScan. Commercial. Windows only. CyberSpyder Link Test. Commercial. Windows only. Web-based link checkers LinkAider. Paid (free for small websites with less than 500 pages). ...


8

Personally, I just drag the cursor over the text I want and hit Ctrl+C, It works 99% of the time, however, I would be interested to see if anyone else comes up with a better solution! Edit - On the odd occasion when you can't drag around an exact hyperlink for some reason (e.g. weird CSS causing problems) I try and copy more than is needed then paste into ...


8

Follow these steps: In any empty cell, type in the number 1 (it can be deleted later). Right click the cell where you typed the number 1 and then click on Copy. Select the cells with hyperlinks that you want to delete. On the Home tab, in the Clipboard group, click the down arrow and then click on Paste Special. Under Operation, click on Multiply, ...


8

This is Excel fault. If you paste the link in Outlook email or WordPad and you open the link from there it will work correctly. Excel should never create hidden session to verify the hyperlink. what's the point of it. It just needs to open it, nothing else. They use the same logic in MS Word. It doesn't work from there neither. When Excel tries to verify ...


8

Try the ToggleLink add-on. Interestingly, I just found out that pressing Alt allows you to select part of a link with the mouse in Firefox! See if by some chance that works in Chrome as well.


8

An alternative is to create a shortcut with the relevant command line switches embedded in it. Then you can hyperlink to the shortcut. Note that the shortcut has a .lnk extension. If you'd like to do something more involved than launching a single executable with switches, you could link to a batch script (.bat).


8

Ctrl+A followed by Ctrl+Shift+F9. CtrlA selects all, and CtrlShiftF9 is the command to unlink a field.


7

The vanilla way link to somewhere in-page is via an anchor point already present in the page. This can be created using the <a>…</a> tag. Note that the link specified in "anchor point" (above) has #h-12.2 at the end. This corresponds to <a id="h-12.2">12.2</a> embedded in the HTML forming the page, and when clicked will reposition ...


7

Simple. Take the url param of the google redirector link (copy link in the browser and paste it to any text editor), it's a string after url= and before first & symbol (bolded out): http://www.google.com.ph/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&cad=rja&ved=0CBwQFjAA&url=http%3A%2F%2Fdownload.microsoft.com%2Fdownload%...


6

Select all cells you want to clear from hyperlinks, then click the "Home" tab in the ribbon at the top of Excel. In the "Editing" group, click on the "Clear" pull-down arrow and select "Clear Formats". UPDATE: Select all cells you want to clear from hyperlinks, right click and "Cut" or use Ctrl+X. Now open up a notepad window and paste it there. Now ...


6

You have to create the place you want to link to as a "Top of Document", "Heading", or "Bookmark". In the screenshot, I created 123 as a "Heading", and then right-clicked my "Test" text and clickedHyperlink>Place in this document, and you will see 123 there. To do it as a bookmark, highlight the target text, and go to Insert>bookmark, and it will also ...


6

I think Excel does not allow creating hyperlinks on only part of the text in a cell. The hyperlink can only be set on the complete cell. But there is something you can do. You can make "here" look like hyperlink and the rest of the text look normal. How to do it? Just get into the cell in edit mode (Press F2), select the text "For blabla.."; remove its ...


6

Open the config page in Firefox by typing in about:config, then promise to be careful and enter. Type network.standard-url into the search box. Ensure both values are set to true. Source Edit As per mmv-ru comments, setting escape-utf-8 to false helped. So I assume keeping encode set to true!


6

In about:config set network.standard-url.escape-utf8: false After this path copied as not encoded. But ancor keep encoded. :(


6

If you click right above the link and drag it will select part of it. This probably works in a most browsers but I only tested it in Chrome on Windows.



Only top voted, non community-wiki answers of a minimum length are eligible