How to Not Copy Hidden Rows in Excel Without Errors

To avoid copying hidden rows in Excel, select the range you need, choose Home > Find & Select > Go To Special > Visible cells only, then copy and paste. On Windows, you can use Alt+; after selecting the range instead. This tells Excel to copy only the cells currently visible, including when rows are hidden manually or by a filter.

The key is to apply Visible cells only before copying. If you copy a range normally, Excel may include rows that are hidden from view. The steps below are for Microsoft Excel for Microsoft 365 on Windows; Mac and web notes are included where the workflow can differ.

What You’ll Need

An Excel workbook containing the range you want to copy.
A clear idea of which columns and rows you want in the copied result. Selecting only those columns helps avoid copying extra visible cells.
Access to Excel for Windows for the most direct shortcut. You can use the Go To Special menu on desktop Excel if you do not want to use a keyboard shortcut.

Step-by-Step

Identify the source range. Decide whether you need the whole table or only specific columns, such as employee names and hours. If you only need some columns, select those columns within the data range rather than selecting the entire worksheet. Visible cells only also excludes hidden columns, so a narrow, intentional selection makes the result easier to check. Include the header row if you want the headings copied too.
Select the rows and columns that contain the data. Drag across the cells, or click the first cell and Shift-click the last cell in the range. For a table with headings in row 1 and data through row 50, for example, select the relevant range from the heading row through row 50. You can also select a whole block by clicking its first cell and pressing Ctrl+Shift+End, but check the resulting selection: it can extend beyond the table if the worksheet has previously been used farther down or to the right.
Tell Excel to select visible cells only. On Windows, press Alt+; (Alt plus the semicolon key) while the range is selected. Excel changes the selection so hidden rows and columns are excluded. To use the ribbon instead, choose Home > Find & Select > Go To Special, choose Visible cells only, and select OK. The selection may look discontinuous when a hidden row separates visible rows; that is expected.
Copy the selected visible cells. Press Ctrl+C, or choose Home > Copy. Do not click elsewhere and make a new selection before copying, because that would replace the visible-cells selection. A moving dashed outline around the copied area is normal.
Choose the destination and paste. Click the top-left cell where you want the copied results to begin, then press Ctrl+V or choose Home > Paste. In an ordinary blank destination, the visible source rows are pasted without the hidden rows between them. If you are pasting into another filtered or partly hidden range, first check that the destination arrangement is suitable; Excel may not place a multi-area selection into a nonmatching destination the way you expect.
Verify the result before relying on it. Compare the first and last copied records with the source, and check a few records on either side of hidden rows. If you copied a filtered list, compare the pasted row count with the number of records currently displayed. You can also temporarily unhide the source rows after copying to confirm that records that were hidden did not appear in the pasted block.
Use the same method when you need entire visible rows. Select the relevant row headers, including the hidden rows within the span, then apply Visible cells only and copy. For a safer, more predictable output, select just the data columns across those rows instead of selecting all worksheet columns. Selecting whole rows can bring along formatting or other content well beyond the table.

On Mac, select the range and use Excel’s Go To Special command to choose Visible cells only; menu placement and available shortcuts can vary between Excel for Mac versions. If the shortcut is not listed for your build, use the menu rather than assuming the Windows Alt+; shortcut works. In Excel for the web, copying a filtered list generally copies its displayed rows, but the desktop app is the more reliable choice when rows were manually hidden and you need to explicitly choose Visible cells only.

Common Mistakes

Copying before selecting visible cells. Hiding rows changes what you see, but it does not necessarily change what a normal range selection contains. Apply Visible cells only first, then copy.
Selecting too much. Choosing entire columns or the whole sheet can include unrelated visible cells, formatting, or blank areas. Select the table or the specific columns you need.
Assuming filtered rows and manually hidden rows are different for this task. The visible-cells selection is useful for both. A filter hides records from the current display; manually hiding a row does the same for what is visible. In either case, normal copying can produce an unexpected result if you do not explicitly limit the selection.
Forgetting hidden columns. Visible cells only excludes hidden columns as well as hidden rows. If a column is hidden but you still need its values, unhide it before selecting and copying.
Pasting into a mismatched destination. A copied selection with gaps can behave differently from a single solid block, especially when the destination is filtered or contains merged cells. Paste into a clear area first and inspect the result before replacing existing data.
Expecting the command to delete hidden source rows. It only controls what is selected and copied. Hidden records remain in the original worksheet unless you separately unhide or delete them.

