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
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