To copy and paste only the cells you can see in Excel for Microsoft 365 on Windows, select the range, press Alt+; to select visible cells only, press Ctrl+C, then click a single destination cell and press Ctrl+V. This is useful when a filter, manually hidden rows, or hidden columns conceal data you do not want included. The safest destination is an ordinary, unfiltered area: pasting into another filtered range can behave differently and may affect hidden rows.
What You’ll Need
- An Excel workbook with the data you want to copy, including a filtered or otherwise hidden section if applicable.
- A destination area with enough room for the visible data. For a predictable result, use a blank, unfiltered range rather than a filtered destination.
- Excel desktop for Windows for the keyboard shortcut below. On Mac, use the Go To Special menu path described in the steps. Excel for the web has limitations for selecting visible cells only; open the workbook in the desktop app if you cannot find that command.
Step-by-Step
- Identify the source range. Select the full block you want to copy, including the rows or columns where hidden cells occur. If the range has headings, decide whether to include them. For example, select the data rows beneath the headings if you want to paste records without copying the headings too. A filter does not remove rows from the worksheet; it hides them from view, so include the filtered range in your selection.
- Choose Visible cells only. In Windows Excel, press
Alt+;. Excel restricts the selection to cells that are currently visible within the range. You can also use the ribbon: Home > Find & Select > Go To Special > Visible cells only, then click OK. On Mac, use the Go To Special command from the Home ribbon or Excel’s menus; if you do not see it, use Excel desktop rather than Excel for the web. The ribbon command is a useful check if a keyboard shortcut is unavailable or behaves differently on your keyboard. - Check the selection before copying. The visible cells remain selected, but hidden rows or columns are excluded. In a filtered list, you should see selection outlines around the displayed records, not the records currently hidden by the filter. If you selected an entire worksheet column, reconsider: a very large selection can be slow and may include cells outside the data block. Select only the actual table or range when possible.
- Copy the selection. Press
Ctrl+Con Windows. The moving dashed border indicates that Excel has copied the selection. On Mac, pressCommand+C. Avoid clicking another cell before copying, because that would replace the selected source with a new selection. - Click one destination cell. Go to an empty, unfiltered area or another worksheet and click the top-left cell where the copied results should begin. Do not select a collection of separated destination cells. Excel needs a starting point for the copied range, and a single cell is usually the most dependable target.
- Paste. Press
Ctrl+Von Windows orCommand+Von Mac. The visible source cells are pasted without the hidden source records, usually as a compact, consecutive block. For instance, if a filter displays five records from a source list of twelve, copying visible cells and pasting into a blank area should bring over those five records, not the seven filtered-out records. - Choose a paste type if needed. A normal paste can include values, formulas, formatting, and other copied cell properties. If you need just the displayed results, use Home > Paste > Values or open Paste Special and choose Values. On Windows, the Paste Special dialog can be opened with
Ctrl+Alt+V; choose the appropriate option and confirm. This changes what is pasted, not which source cells are visible. - Check the pasted block. Compare the number of pasted records with the number of visible source records, and spot-check the first and last entries. Confirm that headings, formulas, and formats are what you intended. If the result is wrong, press
Ctrl+Zon Windows orCommand+Zon Mac immediately, then repeat the selection and paste carefully.
The same approach works when rows were hidden manually or by an outline, rather than by a filter: select the full relevant range first, then choose Visible cells only. It also applies to hidden columns. If you only need to copy visible columns, include the full column span in the source selection before choosing the visible-cells command.
Common Mistakes
- Copying before choosing Visible cells only. A normal selection can include hidden cells, even though they are not displayed. Select the range, apply Visible cells only, and only then copy.
- Assuming a filtered destination is safe. Pasting copied cells into a filtered list is not the same as pasting into a blank, continuous area. Excel may reject the operation, misalign the data, or put values into rows you cannot see. Do not rely on a filtered destination to protect hidden records.
- Selecting only the visible rows with the mouse. This can miss records or create a selection that does not match the full source block. Select the complete range and let Visible cells only exclude the hidden portions.
- Expecting values-only from a regular paste. Visible-cells selection controls which cells are copied; it does not strip formulas or formatting. Choose Values when you want fixed results rather than formulas or copied styles.
- Including headings by accident. If the source selection includes a header row, the header will be copied if it is visible. Start the selection beneath the heading when you only want records.
Tips
- Use a staging area for filtered data. Paste the visible records into a blank area or a new worksheet first. This gives you a continuous copy to inspect before moving or sharing it.
- Keep matching fields together. When copying several columns, select the full rectangular block so names, dates, and other fields remain aligned in the pasted output.
- Use a table filter when appropriate. If your data is an Excel table, use its filter controls to show the records you need, then select the table data range and choose Visible cells only. Clear the filter after copying if you need to see the full source again.
- Consider whether formulas should move. A normal paste can carry formulas whose cell references may adjust at the destination. Use Paste Values if the intended result is the current displayed number or text, not a formula that recalculates elsewhere.
- Keep the source filter in mind. The copy includes what is visible at the time of copying. If you change the filter after selecting cells, clear the selection and repeat the process so it reflects the current view.
Troubleshooting
Hidden rows still seem to be included. Undo the paste, reselect the entire source block, and apply Visible cells only before copying. If you used the mouse to select individual displayed rows, start again with the full rectangular range. Check that a filter has not been cleared or changed between selecting and copying.
Excel says the copy and paste areas are different sizes. This can happen when the source selection contains multiple visible areas or when you selected a multi-cell destination. Click one destination cell rather than selecting a destination range, then try again. If the destination is filtered or otherwise discontinuous, paste into a blank staging area instead. Excel’s ordinary paste is not a dependable way to map values into separate visible destination cells while leaving all hidden destination rows untouched.
The data landed in unexpected rows. Undo immediately. If the target is filtered, temporarily avoid pasting into it. You can paste the visible source into an unfiltered staging range, then update the destination using a method that matches records by a unique identifier, or temporarily clear the destination filter and carefully paste into a verified continuous range. Clearing a filter changes what is displayed; it does not delete the rows. Check row alignment before saving.
The Visible cells only command is unavailable. In Windows desktop Excel, look under Home > Find & Select > Go To Special. In Excel for the web, the desktop Go To Special workflow may not be available; choose Open in Desktop App and repeat the steps there. On Mac, use the corresponding Go To Special menu command if available rather than assuming the Windows shortcut works.
The paste contains formulas or unexpected formatting. Undo and paste again using Home > Paste > Values if you want only the copied results. If you need formulas but not the source appearance, use Paste Special and select the appropriate formula option. Inspect a few cells after pasting, especially if formulas refer to other worksheets or ranges.
Frequently Asked Questions
What is the shortcut to select visible cells only in Excel?
In Excel for Microsoft 365 on Windows, select the range and press Alt+; (Alt plus semicolon). Then copy. On Mac, use the Go To Special menu command if available; keyboard shortcuts differ.
Will this work with filtered rows?
Yes. Select the full data range, choose Visible cells only, and copy. The rows hidden by the filter are excluded from the copied source. Pasting into an unfiltered area is the most predictable option.
Can I paste only into visible rows of a filtered destination?
Do not assume a standard paste will skip hidden destination rows. Excel may reject the paste or place values in unintended rows. Use an unfiltered staging area, or use a carefully checked method based on matching record identifiers.
Does this copy visible cells from manually hidden rows too?
Yes. The command is based on what is visible in the selected range, so it can exclude rows or columns hidden manually as well as those hidden by filtering. If rows are later unhidden, they were not part of the copied visible selection.
Can I copy visible cells as values only?
Yes. First select visible cells and copy, then use Home > Paste > Values at the destination. Visible cells only determines which source cells are included; the Values option determines what cell content is pasted.
Why are hidden cells still visible in the pasted output?
They may be blank spaces or missing records rather than copied hidden values, depending on how the selection was made and the destination. Undo, select the full source range, apply Visible cells only, and paste into a blank unfiltered location. Compare the pasted records with the filtered source before using the result.
Related
- Lock an Excel Cell from Being Edited: Step-by-Step
- Keep a Zero in Front of a Number in Excel: Simple Fixes
- How to Keep Spaces Between Text When Concatenating in Excel
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Bi-Monthly Budget Template in Google Sheets: Setup GuideA bi-monthly budget template in Google Sheets can track income, planned spending, and actual expenses for each pay…
- Block an Email Sender by Name in Outlook: What WorksOutlook cannot reliably block a sender using only the display name shown in the From line. To block…
- Excel Shortcut Keys for Faster Work on Windows and MacExcel shortcut keys let you perform common tasks with the keyboard instead of navigating menus. In Excel for…
- Excel Data Validation for Multiple Lists: Setup and TipsYes. Excel can use data validation to create several dropdown lists in a workbook: give each dropdown its…
- Can You Merge Cells in Excel? Options and LimitsYes, you can merge cells in Excel for Microsoft 365 on Windows: select the cells, then choose Home…
- Smartsheet DataTable Explained: Uses, Setup, and LimitsA Smartsheet DataTable is a centrally managed data store that can feed selected records into Smartsheet sheets, helping…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.