Copy Filtered column in Full
 

I have filtered a worksheet and have been copying data from one column into
another, however the worksheet has now reverted to only allow me to copy
sequential rows, so I can only copy and paste a few cells at a time. Can you
advise how I can go back to being able to copy and paste the full column?

Copy Filtered column in Full
 

To re-enable the filtering, use the menu option Data Filter Autofilter.

Copy Filtered column in Full
 

Hi,

I will recommend that you use Advanced Filter technique. That's because if
you make any mistake while entering data, your spelling mistake can be taken
care of in the Advanced Filter. For exampe, if you enter a mispelled data in
the field then you must have to filter more than once to get the exact number
of matching records.

Challa Prabhu

"Paula" wrote:

I have filtered a worksheet and have been copying data from one column into
another, however the worksheet has now reverted to only allow me to copy
sequential rows, so I can only copy and paste a few cells at a time. Can you
advise how I can go back to being able to copy and paste the full column?