How does the color of the hyperlink in the Excel table change?

How does the color of the hyperlink in the Excel table change? ? In excel, the general format of the hyperlink is that the font is underlined, the color is blue, and it turns purple after clicking; for more beautiful, it should be set without underscore, the initial color is other, and it will not change color or become other after clicking. How to do it?

1, open excel, the default style of the hyperlink as shown below

2, click once to become purple

3, now start to modify its style. First remove the underline: select the cell where the link is located, click the menu bar <; Start & rdquo;, un-underline

4, set the hyperlink font color to other colors such as red. At this point, the font color does not change after clicking this link.

5, if you need to set the link initial color to green, click on the font color to gray, you need to set the cell style separately

6, first set the font color after clicking: right Click [has been accessed. . . 】, in the pop-up drop-down box, select Modify

7, in the pop-up interface, the underline is the current format, click the [Format] button to start setting the format you want.

8, for example, after the click of the setting is grayed out without underline, 48#

9. Similarly, to set the initial color of the link, you need to modify the cell style at the "hyperlink" The format, method is the same as the format set on the "already accessed", and will not be repeated. Once this is done, create a hyperlink to verify it.