Copy Only Visible Cells in Excel Without Hidden Data

How-to basics · Updated November 20, 2026

To copy only visible cells in Excel for Microsoft 365 on Windows, select the range, choose Home > Find & Select > Go To Special > Visible cells only, and select OK. Press Ctrl+C, click the destination, then press Ctrl+V. This copies visible cells while leaving filtered-out rows and manually hidden rows or columns behind.

What You’ll Need

  • A workbook open in the Excel desktop app. The steps below use Microsoft 365 for Windows.
  • A source range with rows or columns hidden by a filter or hidden manually. You can include headers, but include them only if you want them copied.
  • A clear destination, such as a blank area or a new worksheet, with enough room for the visible data.

You do not need a formula or add-in. If you are using Excel for the web and cannot find Go To Special, open the workbook in the desktop app for the most reliable method. Menu names and shortcuts can vary slightly by platform and keyboard layout.

Step-by-Step

  1. Set up the view you want to copy. Apply your filter, hide the rows or columns you do not want, or keep the relevant cells visible. Check the worksheet before selecting anything: a filtered list shows only matching rows, while manually hidden rows are hidden independently of a filter. Decide whether the header row should be included. For example, if a table has a header in row 1 and filtered records in rows 2 through 50, select the header too only if you want it in the copied result.
  2. Select the full source range. Drag across the cells you want to copy, or click the first cell, hold Shift, and click the last cell. Include all required columns and rows, even if some rows or columns within the range are hidden. For a large table, click inside it and use the table’s range-selection controls or select the relevant range from the Name Box. Avoid selecting entire worksheets unless that is genuinely what you need; a smaller range is easier to inspect and paste.
  3. Open Go To Special. On the ribbon, choose Home > Find & Select > Go To Special. In the dialog, select the option labeled Visible cells only, then select OK. Excel changes the selection so it includes only cells that are currently visible within the range you selected. Hidden rows and columns are excluded from this selection, but visible cells in the included columns and rows remain selected.
  4. Check the selection before copying. Look for the selection outline and the visible cell highlights. A selection containing separated blocks can look unusual because Excel skips hidden areas; that is expected. If the highlight includes cells outside the intended columns or records, press Esc, select the correct source range again, and repeat Go To Special. This quick check can prevent accidentally carrying extra fields, such as notes or internal IDs, into another sheet.
  5. Copy the selected cells. Press Ctrl+C on Windows, or choose Home > Copy. A moving border should appear around the copied selection. Do not click another cell in the source range and start typing while the copy border is active, because that can cancel the copy operation. If you change your mind, press Esc to clear the copy border.
  6. Choose a suitable destination and paste. Click the upper-left destination cell in a blank area or on another worksheet, then press Ctrl+V. On a Mac, use Command+C and Command+V for copying and pasting; the ribbon route is also available, and the Go To Special shortcut may differ by keyboard and Excel version. When copying visible records from a filtered list, Excel normally places the copied visible records together at the destination rather than inserting hidden records between them. Check the pasted result, especially if you copied several separated blocks.
  7. Choose the right kind of paste if needed. Standard paste carries the copied cells’ contents and formatting, and formulas remain formulas. To paste just the displayed or calculated results, use Home > Paste > Values after copying; the exact Paste menu layout can vary with the ribbon display. If you want formatting as well as values, use the appropriate Paste Special option instead. Confirm the result before deleting or changing the source, and save the workbook if the copied data is important.

The menu method is the safest approach when you are not sure which shortcut your keyboard supports. In Windows desktop Excel, after selecting a range, Alt+; is the shortcut for selecting visible cells only. You can also open Go To with Ctrl+G or F5 and choose Special, then Visible cells only. If the shortcut does not respond, use the ribbon path rather than assuming the selection has changed.

Common Mistakes

  • Copying before choosing Visible cells only. If you simply select a range that includes hidden rows, the copied result may not match what you see on screen, particularly when rows were hidden manually. Make the visible-cells selection explicitly, then copy.
  • Selecting too small or too large a range. Visible cells only works inside the range you selected; it does not automatically find every related cell in the worksheet. If you select only one column, other fields will not be copied. If you include unrelated columns, they may be included too. Confirm the range boundaries first.
  • Forgetting the header or including an unwanted one. The selection includes whatever you marked. Include the header row if the pasted list needs labels; leave it out if you are appending records beneath existing headings. If the header is in a separate range from the records, copy it separately when that is clearer.
  • Assuming copy means values only. Ctrl+C and Ctrl+V usually carry formatting and formulas as well as cell contents. If you need a plain list of results, choose Paste Values. Be aware that formulas pasted normally can refer to different cells at the new location because Excel adjusts relative references.
  • Pasting onto the source or into another filtered area. A destination that overlaps the source, contains merged cells, or is itself filtered can make the result confusing or trigger an error. Use a clear blank destination, preferably on a separate sheet, and check that enough room is available.
  • Expecting hidden cells to be deleted. This process copies visible cells; it does not change the source or remove hidden records. The original hidden rows and columns remain in the workbook unless you separately unhide or delete them.

