Copy in Excel Without Hidden Rows: A Practical Guide

How-to basics · Updated November 20, 2026

To copy a range in Excel without including hidden rows, select the range, choose Home > Find & Select > Go To Special > Visible cells only, then copy and paste. This copies the visible cells rather than the hidden or filtered-out rows. The steps below are for Excel for Microsoft 365 on Windows; the menu method also works on Mac, though keyboard shortcuts can differ.

What You’ll Need

  • A workbook open in desktop Microsoft Excel, with the rows you want to exclude hidden manually, grouped, or filtered out.
  • A destination area large enough for the visible data. A blank worksheet or a clear area away from the source is a good place to check the result.
  • Permission to edit the worksheet. If it is protected, you may need the sheet password or help from its owner before copying or pasting.

You do not need to unhide rows or change the filter. The Visible cells only command works on a selection that contains hidden rows, and it can also leave out hidden columns within that selection. If you are using Excel for the web, switch to the desktop app for the menu steps below; availability and behavior for selecting visible cells can vary in the browser version.

Step-by-Step

  1. Identify the source range. Decide exactly which cells you want to copy. For example, if a report has headers in row 1 and data in columns A through D down to row 50, select A1:D50, including the header if you need it. You can click and drag across the range, or click its first cell, hold Shift, and click its last cell. You can also type a range such as A1:D50 into the Name Box to the left of the formula bar and press Enter. Include the full range that contains the hidden rows; do not try to select only the rows you can see, as that can miss part of the data.
  2. Check why some rows are absent. Look for filter arrows in the header row, outline or grouping controls along the left edge, or gaps in the row numbers that indicate manually hidden rows. This check is useful because the visible-cells command handles all of these cases, but knowing the cause helps you verify the result afterward. If the sheet is filtered, leave the filter in place while copying.
  3. Select visible cells only. With the source range selected, go to Home > Find & Select > Go To Special. In the Go To Special dialog, select Visible cells only, then select OK. Excel changes the selection to include visible cells in the range and exclude hidden cells. On Windows, you can use the keyboard shortcut Alt+; (Alt and semicolon) after selecting the range to apply the same visible-cells-only selection. The menu route is easier to confirm if you are unsure whether the shortcut worked.
  4. Copy the selection. Press Ctrl+C on Windows, or choose Home > Copy. A moving border appears around the copied area. Do not click another cell and make a fresh selection before copying: the new selection would replace the visible-cells-only selection you just made. On a Mac, use Command+C or the Copy command on the ribbon.
  5. Choose a suitable destination. Click the top-left cell of a blank area or a new worksheet. If you want to paste into a filtered list, take extra care: hidden rows in the destination can make it difficult to confirm where pasted values went. For a first check, paste into an unfiltered, empty area. Make sure the destination does not overlap the source range, especially if you are copying within the same worksheet.
  6. Paste and inspect the result. Press Ctrl+V on Windows, or choose Home > Paste. On a Mac, use Command+V. Review the pasted rows and columns before using the copied data. Confirm that the hidden records are absent, that the headers and columns line up as intended, and that no existing destination cells were overwritten. If the layout is not what you expected, undo immediately with Ctrl+Z on Windows or Command+Z on Mac, then try again in a clear destination.
  7. Clear the copy outline when finished. Press Esc to stop Excel showing the moving border around the copied cells. This does not remove the pasted data; it simply ends the active copy operation. If you need to repeat the copy, select the original range and apply Visible cells only again before copying.

For example, suppose rows 8 and 9 are hidden in a range from A1:C12. Selecting A1:C12 and then choosing Visible cells only excludes those two rows from the copied selection. The visible records and any included header are copied; the hidden records are not. The source remains unchanged, and the rows stay hidden. If there are hidden columns in the selected range as well, they are excluded from the visible-cells selection too, so check that the destination contains every column you meant to copy.

Common Mistakes

  • Copying before choosing Visible cells only. Normal Ctrl+C copies the selected range, including hidden rows in many situations. Hiding rows changes what is displayed, not necessarily what is in the selected range. Apply the Go To Special command before copying.
  • Selecting only the visible pieces by hand. Clicking separate visible areas can be slow and error-prone, particularly in a long filtered list. Select the complete source range first, then let Excel select its visible cells.
  • Assuming hidden means deleted. A hidden or filtered-out row still exists in the worksheet. Copying the entire range without the visible-only setting can therefore bring along information that is not currently displayed.
  • Forgetting the header or selecting too much. Decide whether the destination needs the column headings. A selection that starts on the first data row will not include them; a selection that includes extra columns may bring along unrelated content.
  • Pasting over data or into another filtered range. A paste can replace existing values. Pasting into a filtered destination also makes it harder to check which rows received the content. Use a blank area first, and verify the result before moving or deleting anything.
  • Expecting formulas and formatting to become plain values. A regular paste generally copies cell contents and formatting, including formulas. If you need only the displayed results, use Paste Special > Values after copying and check that the pasted values are correct.

