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
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,681
    Articles
    0
    Excel Version
    O365
    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
  •