Need help! Copy cell using filter

[tii]

Hi All,
I'm a beginner of using the excel. I like to know how can I copy fro
one cell (both text and number) into another cell. But with exception
For example:

Heading: Topic Score
1 Math 30
2 History 50
3 Computer 0

I want to copy both column include heading and data contain in ro
1,2,3 into another cell, but only not to copy value "0" so result woul
be something like this:

Heading: Topic Score
1 Math 30
2 History 50

If some of you know how to, please tell me how to do. Appreciate fo
all your help.

thank you
Ti

 

[Kieran]

Tii,

I think the biult in feature found under the data menu, option filter
sub-option autofilter will help you here.

When the autofilter is turned on (make sure your active cell i
somewhere in your list first), you will see some little arrows appea
on the heading row of your list.
These arrows allow you to filter the list. (see online help for th
options).
When you have got the list filtered to your liking, you can then cop
the data and headings as normal