What Does the Assign To Checkbox Do in Excel Comments?
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.

- 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.
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.
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.
Click on the cell in your Excel workbook where you want to leave a comment or task for your colleague.
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.
Type the '@' symbol followed by the name or email address of the person you want to assign the task to.
Once the contact is recognized, check the 'Assign to [Name]' box that appears directly below your comment text.
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.

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. Open your Spreadsheet: Launch WPS Office and open your workbook.
- 2. Insert a Comment: Select the cell where you want to leave a note, navigate to the 'Review' tab, and click 'New Comment'.
- 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.

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.




