Editing A Comment In Excel For Mac

Don’t like the user name set in Excel 2016/2013/2010 for comments? This post is intended to introduce how Excel users could change or remove author name of specified comment, or all new or existing comments.

In Windows you can delete a comment on the keyboard as follows: Shift + F10 to open right-click menu Type 'm' to Delete comment In Excel 2016 on a Mac, you can actually type letters to select menu items in the right-click menu. For example 'e' will select 'Edit comment'. However, there doesn't seem to be a key that selects the Delete comment item. In Pages on your Mac, add comments to text, images, tables, and other objects. Toolbar or Comments & Changes sidebar to review and edit the comments.

Change author name temporarily for specified comment:

When you edit the comment in Excel, author name also can be changed at the same time.

1. Select the cell you want to change comment author.
2. Click Review tab and choose Edit Comment option in Comments group.

Then you can edit the comment and change the comment author name.

But if you don’t like to change the author name every time when you add comment, how can you do? Now let’s learn to change author name of new or existing comments permanently.

Change author name of new comments:

If you don’t want to use the same author name in new comments, follow the steps to change new comment author name.

1. Click File > Options in Excel 2016/2013/2010 or click Office button > Excel Options > Popular in Excel 2007.

2. In Excel Options dialog, click General in the left pane, and then go to Personalize your copy of Microsoft Office in the right pane, change the User name to new one and click OK.

From then on, you can add new comments with new author name.

Change author name of all existing comments in workbook:

If you want to change existing comments author name, Kutools for Excel would help you to do easily.

1. Open the workbook you want to change the existing comment owner name.

2. Click Kutools > More in Editing group, and select Find/Replace Comment Text.

3. In the Find/Replace Comment Text dialog, set parameters like these.

Scope: select All sheets if you plan to change author name for all the comments in this workbook. If not, just select the Active sheets to do for the sheet you are inside.

Find text in comments: enter old author name in existing comments.

Replace with:Arabic writing software. enter new author name to replace old one in existing comments.

4. Click Replace and OK button and all existing comments author name are changed to specified one.

If you don’t want author name appear in any existing comment, just follow the steps to remove comment author name in Excel.

Remove author name of existing comments in Excel:

1. In opening workbook, click Kutools > More > Remove/Add User Name in Comment.

2. In the Remove/Add User Name in Comment dialog, set some parameters.

Scope: select All sheets from drop-down list for all the comments in this workbook, or choose Active sheets for the current sheet.

User Name: enter the user name that you want to remove from existing comments.

3. Click Apply and OK button on pop-up dialog, and existing comment user name are removed.

Related Articles:

How to change the shape of comment box in Excel?

We always insert comments into the Excel cells, so that we can attach additional information to use. By default, the comment box is square. If we want to change the shape of comment, how could we do?

Mike Ladd - Welcome To The Afterfuture.mp3. Mike Ladd Welcome To The After Future Zippyshare Upload Rating: 7,9/10 6053reviews Mike Ladd – Welcome To The Afterfuture (2015) Artist: Mike Ladd Title Of Album. 5000 Miles West Of The Future (3:47) 02. Mike Ladd Welcome To The Afterfuture Zip. 9/19/2018 0 Comments Payment Security We take the security of our website and of your transactions extremely seriously. We encrypt all traffic involving personal data with industry-standard SSL certificates and we are also PCI compliant - meaning that we follow all current data security standards. Mike Ladd; Welcome To The Afterfuture; Welcome To The Afterfuture. Welcome To The Afterfuture (Bonus Track Version) Mike Ladd. Watch videos & listen free to Mike Ladd - Welcome To The Afterfuture: No.1 st, Welcome to the Afterfuture & more. Get a $75.00 statement credit after first Amazon. 1 5000 Miles West Of The Future 2 Airwave.

• Reuse Anything: Add the most used or complex formulas, charts and anything else to your favorites, and quickly reuse them in the future.
• More than 20 text features: Extract Number from Text String; Extract or Remove Part of Texts; Convert Numbers and Currencies to English Words.
• Merge Tools: Multiple Workbooks and Sheets into One; Merge Multiple Cells/Rows/Columns Without Losing Data; Merge Duplicate Rows and Sum.
• Split Tools: Split Data into Multiple Sheets Based on Value; One Workbook to Multiple Excel, PDF or CSV Files; One Column to Multiple Columns.
• Paste Skipping Hidden/Filtered Rows; Count And Sum by Background Color; Send Personalized Emails to Multiple Recipients in Bulk.
• Super Filter: Create advanced filter schemes and apply to any sheets; Sort by week, day, frequency and more; Filter by bold, formulas, comment..
• More than 300 powerful features; Works with Office 2007-2019 and 365; Supports all languages; Easy deploying in your enterprise or organization.

Change the shape of comment box with Change Shape Command

With this method, you need to take a bit more effort, because it is some complex. Please do as follows:

The first step is to add the Change Shape command to the Quick Access Toolbar (QAT):

1. Right-click the QAT, and click Customize Quick Access Toolbar, see screenshot:

2. In the Excel Options dialog box, click Choose commands from drop down list to select Drawing Tools丨Format Tab, and then in the list of commands, click Change Shape, then click Add button to add the Change Shape into Quick Access Toolbar.

3. Then click OK to close the Excel Options dialog box.

The second step is to change the comment box, do as this:

1. Select the cell contains the comment that you want to change the comment box.

2. On the Ribbon, click Review > Edit Comment, see screenshot:

3. Then click the border of the selected comment, it changes to a bunch of small dots. See screenshot:

4. Then on the Quick Access Toolbar, click Change Shape button, and select the shape that you like, see screenshot:

At the same time the selected comment box has been changed. See screenshot:

With this way, you can change only one comment shape at a time, if you want to change others, repeat the second step.

Change the shape of comment box with Kutools for Excel

The Kutools for Excel’s Change Comment Shape can help you change all of the comment boxes at once quickly and easily.

Kutools for Excel includes more than 300 handy Excel tools. Free to try with no limitation in 30 days. Get it Now.

When you have installed Kutools for Excel, please do as following steps:

1. Click Kutools > More > Change Comment Shape, see screenshot:

2. And all of the comments of the whole workbook have been listed in the Comment list box, then choose a shape that you like from the Select shape box. See screenshot:

3. Click Apply All button, and the selected shape have been applied to all of the comments. See screenshot:

Click Change Comment Shapeto know more about this feature.

Related articles: