Copy Data in to a Filtered List in Excel - Challenge

Excel 1273 views 6 replies

 Challenge - How do you copy data in to a filtered list in Excel 

Replies (6)

by using past special options
 

Use "select visible cell" icon and copy the filtered data.

Acrually its not achallenge its tutorial

Dear Sir,

 

In my opinior: -

Try to Unfilter it and then try pasting the data.

Further If you require then send a sample sheet in which you require assistance.

 

Originally posted by : GN Sahu

Use "select visible cell" icon and copy the filtered data.

Agreed!

Before copy & paste to filtered data make sure that the data is properly sorted.


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register