Hey Jeff. Been working on large list of hyperlink data and had to remove a link. After deleting the cell contents and retyping in the same cell, I noticed the link was still there. Tried Clear contents, delete key, right click delete. Nothing seemed to work. After some searching I found under the ribbon Home tab, under editing: the Clear menu with options, and clear hyperlink was there. That was the only place I could find to remove the link. Might be good to include this in your exercise. warm regards - Mark
Thanks again, Professor. This is exactly what I was struggling with yesterday. Forever, indebted to you for such valuable knowledge.
Awesome video! I am so glad I am not the only person using hyperlinks in Excel.
Should have included Exercise 4 with hyperlink function to programmatically create hyperlink to monthly files. 😉
Thanks, I like a link with a picture. Paul
Hey Jeff. Been working on large list of hyperlink data and had to remove a link. After deleting the cell contents and retyping in the same cell, I noticed the link was still there. Tried Clear contents, delete key, right click delete. Nothing seemed to work. After some searching I found under the ribbon Home tab, under editing: the Clear menu with options, and clear hyperlink was there. That was the only place I could find to remove the link. Might be good to include this in your exercise. warm regards - Mark
Mark!!!!! Excellent point, thanks for posting this comment and hope you are well :)
Very good, I liked.