T Tim Nov 2, 2007 #1 How can I remove any and all hyperlinks in a column of data ? The only thing I can find is removal one cell at a time ? Thanks, Tim
How can I remove any and all hyperlinks in a column of data ? The only thing I can find is removal one cell at a time ? Thanks, Tim
D Dave Peterson Nov 2, 2007 #2 Select the range that should have the hyperlinks removed hit alt-f11 to get to the VBE (where macros live) hit ctrl-g to see the immediate window type this and hit enter: selection.hyperlinks.delete Then back to excel to check.
Select the range that should have the hyperlinks removed hit alt-f11 to get to the VBE (where macros live) hit ctrl-g to see the immediate window type this and hit enter: selection.hyperlinks.delete Then back to excel to check.
M MartinW Nov 2, 2007 #3 Hi Tim, Another way is to copy an empty cell Select your entire column Then Edit>Paste Special, Check Add and OK out. Make sure the cell you copy is truly empty HTH Martin
Hi Tim, Another way is to copy an empty cell Select your entire column Then Edit>Paste Special, Check Add and OK out. Make sure the cell you copy is truly empty HTH Martin
