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

abbasi

New member
Joined
Apr 23, 2014
Messages
21
Reaction score
0
Points
0
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?


image no. 1.PNG


image no. 2.PNG

image no. 3.PNG
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,942
Reaction score
0
Points
36
Excel Version(s)
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.
 
Top