Tips

  • Use a temporary worksheet for sensitive or important data. Pasting the visible rows onto a new sheet gives you a straightforward way to count and review them without changing the original list. Rename the sheet once you have confirmed its contents.
  • Keep the filter criteria visible while working. If rows were hidden by a filter, note which criteria are active before you copy. The command copies what is currently visible, so changing or clearing a filter first changes which records are included.
  • Confirm row numbers after pasting. If the source has visible row numbers such as 2, 3, 7, and 10, the destination should contain the visible records, not the missing hidden records. Row numbers themselves may differ in the destination, so compare the identifying values in the copied data as well.
  • Use the menu if the shortcut is unfamiliar. Alt+; is convenient on Windows, but keyboard layouts and remote desktop setups can affect shortcuts. The Home ribbon route makes the command explicit. On Mac, use the ribbon’s Find & Select and Go To Special options, or the equivalent Go To Special command available in your Excel build; avoid assuming the Windows shortcut applies.
  • Remember that this is a copy, not a change to the source. The hidden rows remain in the original sheet. If your goal is to remove them permanently, make a separate backup and use a deliberate delete procedure instead; copying visible cells alone does not delete or unhide anything.

Troubleshooting

The hidden rows appeared in the pasted data. Undo the paste, return to the source, select the full range again, and repeat Home > Find & Select > Go To Special > Visible cells only. Then copy without changing the selection. On Windows, you can also press Alt+; after selecting the range; look for the selection to break into separate visible areas before copying.

Go To Special or Visible cells only is unavailable. Make sure you have selected a worksheet range rather than editing a cell or selecting an object such as a chart. If the sheet is protected, protection settings may prevent selection or copying; ask the owner to adjust them if appropriate. If you are working in Excel for the web, open the workbook in the desktop app and use the ribbon route.

Excel reports that the action cannot be done on multiple selections. Visible cells in a filtered or hidden range can form separate areas rather than one continuous block. Try pasting to a blank worksheet, starting at one cell, instead of pasting into a selection of several destination areas. If the destination is a merged-cell range, choose an unmerged area; merged cells often prevent a multi-area paste from working as expected.

The pasted data has gaps or does not line up. Multi-area selections and the shape of the destination can affect how Excel lays out the pasted cells. Undo, paste into a clear area with no merged cells, and inspect the result there. For a filtered list, compare a unique ID or other identifying column against the source’s visible records rather than relying only on row positions.

Formulas show unexpected results after pasting. A normal paste may preserve formulas, and relative references can adjust to the new location. If you wanted the displayed results rather than formulas, undo and use Home > Paste > Paste Special > Values, then check key cells. If you need formulas to keep their original references, choose an appropriate formula-pasting option or paste into a location where those references remain valid.

Frequently Asked Questions

Does this work with filtered rows?
Yes. Select the complete range that includes the filtered-out rows, then choose Visible cells only before copying. Excel copies the records currently showing and excludes the filtered-out rows. Changing the filter changes which records count as visible.

Does it work with rows hidden manually or in a group?
Yes. The command selects visible cells in the range, so rows hidden manually or collapsed in an outline are excluded just like filtered-out rows. You do not need to unhide them first.

Will the hidden rows be deleted from my original sheet?
No. The command affects only what is selected for copying. It leaves the source data, hidden rows, and active filter unchanged.

Can I copy only visible cells on a Mac?
Yes. Use Excel’s Go To Special command and select Visible cells only, then copy with Command+C and paste with Command+V. The ribbon or menu wording and shortcut availability can vary by Mac version, so use the visible-cells option rather than relying on the Windows Alt+; shortcut.

Does Visible cells only also exclude hidden columns?
Yes. It includes visible cells in the selected range and excludes cells in hidden rows or columns. If you need a hidden column included, unhide it before selecting visible cells, or select and copy that column separately.

Can I paste the copied cells back into the same filtered list?
It is possible in some layouts, but it is harder to predict and verify because the destination may also have hidden rows. Paste to an empty, unfiltered area first, check the copied records, and then decide how to transfer them to the final location.

Related

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.