Prevent changing cell format on update of hyperlinks

[shreeram.maroo]

Hi,

I have added a hyperlink to a cell and changed the font format to let's say Times new roman - 10 size. Now everytime I update the hyperlink, let's say i change the linked cell due to some reasons - the formatting of the cell is auto updated to my default font - Calibri 11. Is there a way i can prevent this everytime and retain the original font format?

Regards
Shreeram

[HansV]

A hyperlink uses the Hyperlink style. This style uses Calibri as font by default:

S0049.png

Inbstead of changing the font of the cell, modify the Hyperlink style :
- Select Cell Styles in the Styles group of the Home tab of the ribbon.
- Right-click Hyperlink.
- Select Modify... from the context menu.
- Click Format...
- Activate the Font tab.
- Select the font, font size, font style and font color that you want.
- Click OK, then click OK again.

S0050.png

[shreeram.maroo]

Got that.. thank you :)