To paste while rows are hidden in Excel, first decide whether the hidden rows should receive data. If they should, temporarily unhide them, paste into the full range, and hide them again. If you want to change visible cells only, use a method designed for visible cells: for one repeated value, select visible cells and press Ctrl+Enter; for different values, prepare a full-size paste block with blanks for hidden rows and use Paste Special with Skip blanks. These steps are for Excel for Microsoft 365 on Windows.
What You’ll Need
- A workbook with the destination rows hidden manually or filtered out.
- The data you want to paste, and a clear idea of whether hidden rows should change.
- For the different-values-only method, a temporary paste block the same height as the destination, with blank cells where rows are hidden.
- For filtered lists, the filter criteria or a way to restore the current view after pasting.
Step-by-Step
- Save a working copy if the existing data matters. Pasting over cells can replace values or formulas, and Undo may not be available after every action. If the sheet is important, use File > Save As to create a copy before changing it.
- Identify how the rows are hidden. A row may be hidden manually, or it may be excluded by a filter. A filtered row is still part of the worksheet; it is simply not displayed. This distinction matters because a paste into a continuous range can include rows you cannot see.
- Choose what should happen to hidden rows. If the paste should update every row, including hidden ones, use the all-rows method below. If hidden rows must remain unchanged, use the visible-only method. Do not assume that dragging over what looks like a visible block selects only displayed cells.
- For a paste that should include hidden rows, reveal the full destination range. For manually hidden rows, select the row numbers above and below the hidden section, right-click the selected row headings, and choose Unhide. If the rows are hidden by a filter, open the filter drop-down and choose Clear Filter From, or select the relevant items so all destination rows appear. Clearing a filter changes the view; it does not delete records.
- Copy and paste into the now-visible continuous range. Select the source cells and press Ctrl+C. Select the top-left destination cell and press Ctrl+V. Check that the source and destination have the intended number of rows and columns before pasting. When the paste is complete, restore the filter or manually hide the rows again.
- For the same value in visible cells only, select the destination cells. If a filter is applied, select the cells in the destination column across the filtered records. To avoid including hidden rows, choose Home > Find & Select > Go To Special > Visible cells only, then select OK. In many Windows installations, Alt+; is the shortcut for Visible cells only after selecting the range.
- Enter the repeated value without pasting a block. Type the value, or enter a formula if that is what you intend, then press Ctrl+Enter. Excel enters the typed content into all selected visible cells. Check a few rows and confirm that hidden rows did not change. This is useful for setting one status, date, or label in the visible records.
- For different values in visible rows only, make a full-height paste block. Put each replacement value in the row where it belongs, and leave the corresponding cells blank for rows that must stay unchanged. The block must line up with the destination range, including the hidden rows. For example, if the destination covers rows 2 through 6 and rows 3 and 5 are hidden, the five-row block needs values for rows 2, 4, and 6, with blank cells in the positions for rows 3 and 5.
- Paste that block with Skip blanks enabled. Copy the prepared block. Select the matching full destination range, including hidden rows, and choose Home > Paste > Paste Special. In the Paste Special dialog, select Values if you want to paste values only, then check Skip blanks and select OK. The blank cells in the source block are skipped, so they do not replace the hidden rows’ existing contents. Use this method only after checking the row alignment carefully.
- Verify the result before restoring the view. Inspect several visible destination cells and, if possible, temporarily reveal a hidden row to confirm it stayed unchanged. Check the top and bottom of the range for off-by-one errors. Restore the original filter or hidden-row arrangement once the data is correct.
Common Mistakes
- Assuming hidden rows are excluded automatically. Copying or pasting a continuous range can include hidden rows. A filtered view does not turn the displayed cells into a separate range.
- Using a source block that is too short. When the destination includes hidden rows, the source and destination positions may no longer match the visible sequence. Excel can fill hidden rows or shift data into the wrong records.
- Selecting noncontiguous cells and expecting an ordinary paste to work. Visible-only selection can create a multiple-area selection. Excel may reject a standard paste into it or distribute data differently than expected. Ctrl+Enter is suitable for one repeated entry, not a list of different values.
- Leaving Skip blanks unchecked. If your prepared block contains blank cells for hidden rows and you paste normally, those blanks can erase existing destination contents. Use Paste Special and check Skip blanks.
- Forgetting that filters hide records rather than remove them. Clearing a filter reveals the records; it does not delete them. Conversely, sorting or changing filter criteria during a paste can make it harder to confirm which records received the data.
- Pasting formulas when you meant to paste results. A formula can adjust its references when pasted. Choose Values in Paste Special when the destination should receive fixed results rather than formulas.
Tips
- Keep a copy of the original data. A duplicate sheet or workbook gives you a quick way to compare results, especially when you are working with filtered records.
- Use the status bar as a rough check. After selecting visible cells, Excel may show a count for the selection at the bottom of the window. Compare that count with the number of values you plan to enter. The exact indicators depend on the selected data.
- Test on a small range first. If the sheet has many hidden rows or the paste block is complicated, try the same process on a few records in a copy of the sheet before changing the full list.
- Choose Values for fixed data and formulas for calculated data. Paste Special > Values avoids bringing over source formatting and formulas. A normal paste can bring formatting and other cell content along with the values.
- On Mac, use the menus when the Windows shortcut differs. Alt+; is a Windows shortcut. In Excel for Mac, select the range and use Home > Find & Select > Go To Special > Visible cells only if that option is available in your build. Keyboard shortcuts vary by keyboard and Excel version, so the menu path is the safer instruction.
- Use the desktop app for this task. Excel for the web has fewer selection and paste-special controls than the Windows desktop app. If you cannot find Visible cells only or Skip blanks, choose Open in Desktop App and continue there.
Troubleshooting
Hidden rows changed even though I did not see them. Undo immediately with Ctrl+Z if the paste is still the most recent action. Then reveal the rows or undo the paste, check the full selection, and use a visible-only method. If Undo is no longer available, compare with a saved copy or version history before making further edits.
Excel says the command cannot be used on multiple selections. This can happen when Visible cells only creates separate selection areas. For a single repeated entry, type the content and press Ctrl+Enter. For different entries, avoid pasting a short list directly into the separated cells; use the aligned full-height block with Paste Special > Skip blanks, or temporarily reveal the rows and paste into a continuous range when all rows should be updated.
The values landed on the wrong records. Stop and undo if possible. Check whether the source list is in the same order as the destination and whether the paste block includes one position for every row, hidden or visible. Restore the original sort order before trying again; filters and sorts can change the record sequence without changing the data itself.
Blank source cells erased existing content. Undo, then repeat the paste through Home > Paste > Paste Special and select Skip blanks. Confirm that the cells intended to be left alone are genuinely blank in the copied source block, rather than containing spaces or formulas that return an empty-looking result.
I cannot find Visible cells only. In Excel for Microsoft 365 on Windows, select the range first, then open Home > Find & Select > Go To Special. Choose Visible cells only in the dialog. If you are using Excel for the web, switch to the desktop app; if you are on Mac, use the menu rather than relying on the Windows shortcut.
Frequently Asked Questions
Does Excel paste into hidden rows?
It can. If you select a continuous destination range, hidden rows may still be included. Make them visible before a paste that should update every row, or use a method that protects hidden rows.
How do I paste into visible cells only with the same value?
Select the destination range, choose Home > Find & Select > Go To Special > Visible cells only, type the value, and press Ctrl+Enter. Check a few hidden rows afterward to confirm they were not changed.
Can I paste different values into filtered rows without changing hidden rows?
Yes, but do not paste a short contiguous list directly into the visible selection. Prepare a full-height block aligned to the destination, leave blank positions for rows to preserve, then use Paste Special with Skip blanks.
Will clearing a filter delete or alter hidden records?
No. Clearing the filter displays rows that were excluded by its criteria. It does not remove those records. You can restore the filter after the paste.
Can I do this in Excel for the web?
Some basic pasting works, but selection and Paste Special options can differ from the Windows desktop app. Open the workbook in the desktop app if you need Visible cells only or Skip blanks and cannot find those controls online.
What is the safest method if I am unsure?
Save a copy, reveal the rows, and paste into a continuous range if every row should receive data. If hidden rows must stay unchanged, test the aligned-block and Skip blanks method on a small copy first.
Related
- Merge Two Excel Files in Power Query: Step-by-Step
- How to Move Cells in Excel Without Overwriting Data
- Merge Names in Excel from 3 Cells
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Column Drop-Down List: Create and Manage OneTo add a drop-down list to an Excel column, select the cells that should contain it, then choose…
- Disable Circular References in Excel: Causes and FixesTo stop Excel for Microsoft 365 on Windows from calculating circular formulas iteratively, go to File > Options…
- Excel Data Validation List: Can It Show Two Columns?No. In Microsoft Excel for Microsoft 365 on Windows, an in-cell data validation dropdown displays one column of…
- Excel: How to Paste Only Into Visible RowsTo enter the same value in filtered rows without changing hidden rows, select the destination cells, choose Home…
- How to Add a Running Header in Word, Step by StepTo add a running header in Microsoft Word, open the document, choose Insert > Header, select a layout,…
- How to Add Sound to Slide Transitions in PowerPointTo add a sound to a slide transition in PowerPoint for Microsoft 365 on Windows, select the slide,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.