Hi. Today, We will talk about what a people chip in Google Sheets. What is news that should surprise you about Google Sheets, a web-based collaborative program? In Google Sheets, what does a People chip mean? A smart chip called a “People chip” in Google Sheets lets you label or assign any pertinent users to cells in your spreadsheet. A significant transformation in Google Sheets’ collaborative tools has been brought about by a People chip. We will learn how to add a People chip in Google Sheets in this guide. So, without wasting any time, let’s proceed.
Key Advantages of a People Chip in Google Sheets
Google Sheets’ People chip gives you some more ways to get in touch with a certain person. For example, Google Sheets displays a dialogue window with the individual’s contact information when you hold your mouse over a People chip, allowing you to get in touch with that person directly if necessary.
A quick view of who has access to the spreadsheet, who has recently updated it, or who is presently reading it can be provided via a People Chip. This could enhance accountability and transparency.
In Google Sheets, you can also mention someone in your document to see, suggest, or update your work.
You may also like>>> How to Use Sparkline in Google Sheets [Multiple Use Cases]
How to Insert a People Chip in Google Sheets
It’s incredibly fair and simple to insert a People chip in Google Sheets. With just a few clicks, Google Sheets allows you to add a People chip. Like referencing someone on a social media site, it is the same thing. In this article, we’ll learn how to insert a People chip in Google Sheets using two separate methods.
Insert a People chip in Google Sheets using the “@” sign.
Insert a People chip in Google Sheets using the Smart chip option.
Section 1:
Insert a People chip in Google Sheets Using the “@” sign
As I mentioned earlier, creating a People chip in Google Sheets is really simple; all you need to do is write a “@” symbol before entering the person’s email address. Here are some specific examples I’ll use to show you.
Step 1>
You must first choose the location where you want to put a People chip in Google Sheets and then place your cursor there in order to proceed with the process.
Step 2>
After positioning the cursor, go to edit mode and type the “@” symbol as seen in the image below.
Step 3>
A drop box with some people’s recommendations will display in front of you when you type the “@” symbol, as seen in the next image as well.
Step 4>
Simply click once on anyone in Google Sheets who you wish to build a person’s chip for. Your person’s chip will be installed as seen in the example below.
This is how we can easily Insert a People chip in Google Sheets using the “@” sign.
Section 2:
Insert a People chip in Google Sheets Using the Smart chip option
Although the way described above is sufficient to create a People chip in Google Sheets, it can face certain problems as well. To avoid these interruptions, the method described below is more practical. Use the following technique to create a people chip in Google Sheets, for example, if you were creating a people chip by composing an email but didn’t receive the result because the email was invalid or for any other reason.
Step 1>
In order to add a People chip to a Google Sheet, you must first choose the cell, as I have done in the example below.
Step 2>
Once you’ve decided which cell in Google Sheets will hold your person’s chip, click the “Insert” tab from the menu bar as seen in the example below.
Step 3>
When you select the “Insert” tab from the menu bar, a drop-down menu will appear with the option “Smart chips” as seen in the following screenshot. Click on it to open it in a new window.
Step 4>
As seen in the next image, selecting the “Smart chips” option will open a new, extended menu where you will initially see the “People” option. To add a People chip to Google Sheets, click on it.
Step 5>
You will automatically be sent to the cell with a “@” sign and some people’s suggestions as soon as you select the “People” option, as seen below.
Step 6>
If the person you wish to add to Google Sheets as a person’s chip is not listed here, it’s possible that they will not be referenced elsewhere. In that case, just add their email address after the “@” symbol.
Step 7>
Simply press the Enter key after entering the recipient’s email address, and if the email is authentic, the recipient’s email address will be automatically converted into a People chip as seen below.
So, this is how we can easily Insert a People chip in Google Sheets using the Smart chip option.
Additional Section:
How to Remove a People Chip in Google Sheets?
If, for example, you accidentally added a people chip to Google Sheets or if you wanted to write any text with the @ sign and it turned into a people, then don’t worry; there is a method in Google Sheets by which you can delete the people chip.
Step 1>
The following picture shows how a people chip is already present in the cell. Simply click the right mouse button on a person’s chip to remove it.
Step 2>
When you right-click on a cell, a large dialogue box with many options will appear. Choose “Smart chip” from these options.
Step 3>
When you select the “Smart chip” option, a new enlarged menu will appear with the “Remove smart chip” choice highlighted in the image below.
Step 4>
When you click the “Remove smart chip” option, your people’s chip will be immediately erased from the selected cell and transformed into the plain text as shown below.
Often Asked Questions 1:
How do you make an email at People Chip?
Google Sheets displays a people suggestion box when we insert a people chip; if your desired person is not listed, you can create a people chip by simply writing an email. If an email is written but does not result in a people chip, you can use the instructions below to create a people chip in Google Sheets.
Step 1>
Write the email you want to turn into a person’s chip in the Google Sheets cell you want it to appear in as you’ll see in the example below.
Step 2>
Following the email, open Google Sheets and select the “Insert” tab from the menu bar. Then, from the drop-down menu, select the “Smart Chips” option.
Step 3>
When we select “Smart chips“, another menu will appear. From this menu, we must select “Convert to people chip“, which is highlighted in the following image.
Step 4>
You are almost finished with the process; the next image shows the final result. In Google Sheets, your email has been transformed into a people chip.
Often Asked Questions 2:
How to notify the person mentioned in People Chip in Google Sheets?
In Google Sheets, a People chip allows you to designate important people in your spreadsheets; however, if you also want to alert those people that they are a part of our document, you can do so by adding a label to them as well. To achieve this, follow the instructions in the step-by-step method below.
Step 1>
In the cell below, we have typed an email stating that we intend to create a “People chip” and want to inform the person. Let’s start by using the smart chip on this email.
Step 2>
The following tiny dialogue box, which asks you whether or not to alert the person, shows on your Google Sheets screen when you make your email a People chip. To alert the person mentioned, click the “Share” button.
Step 3>
When you click the “Share” button, the file access permissions will be displayed in front of you. Choose the level of access you wish to grant the user you are specifying from the following highlighted options.
Step 4>
Once all of those steps have been achieved, simply click the “Share” button. The people you specified in the People chip will be called shortly.
You may also like>>> How to Create a Bubble Chart in Google Sheets [Advance Guide]
Conclusion
After reading this article regarding the “People Chip” concept in Google Sheets, any remaining questions you may have had about it should be cleared up. We hope that the details we provided helped to make clear this feature’s purpose and possible benefits. If you have any more questions or need more information, do visit OfficeChaser. There, you can find even more useful tools and information to help you with your Google Sheets projects.
