Published on August 23, 2026 · 8 min read
Excel redaction usually means hiding columns, deleting rows, and hitting send. The file still holds more than you think.
Hidden rows and columns are hidden, not deleted. The data stays in the file. Select the sheet, right-click, unhide, and everything comes back.
That's not protection. It just makes data slightly harder to find. Quick way to spot it. Look at your row numbers or column letters. If you see a double line between headers, or the numbering skips (row 8 jumps to row 12), something is tucked away. You can also write a short macro to list every hidden row and column. Faster than scrolling around looking for gaps.
PivotTables have their own problem. They cache source data by default. You send a summary table. The recipient double-clicks the bottom-right corner of the PivotTable, and Excel opens a full detail sheet with every record you tried to keep out of sight. No special trick needed. This is default behavior.
A headcount summary looks harmless. Then the recipient double-clicks the total cell and gets a detail sheet behind the PivotTable with every record from the source data. Names, hire dates, salaries. The sender usually has no idea this is possible.
Ghost items are related. Delete a category from your source data, and it can still sit in PivotTable filter dropdowns. Excel keeps a memory of deleted items by default so custom formatting doesn't break. To flush them out, right-click the PivotTable, open PivotTable Options, go to Data, and set "Retain items deleted from the data source" to None. Then refresh.
Data validation lists do something similar. You remove a category from the data, but the dropdown still shows it. The recipient sees what you removed.
And what you removed can itself say something. Delete a product line, but the dropdown still lists that product line name, and the recipient knows that option existed at some point. Check the Data Validation dialog and look at the Source field. If it points to a range that includes deleted values, those values might still be there. Better idea. Convert your source range to an Excel Table so the validation list updates automatically when you add or remove items.
"Remove Duplicates" does delete rows. Filters don't. They just hide them. That distinction matters when you're cleaning a file before sending it. Hiding rows with a filter is no different from hiding them manually. Anyone can clear the filter and see everything again.
Metadata is the part nobody thinks about. Author name, company, file path, old comments. None of it shows on screen, but it travels with the file. The UK's Information Commissioner's Office (ICO) has a guide on anonymisation that specifically warns about hidden rows, columns, and worksheets. They call these "ineffective techniques" because the data is still there for anyone who knows where to look.
The ICO also makes a point worth remembering. Identifiability is broad. A name is not the only thing that identifies someone. "We deleted the names column" doesn't automatically mean the data is anonymous. Job title, hire date, salary. Combinations like that can point to a specific person even without a name attached.
Excel has a built-in tool for some of this. File, Info, Check for Issues, Inspect Document. It scans for comments, document properties, hidden rows and columns, and other things you might have forgotten about. Save a copy first. The inspector's removals are permanent, and there's no undo.
Document Inspector doesn't catch everything, though. It has a PivotTable module, but its cleanup of cached data is limited. And it can't detect information hidden by moving it to remote rows or columns. The ICO points this out as a known blind spot. The manual checklist:
Doing all of that by hand gets tedious with more than a couple of files. That's where a tool earns its keep.
DocRedactNow's Excel handler scans hidden cells, PivotTable caches, data validation lists, metadata, and more. When you send the file, the recipient only sees what you want them to see.
Try DocRedactNow free for 14 days.
⬇️ Download Free Trial