Hidden Excel rows reappear after merging? Create an explicit visible-only handoff

Hiding Excel rows or columns changes their presentation without deleting the stored data. An importing tool may read those records again. To deliver only the intended visible scope, create a separate table of approved rows and columns, then reconcile identifiers, counts and amounts rather than forwarding the hidden original.

The example stores R01–R04 totaling 375, while the intended North delivery contains R01 and R03 totaling 150. The current spreadsheet importer does not treat hidden flags as exclusion instructions: it reads all four stored rows and the hidden Note column. A separate two-row, three-column workbook makes the required handoff explicit.

Write down stored records and intended delivery separately

All data below is an original teaching example. In hidden-rows-source.xlsx, Records has a header in row 1, manually hidden rows 3 and 5, and a hidden D column named Note. This is not an executed Excel filter or a real business access policy.

A display with two fewer rows does not change the stored amount from 375 to 150. Establish that the recipient needs only North and should not receive Note. Deduplication addresses a different question; choosing an arbitrary deduplication key is not a scope-selection method.

Compare two explicit artifacts in the same importer

The pack also contains visible-only-delivery.xlsx, a new workbook with only ID, Team and Amount and the R01/R03 records. It is not the original workbook with renamed hidden flags. Note does not exist in this delivery table.

On November 3, 2026, we imported each file into the current [spreadsheet batch tool](/tools/sheet-batch), generated a preview, downloaded XLSX and read the resulting files. The original produced four records totaling 375 with Note retained. The explicit copy produced two records totaling 150 without Note. Both language entry points were checked.

Prepare a separate visible-scope copy in Excel

Microsoft's [copy-visible-cells guidance](https://support.microsoft.com/en-us/excel/copy-visible-cells-only) distinguishes Excel for the web: an ordinary range lacks the equivalent visible-only paste option, while a filtered table offers a different route. Do not assume the desktop menus exist in every web version. Inspect the final file regardless of the route used.

When formulas, links or special structures matter, inspect their references and results after copying. Agree explicitly whether a value-only copy is appropriate for a detail handoff. That copy is not a complete backup of the original workbook.

In supported desktop Excel, select the delivery region, then choose Home → Find & Select → Go To Special → Visible cells only and copy.

Paste into a new delivery worksheet without hidden destination rows or columns. The example should contain ID, Team, Amount followed by R01 North 100 and R03 North 50. Save a separate file.

Check the exact ID set, two records, three business fields and total 150. Inspect every sheet and column in the new file for Note or other material outside the approved scope.

Import only the delivery copy and inspect its download

If the result is 375 again, check whether Source file names hidden-rows-source.xlsx. If it is 525, investigate whether the original 375 and subset 150 were appended together. Diagnose input scope before deleting rows until a total happens to look correct. Source row refers to the file imported this time: R03 is row 3 in the delivery copy, not automatically row 4 from the first workbook. Keep an ID-to-original-row mapping separately if lineage across copies is required.

For equivalent columns with different names, continue with the [header-alignment guide](/blog/merge-excel-files-column-names). These example files contain straightforward detail values; the export does not preserve the original hidden presentation, formatting or calculation behavior.

Select visible-only-delivery.xlsx in the batch tool and confirm Records is the intended worksheet. A successful new import replaces the batch; do not append both the original and its subset.

Confirm the ID, Team and Amount mappings, retain default provenance and leave unrelated deduplication keys unselected. Generate the preview and inspect R01 and R03 individually.

Download XLSX and reopen or independently read it. Expect one header plus two data rows, three business fields plus three provenance fields, Amount text values 100 and 50, and an independently calculated total of 150.

Keep scope approval separate from value freshness

The reconciliation is 375 = 150 + 225 and four records = two delivered + two excluded. Retain the excluded records in the original evidence, rather than in this delivery copy. That is a teaching rule, not an automatic decision about who is allowed to receive real data.

Hiding is neither redaction nor access control. When information must be restricted, prepare and inspect an approved artifact under the organization’s rules. Row height, column width, hidden sheets and a filter button do not establish that the stored content is absent.

Formula-derived amounts introduce another check: correct row scope does not establish a fresh cached value. See the [formula-cache and multi-sheet CSV walkthrough](/blog/excel-csv-cached-formulas-multiple-sheets). Approve scope, check usable values, and retain the original, scope decision and final delivery for later review.