Insert smart chips in your Google Sheets

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.

1. On your computer, open a spreadsheet in Google Sheets.
2. Enter "@".
3. To narrow your options, select from the pop-up list or enter:
   • Letters
   • Numbers
   • Symbols
4. 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.
5. To view information, hover your mouse over the chip.

Convert emails to people chips in Google Sheets

1. On your computer, open a spreadsheet in Google Sheets.
2. Select a range of cells with email addresses. 
3. At the top, click Insert Smart chip People. 
4. You can also convert an email address to a people chip:
   1. Right-click on a cell.
   2. Click Convert to people chip.

Tips:

1. Cells don’t convert if:
   • They’re not formatted as email addresses.
   • They have invalid email addresses.
2. You can make format changes to people chips, such as:
   • Color
   • Size
   • Font style
3. To remove format changes, click Clear formatting.
4. 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

1. On your computer, open a spreadsheet in Google Sheets.
2. Select a range of cells with links.
3. Point to the preview.
4. 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

1. On your computer, open a spreadsheet in Google Sheets.
2. 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.
3. To make changes to a dropdown, click the dropdown and select an option. To edit a dropdown's options, click the dropdown  Edit button .

Learn more about how to create an in-cell dropdown list.