How to Copy Data & Paste into Only Visible Cells/Filtered List in Excel?
Tags: copydatapasteintoonl, kutoolsexceltutorial, kutools
Published: 2020-11-16 07:29:12

---
title: How to Copy Data & Paste into Only Visible Cells/Filtered List in Excel?
published: true
date: 2020-11-15 15:38:35 UTC
tags: CopyDataPasteintoOnl,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/how-to-copy-data-paste-into-only-visible-cells-filtered-list-in-excel/
---

In this guide, we will help you to learn the steps to **Copy Data & Paste into Only Visible Cells/Filtered List in Excel Office 365** using **Kutools.** Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Copy Data and Paste into Filtered List:

If you want to copy some data and paste it into a range of filtered list, do as below steps.

- If you have a filtered list as shown in the below image and you want to copy specific data and paste it into the range but only in the visible cells.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-11.png)<figcaption id="caption-attachment-17036">Example</figcaption>

- You need to **select the data range** that you want to paste into the filtered list.

![Select the range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/2-10.png)<figcaption id="caption-attachment-17037">Select the range</figcaption>

- Then, on the **Kutools Tab, select** the **Range** option, **choose** the **Paste to Visible** option, and **select** the **All** or **Only Paste Values** option (here, we select the **All** option).

![Paste to Visible option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/3-10.png)<figcaption id="caption-attachment-17038">Paste to Visible option</figcaption>

### Note:

- **All –** Select this option, if you want to paste all values with cell formatting into visible cells.
- **Only Paste Values –** This option is used to Paste only values of selected cells into visible cells.

- Now, it will display the **Paste to Visible Range** prompt box.
- You need to **select a cell or a range** that you want to **paste the selected data with all cell formatting**. Then, **click** the **OK** button.

![Prompt box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/4-8.png)<figcaption id="caption-attachment-17039">Prompt box</figcaption>

- Then, you will get the result as shown in the below screenshot.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/5-6.png)<figcaption id="caption-attachment-17040">Result</figcaption>

## Steps to Copy Data & Paste into Visible Cells:

If your worksheet has **multiple hidden rows** as below given image and you want to paste some data into the visible rows only, in this case, you need to use the **Paste to Visible Range** feature of Kutools.

![Example data](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/6-6.png)<figcaption id="caption-attachment-17041">Example data</figcaption>

- You need to **select the data range** that you want to paste into the visible rows only.

![Select the data range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/7-4.png)<figcaption id="caption-attachment-17048">Select the data range</figcaption>

- Then, on the **Kutools Tab, select** the **Range** option, **choose** the **Paste to Visible** option, and **select** the **All** or **Only Paste Values** option (here, we select the **Only Paste Values** option).

![Select the Only Paste Values option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/8-4.png)<figcaption id="caption-attachment-17049">Select the Only Paste Values option</figcaption>

### Note:

- **All –** Select this option, if you want to paste all values with cell formatting into visible rows.
- **Only Paste Values –** This option is used to Paste only values of selected cells into visible rows.

- Then, it will display the **Paste to Visible Range** prompt box.
- In that prompt box, you need to **select a cell or a range** that you want to paste the selected data and **click** the **OK** button.

![Click the OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/9-2.png)<figcaption id="caption-attachment-17050">Click the OK button</figcaption>

- Finally, you can see that the selected data has been pasted into the visible rows only.
- Refer to the below image.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/10-2.png)<figcaption id="caption-attachment-17051">Output</figcaption>

### Added Info:

- If the worksheet has both filtered rows and hidden rows, this feature will paste the selected data into the visible cells only.

## A Brief Summary:

In this guide, you can easily understand the steps to **Copy Data & Paste into Only Visible Cells/Filtered List in Excel Office 365** using **Kutools. ** Drop your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Keep Reading:

- [How to Color/Conditional Formatting Drop-down List in Excel?](https://geekexcel.com/how-to-color-conditional-formatting-drop-down-list-in-excel/)
- [Create Custom Lists and Fill Cells with them in Excel 365](https://geekexcel.com/how-to-create-custom-lists-and-fill-cells-with-them-in-excel-365/)