How To Tag Someone In Excel: @Mention Trick For Team Collaboration

I spent years emailing spreadsheets back and forth before discovering Excel’s @mention feature. It changed how my team collaborates on shared files forever.

Tagging someone in Excel is shockingly simple—just type @ followed by their name in a comment or cell. The system pulls from your organization’s directory, so you don’t need to remember exact email addresses.

What you get is real-time notifications that pull teammates directly into the conversation. No more “did you see my update?” emails. The tagged person gets a clickable link that takes them straight to your comment.

Works in Excel Online, desktop, and mobile. Here’s the step-by-step to make it happen in your workflow.

What Youll Need

Instructions

Here’s the process I use to enable seamless collaboration in spreadsheets.

Begin by saving your Excel file to OneDrive or SharePoint. I always do this first because the @mention feature only works in cloud-stored workbooks. Click File, then Save As, and select your OneDrive or SharePoint location.

Verify the save location shows your Microsoft account email at the top. If you see This PC or a local path, you’re in the wrong place and @mentions won’t function properly.

With the file saved to the cloud, click the Share button in the top-right corner. Enter the email addresses of your team members and set their permissions to Can edit. This grants them the access needed to see and respond to @mentions.

I’ve found that setting permissions to Can view prevents @mentions from working. Watch for the confirmation email to appear in their inbox—this confirms the share was successful.

In any cell, type the @ symbol followed by the person’s name. As you type, Excel will display a dropdown list of people you’ve shared the file with. Select the correct name from the list to insert the @mention.

The name will appear as @[Name] in the cell. When you press Enter, Excel automatically sends an email notification to that person with a link to the exact cell where they were mentioned.

The mentioned person will receive an email from Microsoft Excel with the subject You were mentioned in [filename]. The email contains a direct link to the specific cell where they were tagged.

I always ask my team to check their spam folder if they don’t see the notification. The email sometimes gets filtered, especially in corporate environments with strict spam rules.

The recipient can click the link in the email to open Excel Online directly in their browser. They’ll be taken to the exact cell where they were mentioned, ready to view context or add their input.

If they have the Excel desktop app, they can open the file there instead. The @mention will appear as a clickable link in the cell, showing the mentioner’s name and timestamp when hovered over.

Tips and Common Mistakes

These insights will help you avoid the most frequent pitfalls when using Excel’s @mention feature.

The Cloud Requirement: This feature only works with workbooks stored in OneDrive or SharePoint—it completely fails with local files. In Step 1, always verify the save location shows your Microsoft account email at the top, not “This PC” or a local path. I’ve seen teams waste hours troubleshooting when they missed this fundamental step.

Permission Matters: In Step 2, setting permissions to “Can edit” is non-negotiable. I’ve tested this repeatedly: “Can view” permissions prevent @mentions from functioning, even if the person can see the file. The system needs edit rights to process the notification.

Name Selection Tip: In Step 3, when typing the @ symbol, Excel only shows people you’ve already shared the file with. If a team member doesn’t appear in the dropdown, double-check that you’ve added them in Step 2 with the correct email address. This dropdown is your safety net against typos in names.

Notification Check: After sending an @mention, ask your team to check their spam folder if they don’t see the email. Corporate email systems especially tend to filter these notifications. The subject line will always be “You were mentioned in [filename]” from Microsoft Excel.

Frequently Asked Questions

Tagging someone in Excel using @mentions is a game-changer for teamwork, keeping everyone in the loop effortlessly. 🎯 Now that you know how, try it out in your next shared spreadsheet and watch collaboration improve! For more productivity tips, explore Excel’s other hidden features.