Forum Discussion
Rebecca Davis
Mar 05, 2018Copper Contributor
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 m...
Haytham Amairah
Mar 05, 2018Silver Contributor
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.
Rebecca Davis
Mar 05, 2018Copper Contributor
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.