Copy in Excel Excluding Hidden Cells: A Step-by-Step Guide

How-to basics · Updated November 20, 2026

To copy cells in Excel while leaving out hidden rows or columns, select the range, choose Home > Find & Select > Go To Special > Visible cells only, then copy and paste. In Excel for Microsoft 365 on Windows, Alt+; selects visible cells only after you select the range. This copies the visible content without changing which rows or columns are hidden in the original sheet.

What You’ll Need

  • A workbook open in the Excel desktop app, preferably Microsoft Excel for Microsoft 365 on Windows.
  • A range of cells that includes the rows or columns you want to copy, including any that are hidden or filtered out.
  • A destination area with enough room for the visible data. If you want to preserve the source, paste into a separate area or worksheet.

Excel cells themselves are not hidden individually: their entire rows or columns are hidden, or a filter makes certain rows not appear. The method below works for manually hidden rows and columns as well as rows excluded by a filter. Hiding a worksheet tab is a different situation; unhide that sheet before selecting and copying its cells.

Step-by-Step

  1. Identify the range you want to copy. Click and drag over the relevant cells, or click the first cell and Shift-click the last cell. Include a header row if you want the header copied too. For example, if a table runs from A1 to D30, select A1:D30. Selecting just the table area is usually easier to manage than selecting entire worksheet columns or the whole sheet.
  2. Check what is hidden. Look for gaps in the row numbers or column letters, or check whether filter buttons are active in the header. You do not need to unhide anything. Confirm that the visible rows and columns are the ones you intend to copy; if a filter is active, Excel will exclude rows that the filter currently hides.
  3. Select visible cells only. On Windows, press Alt+; (Alt and the semicolon key) while the range is selected. Alternatively, use Home > Find & Select > Go To Special, choose Visible cells only, and click OK. In the Go To Special dialog, make sure the correct option is selected before confirming. Excel changes the selection to the visible parts of your original range.
  4. Copy the selection. Press Ctrl+C, or choose Home > Copy. A moving border may appear around the selected area. The border can make the selection look like one large rectangle even when some rows or columns are hidden; that appearance does not necessarily mean the hidden cells were included.
  5. Choose a destination. Click the top-left cell of a blank, unfiltered destination area, or go to another worksheet and click its top-left destination cell. Leave enough clear space for the visible data. If the source has multiple columns, the destination needs room for the same number of columns. Avoid placing the copied block over data you need to keep.
  6. Paste. Press Ctrl+V or choose Home > Paste. Excel pastes the visible cells and omits the source rows or columns that were hidden. If the source was filtered, the visible records normally appear together in the destination rather than leaving gaps for filtered-out records. Check the result before deleting, moving, or changing the original data.
  7. Choose a paste option if needed. Standard paste carries over cell contents, formulas, formatting, and other copied cell properties. If you need only the displayed results, use Home > Paste > Values (the Values option in the Paste menu). If you need formatting but not formulas, choose a suitable paste option from that menu. Confirm the pasted values or formulas are appropriate for their new location.
  8. Verify the copied block. Compare its first and last records with the visible source rows. Check the number of records if an exact count matters, and inspect any important totals or formulas. When you are satisfied, press Esc to clear the copy border. The operation does not unhide or delete anything in the original range.

On a Mac, use the same general Go To Special approach if the command is available in your Excel version: select the cells, open the Home tab, choose Find & Select and then Go To Special, and select Visible cells only. Keyboard shortcuts can differ by Mac version and keyboard layout, so use the dialog rather than assuming the Windows Alt+; shortcut applies. Excel for the web may not expose the same Go To Special controls; if you cannot find Visible cells only, open the workbook in the desktop app and perform the selection there.

Common Mistakes

  • Copying before selecting visible cells only. Ctrl+C by itself copies the selected range, which may include hidden rows or columns. Apply Visible cells only first, then copy.
  • Confusing a hidden worksheet with hidden rows. This procedure selects visible cells within an open worksheet. If the worksheet tab itself is hidden, right-click a sheet tab, choose Unhide, and select the worksheet before continuing.
  • Expecting the source to change. The command affects the copy selection only. It does not reveal hidden rows, remove filters, or delete hidden data from the original worksheet.
  • Selecting too much. Copying entire columns or the whole worksheet can make it hard to identify the destination size and may include unrelated data. Select the smallest complete block that contains the records you need.
  • Assuming a filtered destination behaves the same way. Selecting visible cells in the source controls what is copied; it does not automatically guarantee that a filtered destination will receive data only in its visible rows. Paste into an unfiltered staging area first if the destination is also filtered.
  • Overlooking formulas and formatting. Regular paste may bring formulas, number formats, borders, and other cell properties along with the values. Use a Paste option suited to your goal and check formulas that refer to other cells.

