Results 1 to 3 of 3

Thread: Copying filtered table doesn't work as it is expected in Excel 2010

  1. #1

    Copying filtered table doesn't work as it is expected in Excel 2010



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi all,

    I have a small table and want to copy it after filtering. The image is in below (image no. 1), and I have filtered it to shows only the red font color of the column "Days" as follows, (image no. 2).

    Now everything is ready to start the copying! So I select all the table (Double CTRL+A inside the table) then go into the "Go to special" dialog box and choose the "Visible cells only". Then I simply copy that selected filtered range of that table and paste it as follows, (image no. 3);

    As it's clear, the right-side of the image shows the result of the copy-paste which of course is very odd! Why not all of the visible rows are pasted please?


    Click image for larger version. 

Name:	image no. 1.PNG 
Views:	7 
Size:	25.5 KB 
ID:	2383


    Click image for larger version. 

Name:	image no. 2.PNG 
Views:	5 
Size:	15.1 KB 
ID:	2384

    Click image for larger version. 

Name:	image no. 3.PNG 
Views:	8 
Size:	23.9 KB 
ID:	2382

  2. #2
    You are copying it to the same rows that you filtered, and where there are hidden rows, so so of your newly copied data is also hidden. Copy it to a separate sheet or below the original table.

  3. #3
    Thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •