ScrubDrop › Guides

Filtered rows, collapsed groups, hidden cells and notes: personal data inside an Excel sheet

Last updated: 19 October 2026

This page is about the cells of a sheet that stays. Whole hidden sheets, defined names, pivot caches and links to other workbooks are in hidden sheets, names and personal information and hidden data in Excel.

Four ways a value stays out of sight

• A filter. Microsoft's page Filter data in a range or table says filtered data "displays only the rows that meet criteria that you specify and hides rows that you do not want displayed". A list filtered to one team still holds every other team's rows.
• A collapsed group. An outline hides its detail rows or columns when the group is collapsed (Outline (group) data in a worksheet). A summary that shows totals per department can hold the per-person rows underneath.
• A hidden row or column. A column of email addresses or salaries, hidden so the sheet prints neatly, is still there.
• The ;;; number format. Microsoft's page Hide or display cell values gives this custom format as the way to hide values, and says the values "remain displayed in the formula bar". The cell looks empty; the value is not.

In the saved file, the rows and columns are still in the sheet's XML with their cells. The format that defines the .xlsx (ECMA-376) marks a hidden row or column with a hidden attribute, and records the filter of a sheet in an autoFilter element. Microsoft's Document Inspector page puts it this way: "Workbooks can have active Autofilters or table filters that might cause cached or hidden data to be saved with the workbook."

Notes and comments on cells

Excel has two kinds of annotation on a cell. Microsoft's page The difference between threaded comments and notes says comments "allow you to have discussions with other people about the data", while notes "are just for adding annotations or reminders in cells". Both are saved with the workbook, and both carry names: of a comment, the same page says "You cannot remove or change your name." A note such as "check with HR, on leave until March" is personal data about someone, whoever wrote it.

Finding them

1. Filters. Clear every filter on every sheet. Microsoft's filter page says clearing them will "remove the filters from all the columns in your table or range and show all your data".
2. Groups. Outline symbols appear beside the row numbers or above the column letters. Microsoft's outline page says: "To show all detail data, select the lowest level" in the outline symbols. Data › Outline › Ungroup › Clear Outline removes the outline itself.
3. Hidden rows and columns. Row numbers or column letters that skip are the sign. Select the whole sheet and unhide rows and columns.
4. ;;; cells. Select a cell that looks empty and read the formula bar. If the cell's number format is the custom format ;;;, that is the cause; set it back to General to see the value.
5. Notes and comments. Go through every note and comment on each sheet. Document Inspector's Comments and Annotations inspector also finds comments.

Document Inspector on Windows has a Hidden Rows and Columns inspector, which finds "Hidden rows" and "Hidden columns that contain data". The same page warns that removing hidden rows or columns that hold data can change the results of formulas, and that hidden rows or columns "are not removed if they are part of a table header, list header, or a Pivottable". It does not mention values hidden with a number format.

Taking the personal data out

1. Work on a copy of the workbook.
2. Clear filters, expand groups and unhide rows and columns, so that every row is on screen.
3. Decide what the recipient needs. Delete the rows and columns that should not go; hiding them again is not removing them. Check the formulas that read them first, because their results will change.
4. Set ;;; cells back to General and delete the values that should not go.
5. Delete the notes and comments, or the ones that name people.
6. Save, and check the saved copy with the steps at the end of this page.

If the recipient needs only some of the values, a new workbook with just those values pasted in carries none of the rest.

What ScrubDrop does with them

ScrubDrop reads the .xlsx in your browser; the file is not uploaded. For free, it lists the cells it finds in hidden rows and hidden columns, by sheet and cell, along with notes and comments and the other kinds of hidden data, with counts and short samples. It also points out white or tiny text and cells outside the print area, but does not remove them, in either version. It does not look for values hidden with a number format such as ;;;, so check those yourself.

The free version removes notes, comments (with the list of their authors) and properties from one file at a time. Removing the values of cells in hidden rows and columns is part of ScrubDrop Pro; the rows and columns themselves stay, hidden and empty. When it clears them, it also replaces every formula on the sheets that stay with its last saved result, because a formula anywhere in the workbook can read a hidden cell; those cells no longer recalculate, so keep your working copy. ScrubDrop refuses a sheet, rather than guessing, when it cannot take hidden cells out cleanly:

• a sheet that has a table and hidden rows or columns, because the table keeps their headers;
• a sheet with hidden rows or columns and a filter whose criteria are values, custom comparisons or date groups, because the criteria can hold those values;
• a sheet that hides its rows by default.

Each refusal says what to do in Excel first: clear the filter, unhide or delete the rows. After removing, ScrubDrop reads the result again with separate parsers and offers it only if nothing of the chosen categories remains. Open the cleaned workbook and look at every sheet before you send it.

How to check this yourself

1. Make a copy of the .xlsx, rename it to .zip and unzip it.
2. In each file under xl/worksheets, search for hidden="1" or hidden="true" on <row and <col elements, and for <autoFilter. Rows inside a group also carry an outlineLevel attribute.
3. In xl/styles.xml, look for a numFmt whose formatCode is ;;;.
4. Notes are in xl/comments1.xml and the like, with their authors in <authors>. Threaded comments are in xl/threadedComments, and the names of the people who wrote them in xl/persons/person.xml.

A search for these is a quick check, not a proof: the values themselves may sit in xl/sharedStrings.xml, so search that file too for a name you expect to be gone.

Questions

Sources: the Microsoft pages linked on this page were checked on 19 October 2026.