• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

how to copy & paste only filtered cells in excel 2013

N

Nitesh Kumar

New Member
Hi champs,


Kindly suggest me, how to copy & paste only filtered cells in excel 2013. i use find & select and go to special however in this only can copy filtered cells, unable to paste only filtered cells.
 
What you copy will be what you paste. If you are certain you are copying only the filtered cells then you are pasting only the filtered cells.

When you highlight your filtered data, click Find & Select on the Home tab, then Go To Special... and select Visible Cells Only. Copy those cells and paste into a new worksheet.
 
You must log in or register to reply here.
Back
Top