Excel changing fonts when assigning link to cell

[robertd903]

When I attempt to assign a link (to a different cell), Excel automatically changes the font of the cell. Why is this? What does the FONT--have to do with the link to another cell? No, the font is NOT the same as the linked cell's font--so what's up? If EXCEL wants to "automatically" do some stuff--how about it "automatically" finishes the massive amount of data entry that I have to do?

 

[vletm]

robertd903
Could You send a sample Excel-file about Your case?

 

[robertd903]

Here's a quick example:

 

[p45cal]

Maybe: https://support.microsoft.com/en-us...perlinks-672c2905-ad3e-40be-b281-811e68386243

 

[robertd903]

Maybe: https://support.microsoft.com/en-us...perlinks-672c2905-ad3e-40be-b281-811e68386243

So, if I understand correctly, I HAVE to tell EXCEL which font to change my hyperlinks to--even though I make NO mention of font? What if I decide to change just ONE of my cells to a different font? Do I have to go through this process EVERY time I change a cell's font?

 

[p45cal]

I think the Hyperlink style can be made to change nothing:

I can't find a way to make that style apply, for example, ONLY underlining, leaving everything else as-is.
All future added hyperlinks won't change the style of that cell, previously created links seem to retain their old style.