13 September 2007

Excel hyperlink color colours

There I was, actually doing something to get a bit more organised at the start of term in the shape of a timetable for my teaching when I hit a problem that had me scratching my head. Finished up having to look on various forums to get the answer so here's the problem and the solution which may save you a few hours one day!

For some reason best known to me I had used blue blocks for various lessons with white text. To make life simple I put hyperlinks on the text so that clicking a lesson would take me to the appropriate register. Of course, the text turns blue and gets underlined and is virtually invisible. Or it goes purple as a 'visited' link.




Ok, that'll be easy to fix, I say to myself. Uh-uh. Tried almost every menu. Tried the Microsoft help files but I seldom get much joy there anyway. Thought about the PCAdvisor forums but they don't have an obvious Excel place. Normally I would have popped into Woody's Lounge but that's under some redevelopment and temporarily off-line. Eventually I find Vastly Important Notes blog by Phil Libin and get the answer. Another addition to my favourites list.

You need Format | Styles and there you can change Hyperlink and Followed Hyperlink colours (or colors in MS speak).



That's better!

2 comments:

greentub said...

Thank you so much for posting this! My problem was that some (but not all) of my unclicked hyperlinks were blue and underlined. Others looked like normal type (so readers wouldn't know it was a link). This fixed it.

Thanks!

Lauren said...

Thank you. Also for Excel 2007 users. Go to Home tab > Styles > Cell Styles > Followed Hyperlink.