Manipulating filtered data

[John Leonard <johnl119 yahoo com>]

Not sure if I am missing something obvious but I can't
work out how to manipulate filtered data.

For example if you filter a spreadsheet on some
attribute and then try to copy the filtered (visible)
results to a new file the entire spreadsheet gets
copied across including all the hidden cells. The same
goes for the fill-down feature which fills all the
hidden cells as well as the visible ones.

Anyone know a way around this? How do you just select
the visible cells?


      ____________________________________________________________________________________
Never miss a thing.  Make Yahoo your home page. 
http://www.yahoo.com/r/hs