Add a people chip in Google Sheets
Use the table header menu to change the "Owner" column type to People chip. Leave the cells blank and do not change the Project values.
Verified by JosephineAbout 60 secondsUse the table header menu to change the "Owner" column type to People chip. Leave the cells blank and do not change the Project values.
Step-by-step
Select the targetUse the table header menu to change the "Owner" column type to People chip.
Apply the changeLeave the cells blank and.
Shortcut or faster method
Select the full target range first. This avoids repeating the same change cell by cell.
Expected result
The Owner table column is configured as a People chip column.
Common mistake
Changing the source values while applying the formatting or structure change.
Troubleshooting
Undo the last change, reselect the intended range, and try again. The Owner table column is configured as a People chip column.
Example spreadsheet data
This is the clean fixture used for the verified run.
| Project | Owner |
| Website refresh | |
| Quarterly report | |
| Launch plan |
Video transcript
- Open the prepared Practice spreadsheet.
- Select the target. Use the table header menu to change the "Owner" column type to People chip.
- Apply the change. Leave the cells blank and.
- The Owner table column is configured as a People chip column.