How to redact data in Excel
So the original values are really gone
PDF editors have a redaction tool; Excel doesn't. The usual workarounds look redacted on screen but leave the original value in the file, where anyone who receives it can find it.
Redactions that don't work
- Black fill, or white text on white. The value is still in the cell. Click it and it appears in the formula bar.
- Hiding columns, rows or sheets. Anyone can unhide them.
-
A custom number format like
;;;hides what the cell shows, not what it contains. - Protecting the sheet. Sheet protection stops editing, not reading.
- Converting to PDF. White text, or text under a black fill, goes into the PDF as text, where it can still be selected and copied.
Redactions that do
- Work on a copy, so the original stays intact for your own use.
-
Replace the values. Overwrite each sensitive cell with
[REDACTED], or delete it. If the recipient still needs part of the value, mask it instead:************2486shows which phone number it is to someone who knows it, and nothing to anyone else. - Check where else the data lives. Formulas that refer to the redacted cells, PivotTable caches, comments and notes, hidden sheets and, for files shared as a OneDrive or SharePoint link, version history. See removing personal data from Excel.
- Run Document Inspector (File › Info › Check for Issues › Inspect Document) to remove comments, hidden content and document properties.
Redact whole columns in one go
In Scrubsheet, choose Redact for each column you want gone, or Clear to leave it empty. Free-text columns can be redacted inside the text only, so a comment keeps its meaning but loses the email address in it. The browser tool downloads a new file with only the cell values; the Excel add-in writes the result to a new sheet and leaves the original untouched. Redact, Mask and Clear are included in the add-in's free plan.
Try it on your own file. The Scrubsheet browser tool anonymizes Excel and CSV files in your browser, free and without uploading anything. In Excel, use the Scrubsheet add-in.
Anonymize a spreadsheet