Icons, Drawing Tools & Modern Collaboration
Add scalable icons and annotations to a workbook, and work in a shared file without getting in anyone's way.
By the end of this lesson you can
- Insert and recolour scalable icons
- Use the Draw tab to annotate a sheet
- Co-author a workbook and explain what co-authoring requires
- Use Sheet View to sort and filter without disturbing other people
Lesson Notes
Read through the key concepts before you try the challenge.
Icons and annotation
You are preparing the quarterly supply summary for a meeting.
The numbers are correct and the sheet is a wall of gray. Three icons and a status column would let the practice manager find the two categories that need attention in about four seconds.
Your task: Add visual signals that speed up reading, without decorating for its own sake.
Insert > Icons opens a searchable library of scalable graphics. Because they are vector images rather than pictures, they stay sharp at any size and can be recoloured from the Graphics Format tab. Insert > Illustrations also offers stock images and, on some builds, 3D models.
| Tool | Use for |
|---|---|
| Pen and highlighter | Marking up a sheet for discussion in a review meeting |
| Ink to Shape | Converting a rough drawn shape into a clean one |
| Ink to Math | Converting handwritten equations into typed ones |
| Eraser | Removing ink strokes without touching cell contents |
Working in a file with other people
Co-authoring lets several people edit one workbook at the same time, with each person's selection visible and labelled. It requires the file to be stored in OneDrive or SharePoint, and it requires AutoSave to be on — which is the same requirement, since AutoSave only works on cloud-stored files.
Sheet View solves the problem co-authoring creates. In a shared workbook, sorting or filtering normally changes the view for everyone — so one person looking for a vendor rearranges the sheet under a colleague who is mid-entry. Sheet View gives you a private sort and filter that nobody else sees. Find it on the View tab, and note that it changes only what you see, never the underlying data.
| Feature | Requires | Note |
|---|---|---|
| AutoSave | File in OneDrive or SharePoint | Saves continuously — there is no 'close without saving' |
| Co-authoring | File in OneDrive or SharePoint | Each editor's selection is shown and named |
| Sheet View | Microsoft 365 | Private sorting and filtering in a shared file |
| Version History | File in OneDrive or SharePoint | File > Info > Version History; the only real recovery from a bad edit |
| Comments | Any workbook | Threaded and repliable; Notes are the older single-author kind |
You are working in a shared workbook and need to sort by vendor to find something, but a colleague is entering data at the same time. What should you use?
Challenge
Apply what you've learned in this lesson.
Finish the module by making one sheet genuinely easier to read, then sharing it properly.
- Add a status column to your supply tracker using a formula, then place an icon beside the header. Give the icon alt text and explain in one sentence why the column matters more than the icon.
- Save the workbook to OneDrive and confirm AutoSave turns on. Note what the AutoSave toggle looked like before and after.
- Share it with a classmate as an editor. While they have it open, use Sheet View to sort by category and confirm their view does not change.
- Make a deliberate bad edit — delete a column — then recover it through File > Info > Version History. Write down the steps, because this is the one you will need under pressure someday.
Finished this lesson?
Progress is saved in this browser only. It is not a grade — official progress lives in Brightspace.