Insert smart chips in your Google Sheets to include information about:
- Users with Gmail or Google Workspace email addresses
- Other Google Docs, Sheets, or Slides files
With a smart chip in your spreadsheet, you can hover on or click a chip for more information.
Add smart chips for people & files
Important: When you @mention a user in a smart chip, they don't automatically get access to your document. To let another user get access, share your document.
- On your computer, open a spreadsheet in Google Sheets.
- Enter "@".
- To narrow your options, select from the pop-up list or enter:
- Letters
- Numbers
- Symbols
- To add:
- People smart chip: Enter a name or email.
- File smart chip: Enter the file name or related keywords.
- Event smart chip: Enter the calendar event name or related keywords.
- To view information, hover your mouse over the chip.
Convert emails to people chips in Google Sheets
- On your computer, open a spreadsheet in Google Sheets.
- Select a range of cells with email addresses.
- At the top, click Insert
Smart chip
People.
- You can also convert an email address to a people chip:
- Right-click on a cell.
- Click Convert to people chip.
Tips:
- Cells don’t convert if:
- They’re not formatted as email addresses.
- They have invalid email addresses.
- You can make format changes to people chips, such as:
- Color
- Size
- Font style
- To remove format changes, click Clear formatting.
- To remove a people chip and revert the cell to an email address, right-click on a cell, click View more cell actions
Remove smart chip.
Convert links to file chips in Google Sheets
- On your computer, open a spreadsheet in Google Sheets.
- Select a range of cells with links.
- Point to the preview.
- At the bottom of the file preview, click Convert to file chip.
Tips:
- You can make format changes to file chips such as:
- Color
- Size
- Font style
- To remove formatting, click Clear formatting.
- To convert links to File Chips, select an option:
- Right-click a cell or group of cells , then click Convert to chip.
- Click Insert
Smart chips.
Add dropdown chips
You can add and customize dropdown chips that display multiple options.
Add or edit a dropdown
- On your computer, open a spreadsheet in Google Sheets.
- Select an option:
- Enter “@.” In the Menu, under the components section, click “Dropdowns.”
- At the top, click Insert
Dropdown.
- Click Data
Data validation
Add rule
.
- Right click on a cell
Dropdown.
- To make changes to a dropdown, click the dropdown and select an option. To edit a dropdown's options, click the dropdown
Edit button
.