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

Redactions that do

  1. Work on a copy, so the original stays intact for your own use.
  2. Replace the values. Overwrite each sensitive cell with [REDACTED], or delete it. If the recipient still needs part of the value, mask it instead: ************2486 shows which phone number it is to someone who knows it, and nothing to anyone else.
  3. 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.
  4. 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

More guides