• Excel Developers
  • Excel Developers
  • Excel Developers

Privacy Policy I Site Map 

Website design by Tiny Aubergine

All rights reserved

Prevent Auto Styling of Hyperlinks

May 1, 2014

 

When you add a hyperlink to a cell in Excel, it automatically applies the Hyperlink style (blue font, underlined). Sometime I want to add hyperlinks but preserve the formatting in the cell I’m adding the hyperlink to, but there is no option in Excel to do this. Deleting the “Hyperlink” style does not work either, as it reappears automatically. I searched all over the net for an answer to this but couldn’t find one. The vast majority of answers apply to the question of how to prevent Excel from turning a web URL or email address into a hyperlink automatically when you type one into a cell. When I finally figured it out therefore I thought I would share this tip with you.

It turns out to be laughably simple. At first I thought about modifying the “Hyperlink” cell style to match the current format of the cell I want to add a hyperlink to. But what if I want to add hyperlinks to multiple cells, each with a different format? Then I had a light bulb moment: modify the Hyperlink cell style, but select no attributes to apply formatting to (attributes are “Number”, “Alignment”, “Font”, “Border”, “Fill” and “Protection”). The option to select which attributes to apply the formatting to appears after right-clicking the “Hyperlink” style from the Home tab of the Ribbon and selecting “Modify”. Simply untick all the boxes. The result is that Excel still applies the Hyperlink cell style to your hyperlink, but the style no longer contains any formatting instructions.

Have you ever come across this problem? How did you resolve it?

 

Tags:Automatic excel Formatting Hyperlink Style

Tags:

Please reload

Featured Posts

Hooking an ActiveX Command Button in Class Module

May 2, 2014

1/2
Please reload

Recent Posts
Please reload

Archive
Please reload

Search By Tags
Please reload

Follow Us
  • Facebook Basic Square
  • Twitter Basic Square
  • Google+ Basic Square