Filter Copy

A

anshuman

Hi All,

I was using Office 2003 earlier. When I have a data set say 6 column
of data and I filter the data for a given criteria in column C, I see
the filtered data only. I then just press CTRL A + CTRL C and go to a
new sheet and paste it there to see only the filtered data going to
the new sheet.

Now I have started using Excel 2007 and whenever I do the same, the
entire data sheet gets pasted irrespective of what filter I was
using...

Why is it happening? Can someone help me here

Thanks in advance
Anshuman
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data consolidation 0
Copying Portions of Data 0
Unable to view the complete data in filter 0
Calculation Time 2
Using Filter more than once 2
data spans multiple rows within each cell is collapsed when FILTER is used 0
Office 2007 Filter Copy Issue 0
Office 2007 Copy Paste Issue 5

Top