Forum Discussion
Excel Hyperlinks
I need to stop the creation of hyperlinks within a column. I'm sure there is a quick command out there, just not finding it. I know how to turn them off completely, or get rid of them once they are made either in groups or one at a time, but as this is a continuously updated document that does have hyperlinks in other columns, it is a constant housekeeping task clearing errant hyperlinks from columns in which they do not belong.
Rebecca
Select the cells that contain hyperlinks, right-click, and then select Remove Hyperlink as shown in the below screenshot:
To prevent that behavior from happening in the future, do the following:
- Go to Excel Options >> Proofing
- Click on the AutoCorrect Options button.
- From the AutoCorrect dialog box, select the second tab.
- Clear the CheckBox labeled: (Internet and network paths with hyperlinks).
- Hit OK.
Looks like we are using different versions. Mine's Office365 Excel saved to a OneDrive shared file, and I have no 'Excel Options' anywhere I can locate. Really that's my whole issue. I'm not accustomed to this version, and I can't find anything. I do appreciate the prompt and quality reply tho. I bounced around some tutorials, but can't find this fix. Looks like I'll be putting some relearning hours in.
