Hyperlink settings
Is there a simple way to adjust the settings for hyperlinks so that everytime I assign or edit a hyperlink it does not automatically alter any formatting in the cell. For instance the font, size and color change and it underlines as I add or edit a hyperlink in a cell. I want it to do nothing but add the hyperlink. It's just annoying. -- famdamly ------------------------------------------------------------------------ famdamly's Profile: http://www.excelforum.com/member.php...o&userid=29382 View this thread: http://www.excelforum.com/showthread...hreadid=516437 |
Hyperlink settings
=HYPERLINK("#d1","") will make the cell blank, I couldn't find anyway to stop it from defaulting to blue and underlying, you can format the faont ant colour, but I couldn't get rid of the underline Dave -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=516437 |
Hyperlink settings
Maybe you could play with the hyperlink style.
Format|style select hyperlink from the dropdown Click modify and change it to what you want (remove the underline, change the color, change the size... The hyperlink is still live (clickable?). Styles live in workbooks, so this only affects the workbook that you're in. But you can merge styles from one workbook to another and you could even set up a default workbook template with that style. Start a new workbook change everything you want (including the style) save it as book.xlt in your XLStart folder. Each time you click on the new icon on the standard toolbar, you'll get a new workbook based on that template. famdamly wrote: Is there a simple way to adjust the settings for hyperlinks so that everytime I assign or edit a hyperlink it does not automatically alter any formatting in the cell. For instance the font, size and color change and it underlines as I add or edit a hyperlink in a cell. I want it to do nothing but add the hyperlink. It's just annoying. -- famdamly ------------------------------------------------------------------------ famdamly's Profile: http://www.excelforum.com/member.php...o&userid=29382 View this thread: http://www.excelforum.com/showthread...hreadid=516437 -- Dave Peterson |
Hyperlink settings
:) Thanks for the help. I've seemed to never notice the style option down there on the menu. Very cool. -- famdamly ------------------------------------------------------------------------ famdamly's Profile: http://www.excelforum.com/member.php...o&userid=29382 View this thread: http://www.excelforum.com/showthread...hreadid=516437 |
All times are GMT +1. The time now is 03:55 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com