Simon Sez IT

Online software training and video tutorials for Microsoft, Adobe & more

  • Course List
    • Adobe
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Flash
        • Flash CS5
      • InDesign
        • InDesign CS6
        • InDesign CS5
      • Photoshop
        • Photoshop CS6
        • Photoshop CS5
        • Adobe Photoshop CS4
      • Photoshop Elements
        • Photoshop Elements 2022
        • Photoshop Elements 2019
        • Photoshop Elements 2018
        • Photoshop Elements 15
        • Photoshop Elements 14
        • Photoshop Elements 13
        • Photoshop Elements 12
        • Photoshop Elements 11
        • Photoshop Elements 10
        • Photoshop Elements 9
        • Photoshop Elements 8
    • Microsoft
      • Access
        • Access 2021 Beginners
        • Access 2019
        • Access 2019 Advanced
        • Access 2016
        • Access 2016 Advanced
        • Access 2013
        • Access 2013 Advanced
        • Access 2010
        • Access 2010 Advanced
        • Access 2007
      • Excel
        • Data Analytics in Excel
        • Excel 2021 Advanced
        • Excel 2021 Intermediate
        • Excel 2021 Beginners
        • PivotTables for Beginners
        • Excel Dashboards
        • Advanced Formulas in Excel
        • Excel for Business Analysts
        • Advanced PivotTables
        • Power Pivot, Power Query and DAX in Excel
        • Excel 2019 Beginners (Mac)
        • Excel 2019 Beginners
        • Excel 2019 Advanced
        • Excel 2016 Beginners
        • Excel 2016 Intermediate
        • Excel 2016 Advanced
        • Excel 2013
        • Excel 2013 Advanced
        • Excel 2010 Beginners
        • Excel 2010 Advanced
        • Excel 2007
      • OneNote
        • OneNote Desktop and Windows 10
        • OneNote 2016
      • Outlook
        • Outlook 2021
        • Outlook 2019
        • Outlook 2016
        • Outlook 2013
        • Outlook 2010
        • Outlook 2007
      • Power Automate
        • Introduction to Power Automate
      • Power BI
        • Power BI
        • Power BI Intermediate
      • PowerPoint
        • PowerPoint 2021
        • PowerPoint 2019
        • PowerPoint 2016
        • PowerPoint 2013
        • PowerPoint 2010
        • PowerPoint 2007
      • Project
        • Project 2021 Beginners
        • Project for the Web
        • Project 2019
        • Project 2019 Advanced
        • Project 2016
        • Project 2016 Advanced
        • Project 2013
        • Project 2013 Advanced
        • Project 2010
        • Project 2010 Advanced
      • Publisher
        • Publisher 2013
      • SharePoint
        • SharePoint Online
        • SharePoint Foundation 2013
        • SharePoint Server 2013
        • SharePoint Foundation 2010
      • Teams
        • Microsoft Teams
      • VBA
        • Macros and VBA for Beginners
        • VBA for Excel
        • VBA Intermediate Training
      • Visio
        • Microsoft Visio 2019
        • Visio 2016
        • Visio 2013
        • Microsoft Visio 2010
      • Windows
        • Windows 11
        • Windows 10 (2020 Update)
        • Windows 10
        • Windows 8
        • Windows 7
        • Windows Vista
      • Word
        • Word 2021
        • Word 2019 Advanced
        • Word 2019
        • Word 2016
        • Word 2013
        • Word 2010
        • Word 2007
    • QuickBooks
      • QuickBooks
        • QuickBooks Desktop Pro 2022
        • QuickBooks Pro 2021
        • QuickBooks Online Advanced
        • QuickBooks Online
        • QuickBooks Canada
        • QuickBooks Pro 2020
        • QuickBooks 2019
        • QuickBooks 2018
        • QuickBooks Pro 2017
        • QuickBooks Pro 2016
        • QuickBooks Pro 2015
        • QuickBooks Pro 2014
        • QuickBooks Pro 2013
        • QuickBooks Pro 2012
        • QuickBooks Pro 2011
        • QuickBooks Pro 2010
        • QuickBooks Pro 2009
    • Web Development
      • AngularJs
        • AngularJS Crash Course
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Bootstrap
        • Bootstrap Framework
      • Html/CSS
        • HTML/CSS Crash Course
        • HTML5 Essentials
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
      • Java
        • Java for Beginners
      • JavaScript
        • JavaScript for Beginners
        • jQuery Crash Course
      • MySql
        • MySQL for Beginners
      • PHP
        • PHP for Beginners
        • Advanced PHP Programming
      • XML
        • XML Crash Course
    • Data Analysis
      • Financial Modeling
        • Financial Risk Management
        • Financial Forecasting and Modeling
      • Alteryx
        • Alteryx Advanced
        • Introduction to Alteryx
      • Power BI
        • Power BI Intermediate
        • Power BI
      • Qlik Sense
        • Qlik Sense Advanced
        • Qlik Sense
      • R Programming
        • R Programming
      • Tableau
        • Tableau Desktop Advanced
        • Tableau Desktop
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
    • Work Productivity
      • Google Sheets
        • Google Sheets for Beginners
      • Confluence
        • Introduction to Confluence
      • Monday
        • Getting Started in Monday.com
      • Asana
        • Asana for Employees and Managers
        • Introduction to Asana
      • Jira
        • Getting Started in Jira
  • For Business
  • About Us
    • Testimonials
    • Contact Us
    • FAQ
    • Membership
    • About Us
  • Pricing
  • Free Resources
  • Sign In
  • Get Started