Tips

  • Use a new worksheet for a clean extract. Click the plus button beside the sheet tabs to create a sheet, then paste into A1. A separate sheet reduces the chance of overwriting existing information and makes the copied list easier to review.
  • Keep labels with the data. When the result will be shared or analyzed later, include a single header row so each pasted column has a clear meaning. If you will append records to an existing table, omit the header to avoid duplicating it among the records.
  • Choose whether you want formulas or results. Use ordinary paste if the destination should retain formulas and formatting. Use Paste Values if you want fixed results that will not recalculate or carry source formulas. This is particularly useful when sending a static extract to someone else.
  • Review totals and record counts. Compare the number of visible records with the number of pasted rows. A quick count can reveal whether a header was included or a row was missed. Also inspect the first and last records and any important identifier column before relying on the extract.
  • Remember that filters and manual hiding both affect visibility. Visible cells only follows the current display. If a row is hidden manually, it is excluded just like a filtered-out row. Clear or adjust the filter and unhide rows first if you need those records in the copied range.
  • Use the desktop app when menu options are missing. Excel for the web has a different feature set and interface, and some Go To Special controls may not be available in the same way. Opening the workbook in Excel for Windows or Mac gives you a more dependable path to the visible-cells selection.

Troubleshooting

The pasted result contains hidden rows. Return to the source, select the intended range, and repeat Home > Find & Select > Go To Special > Visible cells only before copying. Make sure the selection was changed before you pressed Ctrl+C. If the rows are hidden manually, not filtered, they still need to be excluded with this explicit selection.

Visible cells only is unavailable or hard to find. Confirm that you are using the Excel desktop app and that a cell range is selected. On Windows, follow the ribbon path rather than relying on a shortcut. In Excel for the web, open the workbook in the desktop app. On Mac, use the available Find & Select or Go To Special controls in the Excel ribbon or menus; keyboard shortcuts can differ, so verify the selection visually.

Excel says the command cannot be used on multiple selections, or paste behaves oddly. Visible cells can create a selection made up of separate areas. Try copying the selected range and pasting into a blank area on a new sheet. Avoid a destination containing merged cells, a filtered table, or existing data that could be overwritten. If the selection is very complicated, copy one logical block at a time and paste each block into its own destination area.

The destination has unexpected gaps or formatting. Inspect the source selection and the pasted cells. Copying visible cells does not mean paste values only, and merged cells or different column widths can affect how the result looks. Use Paste Values for contents without source formatting, or paste into a clean worksheet and adjust column widths afterward. Do not assume the data is wrong just because the new sheet looks different.

Some records you expected are missing. Check the filter criteria and unhide any rows or columns that should be part of the extract. Go To Special includes only cells visible at the time you run it. If you change the filter after selecting visible cells, cancel the old selection and select the range again so the copied set matches the current view.

Frequently Asked Questions

Does Excel automatically skip filtered-out rows when I copy?
Copying a filtered list often excludes filtered-out rows, but manually hidden rows and complex selections can make results less predictable. Explicitly select Visible cells only when you need a reliable copy of exactly what is showing.

Can I copy visible cells from both filtered rows and hidden columns?
Yes. Select the full range containing the relevant rows and columns, choose Visible cells only, and copy. Excel excludes cells hidden by the current filter or by manually hidden rows or columns. Review the result if the range contains several separated blocks.

Will this copy formulas, formatting, and comments?
Standard copy and paste can carry formulas and formatting along with cell contents. Use Paste Values when you want the results without formulas. Inspect the pasted cells if you rely on comments, notes, validation, or other cell features, because the paste option determines what is carried over.

Can I use Alt+; on a Mac?
Alt+; is the Windows shortcut for selecting visible cells only; it is not the standard Mac equivalent. Use the Go To Special or Find & Select menu route in your Mac version of Excel, and confirm the selected cells before copying.

Can I do this in Excel for the web?
The web interface may not offer the same Go To Special workflow as desktop Excel. For a precise visible-cells-only selection, choose Open in Desktop App and follow the Windows or Mac steps there.

Does copying visible cells change or delete the hidden data?
No. It creates a copy of the visible cells at the destination and leaves the source worksheet unchanged. Hidden rows and columns remain in place unless you separately edit or delete them.

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.