Tag Info

Hot answers tagged

18

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 ...


16

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 ...


13

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: ...


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

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 ...


8

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, ...


7

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 ...


7

Create a new shortcut (Right-click->New->Shortcut) Point the shortcut to the executable of your browser of choice ("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. Profit.


7

=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.


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

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 ...


6

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


5

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.


5

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 ...


5

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.


5

An alternative is to create a shortcut with the relevant commandline switches embedded in it. Then you can hyperlink to the shortcut. Note that the shortcut has a .lnk extension.


5

Activating Address Bar: Right click on anywhere of Toolbar: A menu will pop-up Tick Address Get Link: Select the document that you wish to get the link to Click the Down Arrow twice at the end of Address Bar The document link will show in the Address Bar.


5

I highlighted the range that had multiple hyperlinks embedded. I copied them to another section of the spreadsheet, then, used the Special Paste function, and pasted them as values into the new section. Worked like a charm!


5

You can use W3C's link validation tool - W3C's Link Checker.


5

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 ...


5

The only way to link to somewhere in-page is via an anchor point already present in the page. This created using the <a></a> tag. Note the the link specified in "anchor point" has #h-12.2 at the end. This corresponds to <a name="h-12.2">12.2</a> enbedded in the html forming the page, and when clicked will reposition the page view ...


4

echo -En '<a href="http://t.co">tco</a><br><a href="http://g.co">gco</a>' | textutil -format html -convert rtf -stdin -stdout | pbcopy -Prefer rtf The output will always include styles. For some reason pbcopy -Prefer rtf doesn't include a plain text version on the clipboard so you won't be able to paste anything in plain text ...


4

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!


4

If you click right above the link, right when the cursor changes from a hand back to a pointer, and drag across from that point, you can select the middle part of a hyperlink. I just tried it out in Chrome.


3

Weird as it may sound, ln -si ../../../GIT/Settings/session ./.mozilla/firefox/foo.default/ will do what you want. The rule of thumb here is that you should specify your link targets relative to the location where you're placing the link. On Unix and Unix-like file systems, a symbolic link is actually a special file whose contents are a path. Typing ln ...


3

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 ...


3

So I guess Firefox is your default web browser, right? What if you change it to Chrome or IE and then try opening up URLs from other applications? Would that make any difference in terms of responsiveness? Also, have you tried to re-install Firefox (just clean install, no add-on, theme, or persona etc) and see how it performs? Sometimes, some ...



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