I am in a shared google sheet for my company, and every time I use "Insert column to the left" the entire column is hyperlinked. Anything I type is underlined and blue. The column it is to the left of has hyperlinks in it.

Nowhere in the godforsaken options am I finding anything for removing hyperlink.
Right click column:
* Cut
* Copy
* Paste
* Paste special
* Insert Columns to the left
* Delete columns
* Clear contents
* Column width
* Hide columns
* Format cells
* Copy link
* Show changes

Right click a cell within the column:
* Cut
* Copy
* Paste
* Paste special
* Insert Columns to the left
* Delete columns
* Clear contents
* Filter
* Sort
* New comment
* New note
* Format cells
* Insert link
* Copy link
* Show changes

My ribbon at the top does not have Format:
* File
* Home
* Insert
* Share
* Page Layout
* Formulas
* Data
* Review
* View
* Automate
* Help
* Draw

I feel like I'm taking crazy pills because everything online suggests that there is a Format tab, there is a Remove Hyperlink button, etc.
I can tip fg if needed

This post was edited by Badgerboys on Jul 29 2024 05:45pm

Your sheet must be pretty old, given my personal test doesn't reflect your menus at all.

As a quick workaround, you can try the following:

1) Select your column -> Cut
2) Press delete or select Clear contents
3) Paste special -> values only

Hope this helps.

would have to get on a shared screen to see what you're doing hands on and i should be able to help you