ChapterÂ 22.Â Worksheet Collaboration
Armed with Excel, thereâs a lot you can do on your own to analyze data. But Excel pros arenât content to struggle in solitude. Instead, they invite their friends, colleagues, and coworkers to join in.
There are plenty of reasons to collaborate on an Excel document. For example, you may want to hand a worksheet off to a friend who can fix a wonky formula or fill in missing data. Or you might want to run your numbers through a review process so your colleagues can comment and flag potential issues. Or perhaps youâre even more ambitious, and youâre looking for a way that will let your whole team add data to the same spreadsheet at the same time. Excelâs collaboration features meet all these requirements handily.
In ChapterÂ 21, you saw the first of Excelâs collaboration features, worksheet protection. Using it, you can lock down sheets so people can make changes only in specific cells. Along with worksheet protection, Excel has several other collaboration tools youâll learn about in this chapter:
Comments. Excelâs comments feature lets you insert questions, suggestions, or other miscellaneous notes that point to specific cells (like âThis numberâs wrongâ or âPlease boost the sales estimate so we can impress the bossâ). The person who created the spreadsheet can then respond to these comments by modifying the spreadsheet.
Change tracking. Change tracking lets you keep track of the edits made by multiple people. You can then ...