◆ Excel · track

Checklist Verification

Set up a submission-checklist sheet that flags missing required fields — document name, version, author, signature, an…

2heights
3tasks
2roles do it
See the prompt↓More track workflows

The same job, four prompts

do it · improve it · decide · become
AExecute — “help me do it”Set up a submission-checklist sheet that flags missing required fields — document name,…+
Set up a submission-checklist sheet that flags missing required fields — document name, version, author, signature, and date — using data validation and conditional formatting so incomplete packages are highlighted before review.
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed.
BImprove — “do it better”Before I release files to press, make the checklist defensible—require signoff name and date…+
Before I release files to press, make the checklist defensible—require signoff name and date for each proof step, block editing of completed rows, surface any item where color check is unchecked but plates requested exist, and add a summary that shows issues ready versus blocked.
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed.

How to do it

the tool · the steps · what to avoid
The tool
Track Changes

Track Changes in Excel allows you to monitor modifications made to a workbook, including who made them, what was changed, and when.

  1. 1

    Open your Excel workbook and go to the Review tab.

  2. 2

    In the Changes group, click Track Changes.

  3. 3

    Select Highlight Changes... from the dropdown menu.

    NoteIf 'Track Changes' is grayed out, the workbook might be in a format that doesn't support it, or it needs to be converted to a range.

  4. 4

    In the Highlight Changes dialog box, check the box for Track changes while editing. This also shares your workbook.

  5. 5

    Under Highlight which changes:, select the desired options for When, Who, and Where.

  6. 6

    Check Highlight changes on screen to see changes directly in the workbook.

  7. 7

    Click OK to enable tracking and highlight changes.

    Best practiceFor smaller workbooks, 'Track Changes' is effective. For larger ones, consider saving local copies with dates for version control.

  8. 8

    To view changes, go to the Review tab and click Show Changes.

    NoteChanges appear in a pane, with the most recent changes at the top.

  9. 9

    Save your workbook to preserve the tracked changes and sharing settings.

To view changes over a longer period or access previous versions, use File > Info > Version History.

Excel's 'Track Changes' feature is primarily a user interface function and is not directly exposed through the Excel API for programmatic control.

Glossary

words on this page
Conditional FormattingApplies specific formats to cells automatically when their values meet certain criteria.ExampleCells with sales figures below target automatically turn red, making underperforming regions easy to spot.
Data ValidationA feature that restricts the type or values of data users can enter into a cell, ensuring accuracy.ExampleData validation prevents users from entering text into a cell that should only contain numbers.
Track ChangesA feature that records edits made to a workbook, showing who changed what and when.ExampleAs your team edits a budget, you see each change highlighted with the author's name.
FunctionA predefined formula that performs calculations using specific values in a particular order.ExampleUsing the SUM function quickly adds up a column of numbers.

The real tasks

2 of them
Use a simple checklist per issue to confirm proofs, color checks and plate approvals are complete before sending to press.
Quickly flag missing required fields on a submission checklist so I can stop incomplete packages going to reviewers.

Who does this

2 roles
Regulatory Affairs AnalystMusic Publisher

Questions people ask

honest answers

Because you rarely think 'I want the redaction tool'. You think 'I have to share this without leaking the client's details'. Start from the need, and the feature finds you.

Real. Every job here was drawn from what people in real roles were actually seen doing in Excel — not a feature checklist.

No. Each page gives you a ready prompt you can paste into an AI assistant, plus the plain steps to do it yourself. Start with either — the goal is the finished job, not the tool.