Short summary:
a) edit->goto and then select visible cells to select only visible ones.
b) You can pick the "select visible cells" menu item (tools->customize) to your toolbar.
c) Highlight the region, press Alt-; (semicolon) and then Ctrl-C. to copy only visible cells.