Tips

  • Use the keyboard shortcut for repeat tasks. On Windows, Alt+; is the quickest route after selecting the range. If it does not work with your keyboard layout, use the Go To Special dialog instead.
  • Keep the header with the data. If you want column names in the copied result, include the header row in the initial selection. If you do not, select only the data rows so the header is not repeated.
  • Copy to a new worksheet for a clean extract. Click the plus button by the sheet tabs to create a sheet, then paste at A1. This keeps the copied extract separate from the filtered or formatted source.
  • Use Paste Values for a snapshot. If you want a fixed copy of the currently calculated results rather than live formulas, choose Home > Paste > Values. This is useful for sharing a report or preserving the visible results before the source changes.
  • Leave filters in place until you verify the copy. The active filter defines which records are visible at the time of selection. Check the pasted data before clearing the filter, especially if you may need to repeat the extraction.
  • Remember that hidden columns are excluded too. Visible cells only applies to both hidden rows and hidden columns within the selected range. If you want hidden rows omitted but need a normally hidden column, unhide that column before copying, then hide it again afterward if appropriate.

Troubleshooting

The pasted result contains rows that were hidden. Return to the source and select the intended range again. Before copying, use Alt+; on Windows or open Go To Special and choose Visible cells only. Then copy and paste again. If the rows were hidden by a filter, make sure the filter is still set the way you want; changing or clearing it before selecting can change which records are visible.

Visible cells only is unavailable or the dialog is hard to find. Confirm you are in the desktop Excel app and have selected a worksheet range. Use Home > Find & Select > Go To Special. If you are in Excel for the web, the desktop command may not be available in the same place, so choose Open in Desktop App and repeat the selection there.

Excel says the command cannot be used on multiple selections, or the paste looks wrong. Visible cells only can create a selection made of separate areas. Try copying the range again and pasting into a clear, unfiltered area on a worksheet. Avoid selecting several separate source blocks at once; copy one rectangular source range at a time. If you are pasting into another filtered list, first paste into a blank staging area and then handle the destination separately.

The result is missing a column or some records. Check whether the missing cells were in a hidden column or in rows filtered out at the moment you copied. Unhide the column or adjust the filter if those items should be included, then repeat the process. Also verify that the original selection covered the full width and height of the data block.

The pasted formulas show unexpected results. Normal paste carries formulas, which can adjust their references when moved. Undo immediately with Ctrl+Z if the paste has just happened and you want to reverse it, then repeat using Home > Paste > Values if you need fixed results. If the formulas are required, inspect a few references and confirm they point to the intended cells in the new location.

Frequently Asked Questions

Does Visible cells only work with filtered rows?

Yes. It works with rows hidden by a filter and with rows or columns hidden manually. It selects the visible cells inside the range you selected, so filtered-out rows are left out of the copy.

Will this delete or unhide anything in my original worksheet?

No. It changes which cells are included in the copy operation. The original hidden rows and columns remain hidden, and their contents remain in the workbook.

Can I copy visible cells only with a keyboard shortcut?

In Excel for Microsoft 365 on Windows, select the range and press Alt+;. Then copy with Ctrl+C. On Mac, shortcuts can vary, so use Home > Find & Select > Go To Special if available.

Can I copy only the values and not the formulas?

Yes. Select visible cells only, copy, and use Home > Paste > Values at the destination. The pasted cells contain the results rather than the original formulas.

Does the method skip hidden columns as well as hidden rows?

Yes. Visible cells only excludes hidden rows and hidden columns within the selected range. Unhide any column you want included before copying.

Why do I see gaps or a strange layout after pasting?

The source selection may consist of separate visible areas, or the destination may have its own hidden rows or filters. Paste into a blank, unfiltered area first and compare the result with the visible source before using it elsewhere.

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.