Microsoft Office

Remove All Hyperlinks in Microsoft Word or Excel

150 150 rhecht

Word

1. CTRL+A and then CTRL+SHIFT+F9

2. Credit to http://www.tech-recipes.com/rx/1323/remove-all-hyperlinks-in-word-or-excel/

Go to “Insert” > “Module” and in the pop-up window copy:


Sub RemoveHyperlinks()
Dim oField As Field
For Each oField In ActiveDocument.Fields
If oField.Type = wdFieldHyperlink Then
oField.Unlink
End If
Next
Set oField = Nothing
End Sub

Then click “File” > Close and return to Microsoft Word

You can now run the Macro in Word by going to:

Tools > Macro > Macro and then Run “RemoveAllHyperlinks”

Excel

You can do the same in an Excel Document:

Hit [ALT]+[F11] to open the Visual Basic Editor

Go to “Insert” > “Module” and in the pop-up window copy:

Sub RemoveHyperlinks()
'Remove all hyperlinks from the active sheet
ActiveSheet.Hyperlinks.Delete
End Sub

Then click “File” > Close and return to Microsoft Excel

You can now run the Macro in Excel by going to:

Tools > Macro > Macro and then Run “RemoveAllHyperlinks”, this will delete all URLS on the selected worksheet.

Excel: My Spreadsheet Has a Font?

150 150 rhecht

By default, Microsoft Office Excel 2007 uses the Body Font font in font size 11 (which is displayed as the Calibri font in font size 11 when you type data in a worksheet, header or footer, or text box) but you can change the default font and font size for all new workbooks that you create.

  • Click the Microsoft Office Button , and then click Excel Options.
  • In the Popular category, under When creating new workbooks, do the following:
  • In the Use this font box, click the font that you want to use.
  • In the Font Size box, enter the font size that you want to use.

NOTE: To begin using the new default font and font size, you must restart Excel. The new default font and font size are used only in new workbooks that you create after you restart Excel; existing workbooks are not affected. To use the new default font, you can move worksheets from an existing workbook to a new workbook. For more information, see Move or copy a worksheet.

Courtesy of: Microsoft Office Knowledge Base

For Word 2003 and Earlier:

Step1
Open the “Options” dialog box. Click on “Tools” on the tool bar and select “Options.” This opens the Options dialog box in which you can change the default attributes of your workbook.

Step 2
Change the default font. Click the “General” tab and then click the arrow in the “Standard font” field. Select a new font from the list.

Step 3
Change the font size. Click the “Size” box and select a new font size.

Step 4
Click “OK” when you have finished making your changes.

You will have to restart Excel in order for the changes to take effect.

This post was inspired by the Nick Burns video with Jackie Chan on “My Spreadsheet has a font?”

Removing All Hyperlinks in Excel

150 150 rhecht

Removing a bunch of hyperlinks can be tedious. Imagine the time you have to spend right-clicking on each of those links and selecting ‘remove hyperlink’ on the context menu. Of course it would just take two clicks, but what if you are to remove a hundred of them or perhaps 1000 hyperlinks? I’m sure that would be enough to scrape out the paint of your right-mouse button.

Below are some simple techniques you can use in order to remove single to multiple hyperlinks on a page:

Removing just one hyperlink

1. Right-Click on the cell and select Remove Hyperlink from the context menu.

Removing hyperlinks using the cell format

1. Select the cells having hyperlinks. You can use CTRL+LEFT CLICK to randomly select a cell.

2. On the menu click on Edit. Hover your mouse to the option Clear and select Fomats. Please note that the cell is still clickable to remove the hyperlink completely you have to select Clear->All.

Remove Excel hyperlinks on selected cells the better way

1. Type in any text or number in a blank cell

2. Right-click and select Copy on the context menu.

3. While pressing CTRL, select each cell with the hyperlink you wish to be removed

4. On the Edit menu, select Paste Special.

5. Under Operation, click Multiply and then click OK.

6. If you are using Office 2007, you may need to click or change the cell format to Normal found at the Styles Group Toolbar.

Removing Excel hyperlinks using a macro

Assuming you know excel programming you could create a macro to automatically remove the hyperlinks.

1. Start Visual Basic Editor. Alternatively you can press ALT-F11 to start the editor.

2. Double click the workbook you are using on the Project Explorer.