Tips

Use a filter when you need a repeatable subset. Apply a filter to show only the records you want, select the table range, then use Visible cells only and copy. Filtering makes it easier to see why each record is included.
Include headings deliberately. Select the header row if the pasted data should explain what each column means. Leave it out if you are adding records beneath an existing table with headings already in place.
Paste values when you do not want source formulas. After copying, use Home > Paste > Values or the Paste Options button and choose Values. This transfers displayed results rather than formulas, but still verify that the visible-only selection was made before copying.
Keep a copy of important source data. Copying does not alter hidden rows, but a paste over existing cells can. Paste into an empty worksheet or a spare area first if the destination matters.
Remember the shortcut only acts on the current selection. Select the intended range first, then press Alt+;. If you change the range afterward, apply Visible cells only again before copying.

Troubleshooting

Hidden rows still appear in the pasted result. Return to the source, select the original range, and apply Visible cells only again immediately before copying. Confirm that the selection skips the hidden rows, then copy and paste into a blank area. If you selected and copied the range before using the command, start over from the selection step.

Alt+; does not seem to do anything. Check that Excel is active and a cell range is selected. On some keyboards, the semicolon key may require a different key combination depending on the layout. Use Home > Find & Select > Go To Special > Visible cells only instead. On Mac, use the Go To Special menu; Windows shortcuts should not be assumed to match Mac shortcuts.

The pasted range has gaps or does not line up. Visible source cells can form multiple separate areas. Try pasting into a blank worksheet starting at one cell, rather than into a filtered destination, merged cells, or a table with a different shape. Check whether hidden columns are causing the selection to have fewer columns than expected. If the output still is not arranged as needed, copy each required visible section separately.

Some expected records are missing. Check whether a filter is excluding them, whether their rows or columns are hidden, and whether the source selection covered the entire table. Clear or adjust the filter if you want those records included. Visible cells only intentionally leaves out anything not visible; it cannot distinguish an accidental hide from one you meant to keep.

The menu command is unavailable in Excel for the web. Open the workbook in the desktop Excel app and use Go To Special to explicitly select Visible cells only. If you must work in the browser, test the filtered-copy result in an unused area and compare it with the records displayed before replacing any data.

Frequently Asked Questions

Does Visible cells only work with filtered rows?
Yes. It selects cells currently visible in the selected range, so rows excluded by a filter are left out of the copy. The same command also excludes rows hidden manually.

Will this copy hidden columns too?
No. Visible cells only excludes hidden columns as well as hidden rows. Unhide a column first if its contents need to be included, or make sure the selected range contains only the columns you intend to copy.

Can I copy visible rows to another worksheet?
Yes. Select the source range, choose Visible cells only, copy, and paste into a cell on the destination worksheet. Start in a blank area and check the result, especially if the copied cells came from a filtered range.

Can I copy only the visible rows without their formatting?
Yes. First select visible cells only and copy. At the destination, use Home > Paste > Values to paste values without the source formatting and formulas. Check the result because values-only paste does not change which source cells were selected.

Does hiding a row remove its data from the workbook?
No. Hiding changes what is shown, not what is stored. The data remains in the source worksheet; Visible cells only merely omits hidden cells from the copied selection.

Why does Excel say the selection contains multiple ranges?
Visible rows separated by hidden rows form separate areas in the selection. That message can appear when you try an operation that expects one continuous block. For copying, paste into an empty area first; if the destination still cannot accept the selection, copy the visible sections one at a time.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.