Home > Microsoft Excel > Start Co-Authoring Excel Workbooks in 6 Easy Steps

Start Co-Authoring Excel Workbooks in 6 Easy Steps

(Note: The Co-Authoring Excel feature is only available in Excel 365, Excel for the web, and Mobile versions. )

If you are wondering how to collaborate with your team using Excel, you have come to the right place. In this guide, I’ll teach you how to easily use the Excel co-authoring feature in five simple steps. With the help of this guide, sharing your Excel spreadsheets will no longer be a nightmare. 

Let us get started.

You’ll learn:

  • How Co-Authoring Excel Sheets Work?
  • How to Use Co-Authoring in Excel?
    • Step 1: Click on the Share Option
    • Step 2: Invite Your Team
    • Step 3: Allow Edit Access 
    • Step 4: Collaborate on the Go
    • Step 5: Use Comments
    • Step 6: Track Changes While Collaborating

How Co-Authoring Excel Sheets Work?

Excel co-authoring, allows you to collaborate in real-time, with multiple users while working on a workbook/spreadsheet. I am sure that most of us are familiar with this concept from using Google Sheets/ Google Docs. This feature helps eliminate unnecessary confusion and improves productivity in one go. 

But, unlike Google Sheets, Excel co-authoring is available only for Excel 365 and its online versions. In the next section, I’ll give you step-by-step instructions to make Excel co-authoring a success. 

Related:

4 Best Methods to Lock Cells in Excel

How to Add a Watermark in Excel? 2 Easy Methods

How to Make Excel Track Changes in a Workbook? 4 Easy Tips

How to Use Co-Authoring in Excel?

Co-Authoring Excel sheets is pretty straightforward. You can start collaborating in Excel by following these simple steps:

Step 1: Click on the Share Option

First of all, you need to share the Excel sheet to collaborate with your team. You can find the Share option in the top right corner of the worksheet. 

Use the Share option to start Co-Authoring Excel sheets
Use the Share option to start Co-Authoring Excel sheets

(Note: If your workbook is saved locally, Excel will prompt you to save a copy in OneDrive. Please allow it. )

Upload your workbook to OneDrive if not already done.
Upload your workbook to OneDrive if prompted

Step 2: Invite Your Team 

Clicking on it will take you to the sharing window. Here, you can invite collaborators directly using their emails or names. Just type the recipient’s e-mail and press Enter. You can add as many collaborators as you want.

Invite your teammates using E-mail Ids or Names
Invite your teammates using E-mail Ids or Names

Please note that Excel may automatically suggest names or emails from your contacts, history or organizations. 

If you don’t wish to share the workbook through email, you can send a shareable link instead. Get this link by clicking the ‘Copy Link’ option right below the email bar.

Copy the unique link and message it to your teammates. 

Message the unique link to your team
Message the unique link to your team

Also Read:

How to Protect Cells in Excel Workbooks —5 Easy Ways

How to Indent in Excel? 3 Easy Methods

How to Add Subscript in Excel? (6 Best Methods)

Step 3: Allow Edit Access 

You can modify the collaborators’ access level by clicking on the Edit option (pen-shaped icon) right next to the email bar. Set it to ‘Can Edit’ to allow co-authoring in Excel. 

Choose the Can edit option by clicking on the 'Pen Icon'
Choose the Can edit option by clicking on the ‘Pen Icon’

Right below, inside Link Settings, you can set a password and expiration date for people who access it using the shareable link. 

Click on Link settings to set a password and expiration date for the shareable link.
Click on Link settings to set a password and expiration date for the shareable link.
Set a password and expiration data if required
Set a password and expiration date if required

Step 4: Collaborate on the Go

When your team members accept the invite and open the workbook, they can start editing right away along with you. You can see their names or their initials on the top-right corner of the worksheet if they are actively using the workbook. 