3. Type the following text:

Sub RemoveHyperlinks()

ActiveSheet.Hyperlinks.Delete

End Sub

4. Save your work.

5. Run your macro by pressing ALT-F8 or using the menu by Tools->Macro->Macros

6. Select the macro you have made, it should have the name ‘RemoveHyperlinks’.

Removing the Default Hyperlink Option

The most efficient way to remove them is by actually avoiding them in the first place. Now you don’t need to follow those hard and confusing steps above anymore. You can prevent Excel from formatting URLs and network links by removing its AutoFormat function at the AutoCorrect dialog box.

Unfortunately, if you are using Office 2003 or lower, i can’t give you the exact steps but the AutoCorrect is at Tools on the main menu bar. I just don’t remember where to go from there. If you are using Office 2000, there is no way we could prevent URLs from being formatted.

Post courtesy of: http://www.tildemark.com/removing-multiple-hyperlinks-in-excel/

Excel Macro – Get and Extract Hyperlink URL Address From Link

150 150 rhecht

This has personally worked like a charm for me.

Try this user-defined function:

=ShowAddress(A1)

Where A1 is the cell with the hyperlink in it. Here is the Macro function code:


Public Function ShowAddress(rng As Range) As String
If rng.Cells.Count > 1 Then
ShowAddress = CVErr(xlErrValue)
Else
ShowAddress = rng.Hyperlinks.Item(1).Address
End If
End Function

Note: With Excel 2007 and 2010 you first need to save a document as “.xlsm” to enable macros!

Microsoft Word Solution to Error “there was a problem sending the command to the program”

150 150 rhecht

Have you ever run into the error from Microsoft Word that “there was a problem sending the command to the program?” Well, worry no more! Here’s a solution.

Usually this is caused by the corruption in a specific registry key that’s associated by Microsoft Word. Deleting that key (backing it up first), and then restarting Microsoft Word should cause it to regenerate the key and its values, and this new uncorrupted key should solve the problem. No worries, there is no data loss whatsoever from this method.

This solution was found on Microsoft’s knowledge base website here (http://support.microsoft.com/kb/921541):

Delete the Word Data registry key

A screenshot on what you should do. Too many have complained about not finding this :-)

A screenshot on what you should do. Too many have complained about not finding this 🙂

To view these options in Word 2002 or Word 2003, click Options on the Tools menu.

To view these options in Word 2007, click the Microsoft Office Button, and then click Word Options.

Note When you delete the Word Data registry key, Word resets several options to their default settings. One such option is the “most recently used file” list on the File menu. Additionally, Word resets many settings that you customize in the Options dialog box.

To delete the Word Data registry key, follow these steps:

  • Exit all Office programs.
  • Click Start, click Run, type regedit, and then click OK.
  • Locate the following registry subkey, as appropriate for the version of Word that you are running:
    • Word 2002:
    • HKEY_CURRENT_USERSoftwareMicrosoftOffice10.0WordData
    • Word 2003:
    • HKEY_CURRENT_USERSoftwareMicrosoftOffice11.0WordData
    • Word 2007:
    • HKEY_CURRENT_USERSoftwareMicrosoftOffice12.0WordData
    • Word 2010:
    • HKEY_CURRENT_USERSoftwareMicrosoftOffice14.0WordData
  • Click Data, and then click Export on the File menu.
  • Name the file Wddata.reg, and then save the file to the desktop.
  • Click Delete on the Edit menu, and then click Yes.
  • Exit Registry Editor.
  • Start Word.

If Word starts and works correctly, you have resolved the problem. The problem was a damaged Word Data registry key. You may have to change several settings to restore your favorite options in Word.

If the problem is not resolved, restore the original Word Data registry key. Then, see the “Delete the Word Options registry key” topic.

To restore the original Word Data registry key, follow these steps:

  • Exit all Office programs.
  • Double-click the Wddata.reg icon on the desktop.
  • Click Yes, and then click OK.

Voila! Your problem is solved!

Shortcut key – Remove all Hyperlinks in Microsoft Word Document

150 150 rhecht

How to remove all hyperlinks in a Microsoft Word document:

For Windows Users:

CTRL+A

CTRL+SHIFT+F9

For Mac Users:

COMMAND+A

Option 1: FN+COMMAND+SHIFT+F9

Option 2 (easier): COMMAND+6