Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Filtered column in Full
To re-enable the filtering, use the menu option Data Filter Autofilter.
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy data to filtered column | Excel Discussion (Misc queries) | |||
How to copy a filtered range ? | Excel Discussion (Misc queries) | |||
How I can print full text bigger than column, in repeat column | Excel Discussion (Misc queries) | |||
How do I type over the face of my full spreadsheet...like "COPY"? | Excel Discussion (Misc queries) | |||
how to copy 2350 hyperlink full paths to any column in a worksheet ? | Excel Discussion (Misc queries) |