How to paste data while skipping hidden or filtered rows in Excel?
When you paste data into a filtered range, Excel may also place values in rows that are currently hidden. This article explains two ways to paste into visible cells while skipping hidden or filtered rows.
| Method | Best for | Source and destination | Key consideration |
|---|---|---|---|
| Select visible cells and enter a formula | Copying values between corresponding visible rows | Must follow the same row structure or filter | Creates formulas that remain linked to the source cells |
| Kutools for Excel | Pasting a separate copied range into visible cells only | The source and destination can use different filters | Can paste values only or include formatting |
Paste into visible cells with a formula
This method works when the source and destination correspond to the same rows—for example, when both columns are affected by the same filter. It fills the visible destination cells with formulas that reference the matching source rows.
- Select the filtered destination range, such as G3:G24, and press Alt + ; to select the visible cells only.
- In the formula bar, enter =C3, where C3 is the source cell in the first visible row. Press Ctrl + Enter to enter the corresponding formula in every selected visible cell.
📝 Note:
This method creates formulas rather than fixed values. If necessary, copy the completed results and use Paste Special > Values to replace the formulas with their current values.
Paste into visible cells with Kutools for Excel
The formula method depends on matching source and destination rows. If the copied range is not filtered, or the two ranges use different filters, Kutools for Excel's Paste to Visible feature can place the copied items into the visible destination cells in sequence.
Kutools for Excel - Supercharge Excel with over 300 essential tools, making your work faster and easier, and take advantage of AI features for smarter data processing and productivity. Get It Now
- Select the range you want to copy.
- Click Kutools > Paste to Visible. To exclude formulas and formatting, open the arrow beside Paste to Visible and select Only Paste Values.
- In the dialog box, select the first destination cell, and click OK.
The copied data is pasted into the visible cells while hidden or filtered-out rows are skipped.
Kutools for Excel - Supercharge Excel with over 300 essential tools, making your work faster and easier, and take advantage of AI features for smarter data processing and productivity. Get It Now
Demo: Paste while skipping hidden or filtered rows in Excel
Sum, count, or average visible cells only
The standard SUM, COUNT, and AVERAGE functions include hidden and filtered cells. SUBTOTAL can exclude filtered rows and, with the appropriate function number, manually hidden rows. Kutools for Excel's SUMVISIBLE, COUNTVISIBLE, and AVERAGEVISIBLE functions can calculate a range while ignoring hidden cells, rows, or columns.
Frequently asked questions
Why does Excel paste data into hidden or filtered rows?
A normal paste treats the destination as one continuous range, so hidden cells within that range may also receive data. You must use a method designed to target visible cells only.
Why does Excel say it cannot paste into multiple selections?
After you select visible cells only, Excel may treat the destination as several nonadjacent areas. A regular multi-value paste cannot always map a continuous copied range to those separate areas.
Does the formula method paste fixed values?
No. It enters formulas linked to the corresponding source rows. To keep fixed results, copy the completed cells and replace the formulas with their values.
Can Kutools paste values without formulas or formatting?
Yes. Open the arrow beside Paste to Visible and select Only Paste Values.
Why is Kutools not showing in my Excel?
Kutools may not be installed, enabled, or loaded correctly. Make sure it is installed, then go to File > Options > Add-ins to check whether Kutools is disabled. If it is installed and enabled but still does not appear, restart Excel or reinstall Kutools.
Related articles
Paste data to visible or filtered cells only
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
All Kutools add-ins. One installer
Kutools for Office suite bundles add-ins for Excel, Word, Outlook & PowerPoint plus Office Tab Pro, which is ideal for teams working across Office apps.
- All-in-one suite — Excel, Word, Outlook & PowerPoint add-ins + Office Tab Pro
- One installer, one license — set up in minutes (MSI-ready)
- Works better together — streamlined productivity across Office apps
- 30-day full-featured trial — no registration, no credit card
- Best value — save vs buying individual add-in