Office Settings & Configuration

What Does the Assign To Checkbox Do in Excel Comments?

Jason MillerJason Miller Nov 3, 2026 869 views

Question details

The user wants to understand the function of the 'Assign to' checkbox in new Excel comments, specifically regarding task creation and email notifications.

Understanding the Assign To Checkbox in Excel Comments
Product
Excel
Device & OS
not provided
Scenario
Collaborating on an Excel spreadsheet and using the @mention and commenting features to delegate work.
Observed behavior
Selecting the 'Assign to' checkbox sends an email notification to the mentioned user but does not create a traditional Outlook or Microsoft To Do task, causing confusion about its intended purpose.
Before you start

Ensure your workbook is saved to OneDrive or SharePoint and that you are signed into your Microsoft 365 account, as modern comments and assignment features require cloud connectivity.

Solution 1Recommended

How the 'Assign to' Feature Works in Modern Excel

Learn the primary function of the 'Assign to' checkbox and how it notifies colleagues within modern Excel comments.

The 'Assign to' checkbox in modern Excel comments is designed specifically for in-document collaboration. When you assign a comment to someone, it triggers an email notification containing a direct link to the specific comment in the spreadsheet.

It is important to understand that this action does not integrate with your broader task management tools. It will not create a traditional task in Microsoft To Do or Outlook Tasks; it simply flags the comment for their attention within the workbook ecosystem.

1
Select the target cell

Click on the cell in your Excel workbook where you want to leave a comment or task for your colleague.

2
Insert a modern comment

Navigate to the 'Review' tab on the ribbon and click 'New Comment', or right-click the cell and choose 'New Comment' from the context menu.

3
Mention your colleague

Type the '@' symbol followed by the name or email address of the person you want to assign the task to.

4
Check the Assign To box

Once the contact is recognized, check the 'Assign to [Name]' box that appears directly below your comment text.

5
Post the comment

Click the green 'Send' arrow icon or press Ctrl+Enter to post the comment. This will immediately trigger the email notification to the assigned user.

How the 'Assign to' Feature Works in Modern Excel
Version Compatibility: The 'Assign to' feature and modern comments are only available in Microsoft 365 subscriptions and Excel for the web. Older standalone versions like Excel 2016 or 2019 use traditional notes which do not support this feature.
WPS Spreadsheet Collaboration

Collaborate and Manage Comments Easily in WPS Spreadsheet

WPS Office offers an intuitive and seamless way to add, track, and manage comments in your spreadsheets. You can easily collaborate with team members using threaded conversations without worrying about complex email and task integrations.

  1. 1. Open your Spreadsheet: Launch WPS Office and open your workbook.
  2. 2. Insert a Comment: Select the cell where you want to leave a note, navigate to the 'Review' tab, and click 'New Comment'.
  3. 3. Manage Conversations: Type your feedback in the comment box. Team members can easily reply to existing comments to keep track of the conversation directly within the file.
Insert and manage threaded comments easilyFully compatible with Microsoft Excel (.xlsx) filesLightweight, fast, and free to useClear user interface for tracking document changes
microsoft office alternative - wps office

Frequently Asked Questions

Does assigning a comment in Excel create an Outlook task?

No, assigning a comment in Excel only sends an email notification to the assigned person with a link to the workbook. It does not automatically create a task item in Microsoft Outlook or Microsoft To Do.

Why didn't my colleague receive an email when I assigned a comment?

Email notifications for assigned comments rely on active cloud connectivity. Ensure the Excel file is saved in OneDrive or SharePoint, the sharing permissions allow the user to access the file, and that you are connected to the internet.

How do I resolve an assigned comment in Excel?

Hover over the cell containing the comment, click on the comment box to expand it, and click the 'Resolve thread' button (usually represented by a checkmark icon). This marks the discussion as complete but keeps it in the file history.

Can I use the 'Assign to' feature in older versions of Excel?

The 'Assign to' checkbox is part of the modern comments feature, which is exclusive to Microsoft 365 and Excel for the web. Older versions utilize standard notes, which do not include @mentions or assignment capabilities.