There may be times when you're working on a workbook and find that you need the help of others. Excel offers two powerful features that allow you to work with others on the same spreadsheet: comments and co-authoring.
Optional: Download our practice workbook.
Watch the video below to learn more about comments and co-authoring.
The Track Changes feature can also be helpful to review changes before making them permanent. It's still available in Office 365, but it's now hidden by default. You can learn more about Track Changes in our Excel 2016 lesson here.
In order for others to collaborate on a workbook, you'll need to share it with them first.
One way to collaborate on a workbook is through commenting. Sometimes you may want to provide feedback or ask a question without editing the contents of a cell. You can do this by adding a comment.
You can also choose to show and hide individual comments by selecting the desired cell and clicking the Show/Hide Comment command.
Another collaboration tool is co-authoring, which allows others to view and edit your workbook in real time. This makes it easier and quicker to collaborate on a workbook with your team. After sharing a workbook with others, they'll be able to co-author it.
Real-time co-authoring requires an Office 365 subscription.
When you co-author a workbook, you can see others at work because each will have their own unique color. If you want to see who's currently editing a workbook, you can hover over the activity to see their name.
When you or anyone else makes changes to a workbook, the changes are saved automatically. However, if you're unhappy with the changes, you can always restore a previous version.