Photos & storage

Copy only visible Excel cells, then check the pasted rows

Use the visible-cells selection in desktop Excel for Windows and check the limits of the web version.

You hide a few rows to make a short extract, copy the rectangle and send it on. The hidden records may still be in the copy. What a worksheet displays is not a reliable inventory of what you are about to share.

Select visible cells deliberately

In desktop Excel for Windows, select the source range, then choose Home → Find & Select → Go To Special → Visible cells only. Confirm the selection, copy it and paste into the upper-left cell of a blank destination sheet. Microsoft documents this workflow for supported desktop editions, including Microsoft 365, Excel 2024 and Excel 2021.

A simple practice example makes the result easy to judge. Enter five rows labelled 1 to 5, hide row 3 and copy using that method. The destination should contain 1, 2, 4 and 5, with no hidden third record. This is a suggested check to run yourself, not a claim that your workbook has been tested.

The browser version has a different limit

Microsoft says Excel for the web does not offer the same visible-only option for an ordinary range with hidden or filtered cells. It does support copying visible cells from data formatted as a table with a filter applied. Do not assume a manually hidden range and a filtered table behave identically. If needed, use the desktop application.

Before sharing, unhide rows and columns in the destination and inspect the first and last records, headings and excluded columns. Hidden destination rows can conceal pasted data too. Send the reviewed extract in its own file; leaving the full source on another sheet defeats the purpose of making a limited copy.

Sources & further reading

  1. Microsoft Support — Copy visible cells only

Sources support the technical explanations. Examples and suggested checks are editorial guidance.