How to prevent hyperlinks from changing color in Excel?
Normally, when we click the hyperlink in a worksheet, the blue color hyperlink will be changed to purple as following screenshots shown. But sometimes, we just want to keep hyperlink are blue color whenever we click it or not. How could we prevent hyperlink from changing color after we click it?
Prevent hyperlinks from changing color in Excel
Prevent hyperlinks from changing color in Excel
To keep the hyperlink without changing color after clicking it, please do as these:
1. Go to click Page Layout tab in the ribbon, and then click Colors > Create New Theme Colors, see screenshot:
2. And in the Create New Theme Colors dialog, in the Theme colors section, click the drop down list beside the Followed Hyperlink option, and choose the blue color of the original hyperlink color. See screenshot:
3. At last, click Save button to save this setting. When you click the hyperlink next time, the color of it will not be changed.
Related articles:
How to remove / delete all or multiple hyperlinks in Excel?
How to prevent / disable automatic hyperlinks in Excel?
How to change multiple hyperlink paths at once in Excel?
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!