PlayInfoBox

Home /Utilities /How to Copy Only Visible Cells in Excel

How to Copy Only Visible Cells in Excel

Tap a step to see it in order.

  1. Apply a filter or hide the rows you don't need

    First, use a filter to show only the rows you want, or manually hide the rows you don't.

  2. Select the entire range to copy

    Drag to select the full range, including the hidden rows, not just what is currently visible.

  3. Go to "Home > Find & Select > Go To Special"

    Open the "Go To Special" dialog, choose "Visible cells only," and click OK.

  4. Copy, then paste it wherever you need

    Press Ctrl+C to copy -- the hidden cells are excluded, so pasting brings over only the rows that were visible on screen.

  5. Why it is worth doing

    Copying a filtered table the ordinary way often drags along hidden data too -- this method copies exactly what is visible on screen and nothing else.

A plain copy grabs more than you meant to share

When you filter a table down to just the rows you care about and copy it the normal way, Excel actually copies every row underneath -- including the ones the filter hid -- and pastes them all. That silently defeats the whole point of filtering before sharing a subset of your data with someone else.

A shortcut skips the dialog entirely

Once a range is selected, pressing "Alt+;" (semicolon) selects only the visible cells directly, without opening the "Go To Special" dialog at all -- worth memorizing if this is something you do often.

Frequently Asked Questions

Are hidden columns excluded the same way as hidden rows?

Yes -- both rows hidden by a filter and rows or columns hidden manually are excluded from the copy in exactly the same way.

Does this work if I sorted the data instead of filtering it?

This specific technique is for skipping hidden or filtered-out rows -- if your data is simply sorted with nothing hidden, a normal copy already includes everything visible, since sorting does not hide any rows.