Manipulating filtered data

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.

[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]