Excel , Delete Comments How To Format A
Excel , Delete Comments Mac If You
Excel , Delete Comments Code On An

Other users are able to leave comments on data in your cells, allowing you to see their thoughts and possible apply some changes.

But if a comment was added inadvertently, or if theres an existing comment that you dont need anymore, then you might want to delete it.

Fortunately you have control over comments in Excel, including the ability to delete them.

How to Delete an Excel for Office 365 Comment The steps in this article were performed in the desktop version of the Microsoft Excel for Office 365 application.

In Excel for Office 365 you can tell that a cell has a comment by a maroon symbol at the top-right corner of the cell.

There isnt any kind of confirmation when you delete a comment.

Excel , Delete Comments How To Format A

Find out how to format a cell as currency but without the dollar sign if you dont want to display any currency symbols next to your cell values.

Excel , Delete Comments Code On An

Share this: Click to share on Twitter (Opens in new window) Click to share on Facebook (Opens in new window) Click to email this to a friend (Opens in new window) Click to share on LinkedIn (Opens in new window) Click to share on Reddit (Opens in new window) Click to share on Pinterest (Opens in new window) Click to share on Tumblr (Opens in new window) Related Join Our Newsletter Filed Under: Excel Join Our Newsletter Recent Posts How to Delete a Comment in Excel for Office 365 How to Add a Textbox on Google Slides How to Highlight in Google Docs How to Make Google Slides Vertical More How-To Guides How Can I Tell How Many Days Are Left Before the Next Friendship Level in Pokemon Go How to View Saved Passwords in Firefox What is a Restrictions Passcode on an iPhone How to Add Fonts to Photoshop CS5 How to Freeze the Top Row in Google Sheets iPhone Excel About Contact Disclaimer Privacy Policy Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.

Copyright 2020 Live2Tech.com Send to Email Address Your Name Your Email Address Cancel Post was not sent - check your email addresses Email check failed, please try again Sorry, your blog cannot share posts by email.

The process can become time-consuming; if you have a lot of data.

Instead of going through the workbook, and deleting each blank cell individually, you can make multiple selections and let Excel do the work for you.

Using this method is a real time-saver, compared to performing the same action manually.

To do so, highlight just the range of data containing the blank cells.

Under the Home tab Editing group click Find Select and then click Go To Special.

Youll see that Excel made a non-adjacent selection of all the blank cells in the spreadsheet.

From the Home tab, under the Cells group, click Delete and then choose whether you want to delete the blank cells in rows or columns.

Excel , Delete Comments Mac If You

Using Excel 2016 for Mac If you are using the Mac version of Excel, you can find this function under Edit Find Go to.

Thats all there is to it This makes it much easier to create cleaner spreadsheets and workbooks for your boss.

Also, youre running an older version of Excel, be sure to read our previous article on how to remove empty cells in Excel 2010 or 2007.

Thats what comes up, and when you click OK nothing happens as a result.

Please advise. Reply Leave a Reply Cancel reply Your email address will not be published.

For more details, please read our Privacy Policy and Terms of Service.

Excel For Mac, Delete Comments