| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove hyperlink in excell 2003
HI
I know that their is an EASY way to remove hyperlinks.... I have a whole bunch of emails on a spreadsheet... how without doing like macos and stuff how do I remove the links???? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Remove hyperlink in excell 2003
Kinda VBAish...
select the range with the links (the whole worksheet??) hit alt-f11 to get to the VBE hit ctrl-g to see the immediate window type this and hit enter: selection.hyperlinks.delete patti wrote: HI I know that their is an EASY way to remove hyperlinks.... I have a whole bunch of emails on a spreadsheet... how without doing like macos and stuff how do I remove the links???? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Remove hyperlink in excell 2003
Dave,
I could have sworn that I thought I could right click & remove the links that way?? "Dave Peterson" wrote: Kinda VBAish... select the range with the links (the whole worksheet??) hit alt-f11 to get to the VBE hit ctrl-g to see the immediate window type this and hit enter: selection.hyperlinks.delete patti wrote: HI I know that their is an EASY way to remove hyperlinks.... I have a whole bunch of emails on a spreadsheet... how without doing like macos and stuff how do I remove the links???? -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Remove hyperlink in excell 2003
Dave I did that ,
but when I hit enter, i just keep going to the next line?? "patti" wrote: Dave, I could have sworn that I thought I could right click & remove the links that way?? "Dave Peterson" wrote: Kinda VBAish... select the range with the links (the whole worksheet??) hit alt-f11 to get to the VBE hit ctrl-g to see the immediate window type this and hit enter: selection.hyperlinks.delete patti wrote: HI I know that their is an EASY way to remove hyperlinks.... I have a whole bunch of emails on a spreadsheet... how without doing like macos and stuff how do I remove the links???? -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Remove hyperlink in excell 2003
Go back to Excel and you'll see that you removed all the hyperlinks that were in
that selected area. And you can rightclick and remove the hyperlink from the cell--but it's one cell at a time. patti wrote: Dave I did that , but when I hit enter, i just keep going to the next line?? "patti" wrote: Dave, I could have sworn that I thought I could right click & remove the links that way?? "Dave Peterson" wrote: Kinda VBAish... select the range with the links (the whole worksheet??) hit alt-f11 to get to the VBE hit ctrl-g to see the immediate window type this and hit enter: selection.hyperlinks.delete patti wrote: HI I know that their is an EASY way to remove hyperlinks.... I have a whole bunch of emails on a spreadsheet... how without doing like macos and stuff how do I remove the links???? -- Dave Peterson -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Remove hyperlink in excell 2003
actually I found it...
highlight the area click on edit click clear and formats... and the hyperlinks are gone.. thanks :) "Dave Peterson" wrote: Go back to Excel and you'll see that you removed all the hyperlinks that were in that selected area. And you can rightclick and remove the hyperlink from the cell--but it's one cell at a time. patti wrote: Dave I did that , but when I hit enter, i just keep going to the next line?? "patti" wrote: Dave, I could have sworn that I thought I could right click & remove the links that way?? "Dave Peterson" wrote: Kinda VBAish... select the range with the links (the whole worksheet??) hit alt-f11 to get to the VBE hit ctrl-g to see the immediate window type this and hit enter: selection.hyperlinks.delete patti wrote: HI I know that their is an EASY way to remove hyperlinks.... I have a whole bunch of emails on a spreadsheet... how without doing like macos and stuff how do I remove the links???? -- Dave Peterson -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Remove hyperlink in excell 2003
Did you try clicking on that cell?
If there was a hyperlink in that cell to start, I think it's still there--but the format has been changed (not blue underlined), but the link is still there. If there was no hyperlink to start, then there still won't be one <bg. patti wrote: actually I found it... highlight the area click on edit click clear and formats... and the hyperlinks are gone.. thanks :) "Dave Peterson" wrote: Go back to Excel and you'll see that you removed all the hyperlinks that were in that selected area. And you can rightclick and remove the hyperlink from the cell--but it's one cell at a time. patti wrote: Dave I did that , but when I hit enter, i just keep going to the next line?? "patti" wrote: Dave, I could have sworn that I thought I could right click & remove the links that way?? "Dave Peterson" wrote: Kinda VBAish... select the range with the links (the whole worksheet??) hit alt-f11 to get to the VBE hit ctrl-g to see the immediate window type this and hit enter: selection.hyperlinks.delete patti wrote: HI I know that their is an EASY way to remove hyperlinks.... I have a whole bunch of emails on a spreadsheet... how without doing like macos and stuff how do I remove the links???? -- Dave Peterson -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| permanently remove gridlines in regedit for Excel 2003 | Setting up and Configuration of Excel | |||
| how do i cancel getpivotdata in excell 2003 | Excel Worksheet Functions | |||
| Hyperlink display text maximum in Excel 2003 | Excel Discussion (Misc queries) | |||
| excell 2003 will not open previous version | Excel Discussion (Misc queries) | |||
| how do you turn off automatic hyperlink in excel 2003 | Excel Discussion (Misc queries) | |||
Linear Mode
