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


  1. Posts : 472
    windows 7 32-bit
       #1

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


    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?
    Attached Thumbnails Attached Thumbnails Copying filtered table doesn't work as it is expected in Excel 2010-image-no.-1.png   Copying filtered table doesn't work as it is expected in Excel 2010-image-no.-2.png   Copying filtered table doesn't work as it is expected in Excel 2010-image-no.-3.png  
      My Computer


  2. Posts : 10,796
    Microsoft Windows 7 Home Premium 64-bits 7601 Multiprocessor Free Service Pack 1
       #2

    Rows 6,9,13,14,16-19 are hidden! Unhide them after the copy/paste action. You can do that by not applying the filter anymore afterwards! So the data you want is just there as you want it. Only you did hide it.

    Not odd at all
      My Computer


  3. Posts : 472
    windows 7 32-bit
    Thread Starter
       #3

    you are right completely. Thank you very much.:)
      My Computer


  4. Posts : 10,796
    Microsoft Windows 7 Home Premium 64-bits 7601 Multiprocessor Free Service Pack 1
       #4

    Kurdman said:
    you are right completely. Thank you very much.:)
    Tip of the day: Don't put any data to left and right of data you probably gonna hide/filter. don't put any data underneath data you probably gonna hide/filter (tables can extend).

    In short: Put extra stuff only above the table.
    In your case you better move/paste in another sheet.
      My Computer


  5. Posts : 472
    windows 7 32-bit
    Thread Starter
       #5

    Thanks again.
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd
All times are GMT -5. The time now is 22:32.
Find Us