How to Copy and paste filtered or visible Data only

As an excel user, you may have come across a problem where you have a big data in excel, in which few rows are hidden or the data is filtered and you wish to copy the visible or filtered data and paste it anywhere, sometimes excel behave weird and paste the complete data instead of only visible or filtered data.

Let’s first understand the problem and then discuss the solution in detail.

The Problem:

Below is an example with some dummy data-

Let’s hide few rows (Row numbers 3 to 11 )-

How to hide rows?

Select rows from 3 to 11 -> Right click on selected rows -> then click on “hide”

Ctrl+A-> Ctrl+C (Copy)->Paste(Ctrl+V) on your desired location,

Ooops! Excel pasted the whole data.

The Solutions-

Press Ctrl+A on the data having hidden rows-> Ctrl+G or press F5. This action will open “Go to” dialog box.

-> Click on “Special” option

Choose “Visible cells only” -> Click OK ( this action will select only visible cells from complete data)

Now copy your data and paste wherever you want, you will get only visible cells-

Happy Learning 🙂

For any advance excel training in corporate or for individual query, kindly contact us.

405 total views, 3 views today