The co-Authors' initials will appear in the top-right corner along with their highlighted active cell.
The co-authors’ initials will appear in the top-right corner along with their highlighted active cell.

Moreover, in a shared workbook, you can see what other people are currently working on. Their current cell position will be highlighted with a unique color. 

Step 5: Use Comments

Comments are crucial if you want to successfully collaborate in Excel. This feature allows you to communicate inside the workbook and resolve issues as soon as possible.

To insert a comment select the relevant cell and click on the New Comment button in the Review tab. 

Use the New Comment option in the Review tab to add comments
Use the New Comment option in the Review tab to add comments

Then, type your comment in the Comment Box and click on the Arrow button to post it. 

Repeat the process if you want to add more comments. You will see that all your commented cells will be highlighted with a small coloured marker.

Commented cells will be highlighted with a colored marker
Commented cells will be highlighted with a colored marker

Now, other users can see the comment and reply back. Please remember to add the “@” symbol before a user’s name to direct a comment at that specific user. This will notify them and help you keep track of the comment threads. 

Reply to comments if needed
Reply to comments if necessary

A thread will be created if you make a comment and others reply to the comment. Such threads can be either resolved or deleted. 

Use comment threads to keep track of changes
Use comment threads to keep track of changes

To view all the comments at once, click on the Show Comments button in the Review tab. This will display all the comments including the cell reference where the comment was made. You can also click on the Comments icon in the top right corner of the Excel window to view them. 

Use the Show Comment option to view all the comments made in the Workbook
Use the Show Comment option to view all the comments made in the Workbook

Step 6: Track Changes While Collaborating

To view the changes made by everyone, open the same worksheet in Excel web version and click on the  Show Changes option in the Review tab. 

This will open a window listing the changes made by everyone on the shared worksheet. 

You can use the nearby filter option to select the changes made in specific cells/ ranges. 

Suggested Reads:

How to Autofit Excel Cells? 3 Best Methods

How to Extract an Excel Substring? – 6 Best Methods

How to Shade Every Other Row in Excel? (5 Best Methods)

Closing Thoughts

In this short guide, we learned how to share, collaborate, and co-author an Excel worksheet. Before we wrap up, let me share a few tips to make Excel co-authoring a piece of cake.

First, make sure that you share the worksheet with a select few people, to begin with. It can become overwhelming and chaotic if there are too many collaborators. Also, be mindful of the comments you make and comment only when necessary. 

We hope you found this article useful. Please let us know if you face any difficulties while collaborating in Excel. We are always happy to help. 

Please visit our free resources section for more high-quality Excel guides. 

Ready to dive deep into Excel? Simon Sez IT has been teaching Excel for over ten years. For a low, monthly fee you can get access to 100+ IT training courses. Click here for advanced Excel courses with in-depth training modules.

Simon Calder

Chris “Simon” Calder was working as a Project Manager in IT for one of Los Angeles’ most prestigious cultural institutions, LACMA. He taught himself to use Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy then, but he spotted an opportunity and made an online MS Project course - the rest, as they say, is history!

Most Popular Posts

  • Kanban vs Scrum: Project Management Methodologies and Their Differences [2022]
  • How to Insert a Checkbox in Excel? 3 EASY Examples
  • How to Autofit Excel Cells? 3 Best Methods
  • XLOOKUP Google Sheets – 4 Best Alternatives!
  • Dashboards in Excel Using Pivot Tables, Pivot Charts and Slicers
  • Free Microsoft Project Training Course
  • Free Microsoft Access Tutorial for Beginners (3.5 Hours Video)
  • How to Use Blending Mode With Layers in Adobe Photoshop Elements 15

Similar Posts

Microsoft Project 2019: Constraints and Deadlines

How to Memorize Reports in QuickBooks 2019

How to Change the Margins in Excel? 2 Useful Ways

An Introduction to Jira Work Management – 23 Templates

How to Create a Query in Microsoft Access 2013

XLOOKUP for Dummies – 4 Easy Examples

Course Categories

  • Adobe
  • Data Analysis
  • QuickBooks
  • Microsoft
  • Web Development
  • Work Productivity

About Us

  • About Us
  • Free Resources
  • Affiliates
  • Become an Instructor

Products

  • Pricing and Plans
  • Business Pricing
  • Government Discounts
  • Non-Profit Discounts

Support

  • FAQ’s
  • Contact Us
  • DVD support

Connect

YoutubeFacebookLinkedIn
© 2023 Simon Sez IT, Inc.
  • Terms
  • Privacy Policy
  • Sitemap
888.817.6665 Monday thru Friday 7:30 a.m. - 5:00 p.m. (ET)