K2E Canada Inc
  • Home
  • TRAINING
    • WEBINARS
    • ROAD TO EXCELLENCE ONLINE SEMINAR
    • SEMINARS
    • TECHNOLOGY CONFERENCE
    • INSTRUCTORS
  • NEWSLETTER
    • Signup
  • ABOUT
  • CONTACT
  • BLOG
  • Home
  • TRAINING
    • WEBINARS
    • ROAD TO EXCELLENCE ONLINE SEMINAR
    • SEMINARS
    • TECHNOLOGY CONFERENCE
    • INSTRUCTORS
  • NEWSLETTER
    • Signup
  • ABOUT
  • CONTACT
  • BLOG

Collaborating with Excel Comments

12/3/2020

 

Excel Comments Renamed Back to Excel Notes

Originally Excel had a feature called Notes that allowed us to add a note to a cell to provide additional information for ourselves or others. Then around 2000 Excel renamed them to comments. Now Excel is changing the name back to notes and introducing a new feature, starting with 1810, Comments. 

Notes are a great way to add instructions, details, and explanations in our workbooks. With this change of name all the features of what we use to call comments remains including changing the shape, fill the background, and edit. All the commands are still available on the right mouse menu or the Review ​tab on the ribbon. 
Picture

You can take existing notes in a workbook and Convert to Comments ​as shown in the Notes drop down menu above.

The All New Excel Comments

The new Excel Comments provide improved collaboration with a threaded discussion. Using @mentions draws collaborators attention directly to your comments. When an @mention is made the person will receive an email with a link to the file to provide them with quick access and a simple response option. (The file must be shared with them or in a location they have access permissions) To create a comment you can right click the cell or select New Comment on the Review tab.  Once your comment is completed click the Green arrow to send the comment to any @mentions you have included.
Picture
Note the new indicator icon in the top left of the cell containing a comment and the specific cell reference in the comment. 

A sample of the email received by Demo is below, note the link to quickly open the file.
Picture

Selecting the Show Comments command on the Review tab opens a floating panel of comments on the right side of Excel. The panel shows the comments for the current sheet and can be moved to a different location including another monitor. This provides a view of all the comments for the sheet without hiding any information on the worksheet.  The Previous Comment and Next Comment commands on the review tab provide a quick way to review all comments in a file, quickly flipping from worksheet to worksheet as required. 
Picture

Since comments do not show on the sheet when selecting the Comments options on the sheet tab of Page Setup selecting As displayed on sheet will only print notes. Selecting At end of sheet will print both notes and comments. 
Picture

The new comments in Excel is a welcome addition, providing a simple threaded conversation within our files to keep everyone current on the changes, items requiring their attention, and responses.
notes_and_comments.xlsx
File Size: 131 kb
File Type: xlsx
Download File

Ward Blatch, CPA CA

Muhammad link
7/26/2022 07:18:22 am

Excellent i was searching for this sort of help & you explained it very well. keep it up the good work


Comments are closed.

    Categories

    All
    2022
    Accountant
    Accounting Software
    Accounting Solutions
    Adobe
    Advisory
    AI
    Artificial Intelligence
    Automation
    Backup
    Bitcoin
    Blockchain
    Business Automation
    Business Continuity
    Business Intelligence
    Business Management
    Cloud Computing
    Collaborate
    Collaboration
    Colonial
    Computer
    COVID 19
    COVID-19
    CPA
    CRM
    Cryptocurrency
    Customer Relationship Management
    Cybersecurity
    Cyptocurrencies
    Dext
    Doc.It
    Ecommerce
    Emerging Technologies
    Entrepreneurs
    Excel
    Forecasting
    Forecast Sheet
    Google
    Grammarly
    HR
    Internal Controls
    Internal Priorities
    KPIs
    LET
    Links
    Management Reports
    Microsoft 365
    Microsoft Office 2021
    Microsoft Teams
    Office
    Office 365
    Online Shop
    Outsourcing
    Pandemic
    Paperless
    Personal Computer
    PivotTables
    Power Automate
    Power BI
    PowerPoint
    Productivity
    QuickBooks
    Quickbooks Online
    Ransomware
    Receipt Bank
    Remote Work
    RPA
    Sage 50
    Security
    Small Business
    Small Business Accounting
    Small Business Accounting Software
    Stockhistory
    Technologies
    Technology
    Tech Update
    Windows
    Windows 10
    Windows 11
    Word
    Work At Home
    Workflow
    Work From Home
    Xcm
    Zoho
    Zoho CRM

    Authors


    Ward Blatch
    Ward provides consulting and training services as the Managing Director of K2E Canada Inc. He joined K2E Canada in 2005 and is responsible for the Canadian operations of this international consulting group, which provides professional development technology education for accountants across Canada and the US. Ward lives in rural Nova Scotia and can be reached at ward@k2e.ca.

    Tommy Stephens
    Tommy is one of the shareholders in K2 Enterprises, affiliating with the Firm in 2003 and joining as a shareholder in 2017. At K2, Tommy focuses on creating and delivering content and is responsible for many of the Firm's management and marketing functions. Tommy resides in the metro Atlanta area. You may reach him at tommy@k2e.com.

    Randy Johnson
    Randy is a nationally recognized educator, consultant, and writer with over 40 years experience in Strategic Technology Planning, Accounting Software Selection, Paperless, Systems and Network Integration, Business Continuity and Disaster Recovery Planning, Business Development and Management, Process Engineering and outsourced managed services. Randy can be reached at randy@k2e.com


    Bernie Smith
    Bernie coaches businesses to develop meaningful KPIs and present their management information in the clearest possible way to support good decision making. As the owner of Made to Measure KPIs, he has worked with major organisations including HSBC, Airbus, UBS, Barclays, Credit Suisse, Lloyds and many more.

    RSS Feed

Training & Education

Webinars
Road to Excellence Online Seminar
Seminars
Conferences
Instructors

Tech News

K2E Canada's Tech Update Newsletter

More

Privacy Policy
About
Contact

K2E Canada Inc.  |  484 Scarlett Crescent  |  Burlington, ON L7L 5M2  |  (902) 200-9207
© 2022 K2E Canada Inc. ALL RIGHTS RESERVED.