Google Sheets now helps “individuals chips,” which let you tag an individual inside a cell.
Individuals chips are helpful for notifying customers after they have been talked about in a doc, assigning duties to people, and making spreadsheet information richer.
Associated publish: Higher Google Docs with “good chips!” (4 concepts on your classroom)
Individuals chips hyperlink to a person profile, giving fast visibility into further details about the particular person.
If you enter an e-mail deal with into Google Sheets, you may be prompted to transform the information right into a individuals chip.
There are a variety of conditions the place individuals chips may cause points.
- Exporting a .csv file (individuals chips should not transformed again into e-mail addresses)
- Utilizing formulation to switch or extract information from e-mail addresses
- Making a mail merge.
I lately bumped into a difficulty the place somebody despatched me a spreadsheet with individuals chips as a substitute of e-mail addresses. I wanted to view the precise e-mail deal with so I used to be confronted with the duty of eradicating the individuals chips.
Based on Google, you’ll be able to take away individuals chips from Google Sheets by right-clicking on a cell, deciding on “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 tactic I used to take away individuals chips from my Google Sheet:
- Choose a number of cells that comprise a individuals chip.
- Press ctrl + / in your keyboard (clear formatting)
- Your individuals chips at the moment are common e-mail addresses!
The keyboard shortcut ctrl + / removes textual content formatting. I exploit it on a regular basis when I’m copying info from one place to a different and don’t need any of the formatting choices to be copied. Luckily, this trick works with individuals chips as nicely!
Associated publish: Chromebook Keyboard Shortcuts
Learn how to disable individuals chips in Google Sheets
At this level I hoped to point out you how one can disable individuals chips fully so that you just don’t must take away them manually.
Sadly, that doesn’t appear to be an choice as of Might 2022, based mostly on this assist thread.
Whereas individuals chips may be useful, they’ll additionally trigger points in some conditions. Hopefully Google will add the power to disable individuals chips sooner or later.
For now, we’re caught with eradicating them manually.
