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 And then Smart chip And then 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 And then 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 And then 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 And then Dropdown.
    • Click Data And then Data validation And then Add rule  .
    • Right click on a cell And then Dropdown.
  3. To make changes to a dropdown, click the dropdown and select an option. To edit a dropdown's options, click the dropdown And then Edit button .

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

Was this helpful?
How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
true
true
true
true
35
false
false