How to copy without hidden lines

Vickie Leon 0 Reputation points
2026-05-21T00:57:54.2133333+00:00

I am trying to copy visible cells only to another worksheet. I have done the go to special and selected visible cells only, but it still copies the hidden cells. I am trying to filter columns. When I filter by one column, it unfilters another column. Therefore, I am trying to copy just what is visible on my screen by the first filter, but is copies all the hidden lines.

Microsoft 365 and Office | Excel | For home | Windows

3 answers

Sort by: Most helpful
Most helpful Newest Oldest

  1. AI answer

    2026-05-21T00:58:08.3366667+00:00

    In Excel for Windows, copying only what is visible requires two things:

    1. the data must actually be hidden by filtering or by hiding rows/columns, and
    2. the “Visible cells only” selection must be active at the moment of copying.

    Use this sequence:

    1. Apply the filters you want so that only the rows you need are visible.
    2. Select the range to copy (only the visible rows you want).
    3. On the Home tab, in the Editing group, select Find & Select > Go To Special.
    4. Under Select, choose Visible cells only, then OK.
    5. With that selection still active, select Copy (or press Ctrl+C).
    6. Go to the other worksheet, select the upper‑left cell of the destination, and select Paste (or press Ctrl+V).

    Important notes based on the behavior described:

    • If a second filter is changing the first filter’s results, set all filters exactly as needed before doing Go To Special > Visible cells only. The visible‑cells selection is based on the current filter state.
    • If the data is part of an outlined worksheet (grouped rows/columns), hide the detail rows using the outline symbols first, then select only the summary rows and use Visible cells only before copying. This ensures only the currently visible summary rows are copied.
    • When copying to another application or another instance of Excel, only visible cells are copied by default; if hidden rows are still appearing, re‑check that they are truly hidden/filtered in the source, not just scrolled off‑screen.

    If using Excel for the web instead of the desktop app:

    • Copying a filtered range normally includes hidden rows. To copy only visible rows there, the data must be formatted as a table with filtering applied; then copying the table’s visible rows will copy only those rows.

    References:

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

    1 person found this answer helpful.
  2. Simão, Tiago 0 Reputation points
    2026-10-02T09:31:21.9833333+00:00

    Good day @Vickie Leon

    I had this same issue as you before, but now it seems that Microsoft has fixed it.
    However, I don't find any documentation confirming the fix.

    For info, here is my version of Excel, in case you want to check/compare:
    Microsoft® Excel® for Microsoft 365 MSO (Version 2608 Build 16.0.20326.20072) 32-bit

    Moreover, Microsoft has contradictory information in their pages:
    in https://support.microsoft.com/en-gb/excel/copy-visible-cells-only they say:
    "By default, Excel copies hidden or filtered cells in addition to visible cells"

    and in https://support.microsoft.com/en-gb/excel/move-or-copy-cells-rows-and-columns they say:
    "When you copy or paste hidden or filtered data to another application or another instance of Excel, only visible cells are copied"

    The lack of a "Last modified date" in Microsoft pages doesn't help to know which one is more recent.

    Hope they fixed on your version too.
    Best Regards!
    Tiago

    Was this answer helpful?

    0 comments
  3. Norah-L 11,410 Reputation points Microsoft External Staff Moderator
    2026-05-21T05:26:06.0733333+00:00

    Good day Vickie Leon!

    From what you described, you’re trying to copy only the visible rows after applying filters, but Excel still includes hidden rows, and filtering one column seems to cancel another.

    You can try the following:

    • Select the range you want to copy, then press Alt + ; to force Excel to select only the currently visible cells (ignoring any hidden rows).
    • After that, copy and paste as usual, but make sure you paste into a range that is not filtered and does not contain hidden rows, otherwise Excel may still place data into those hidden cells.

    When I filter by one column, it unfilters another column.

    If applying one filter removes another, your data may have blank rows/columns breaking the range. To fix this, try selecting your entire dataset (all rows and columns you want included) and reapply the filter, or convert the range into a Table. This ensures all columns are connected, so you can filter multiple columns at the same time without one affecting the other.

    Hope this helps. Please let me know how it goes on your side!

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.