If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Cell formatting
I do not want the cell format to change when I add a hyperlink. Presently,
the font, colour and underscore changes whenever I add a hyperlink. As I shall be adding links over a period of time, I do not wish to keep changing the formatting all the time. Is there a way of avoiding having to do this? (like how do I change the default for hyperlinks?) |
#2
|
|||
|
|||
Rita
In later versions you can go to ToolsAuto correct options... and select the 'autoformat as you type' tab, un-checking the 'internet and network paths with hyperlinks' entry Other versions, hitting Ctrl+Z straight after entry (Undo). It will undo the formatting but not the entry. Pain, but that's about all you can do -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "rita" wrote in message ... I do not want the cell format to change when I add a hyperlink. Presently, the font, colour and underscore changes whenever I add a hyperlink. As I shall be adding links over a period of time, I do not wish to keep changing the formatting all the time. Is there a way of avoiding having to do this? (like how do I change the default for hyperlinks?) |
#3
|
|||
|
|||
Ctrl+z will undo formatting and hyperlink in Excel 2000.
I don't think it would act differently in other versions. Since the hyperlink was wanted but not the formatting the following would work in Excel 2000. Insert the following code for the sheet you want it applied to by right click on sheet name, view code, insert code. Private Sub Worksheet_Change(ByVal Target As Range) '-- hyperlink color when change is made With Target.Font .ColorIndex = xlAutomatic End With End Sub If you want to drive people crazy (most of all yourself), you could change the style it would apply to the entire workbook. Format, style, stylename: hyperlink, uncheck color --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Nick Hodge" wrote in message ... Rita In later versions you can go to ToolsAuto correct options... and select the 'autoformat as you type' tab, un-checking the 'internet and network paths with hyperlinks' entry Other versions, hitting Ctrl+Z straight after entry (Undo). It will undo the formatting but not the entry. Pain, but that's about all you can do -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "rita" wrote in message ... I do not want the cell format to change when I add a hyperlink. Presently, the font, colour and underscore changes whenever I add a hyperlink. As I shall be adding links over a period of time, I do not wish to keep changing the formatting all the time. Is there a way of avoiding having to do this? (like how do I change the default for hyperlinks?) |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Why won't my conditional formatting display in the cell | Cashius War eagle | General Discussion | 3 | February 15th, 2005 08:38 PM |
How do I Count Colors in a cell with conditional formatting | JB | General Discussion | 3 | September 2nd, 2004 12:41 AM |
Conditional Formatting Based On Content Of Another Cell | Jay | Worksheet Functions | 6 | June 11th, 2004 12:48 PM |
Do you have what it takes... | Frank Kabel | Worksheet Functions | 1 | February 22nd, 2004 08:30 PM |
Conditional Formatting to hide contents of cell | Paul | Worksheet Functions | 0 | January 16th, 2004 11:52 AM |