Google Sheets now helps “individuals chips,” which let you tag an individual inside a cell.
Individuals chips are helpful for notifying customers once they have been talked about in a doc, assigning duties to people, and making spreadsheet information richer.
Associated publish: Higher Google Docs with “sensible chips!” (4 concepts in your classroom)
Individuals chips hyperlink to a person profile, giving fast visibility into extra details about the particular person.
Once you enter an e mail tackle into Google Sheets, you may be prompted to transform the information right into a individuals chip.
There are numerous conditions the place individuals chips could cause points.
- Exporting a .csv file (individuals chips aren’t transformed again into e mail addresses)
- Utilizing formulation to switch or extract information from e mail addresses
- Making a mail merge.
I not too long ago bumped into a difficulty the place somebody despatched me a spreadsheet with individuals chips as an alternative of e mail addresses. I wanted to view the precise e mail tackle so I used to be confronted with the duty of eradicating the individuals chips.
In line with Google, you possibly can take away individuals chips from Google Sheets by right-clicking on a cell, choosing “view extra cell actions,” after which “take away individuals chip.”
This did NOT work for me. The choice merely wasn’t there. 🤷♂️
I attempted altering the information formatting, however that didn’t work both.
That is the strategy I used to take away individuals chips from my Google Sheet:
- Choose a number of cells that include a individuals chip.
- Press ctrl + / in your keyboard (clear formatting)
- Your individuals chips are actually common e mail addresses!
The keyboard shortcut ctrl + / removes textual content formatting. I exploit it on a regular basis when I’m copying data from one place to a different and don’t need any of the formatting choices to be copied. Happily, this trick works with individuals chips as effectively!
Associated publish: Chromebook Keyboard Shortcuts
Methods to disable individuals chips in Google Sheets
At this level I hoped to point out you how you can disable individuals chips completely so that you just don’t need to take away them manually.
Sadly, that doesn’t appear to be an possibility as of Might 2022, primarily based on this help thread.
Whereas individuals chips could be useful, they will additionally trigger points in some conditions. Hopefully Google will add the flexibility to disable individuals chips sooner or later.
For now, we’re caught with eradicating them manually.
