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

Franky · 02 Jun 2014

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?

Kaktussoft · 02 Jun 2014

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

Franky · 02 Jun 2014

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

Kaktussoft · 02 Jun 2014

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.

Franky · 03 Jun 2014

Thanks again.