Filter in Excel 2007

X

xinzhong_li

We know we could create a small subset table from a large table by
cutting and pasting the results from a filter. Be careful, you will
get wrong results in Excel 2007.

For example, in a data table, 4th and 8th rows are filtered out from
the first 10 rows, cut these 8 rows and paste into a new file, you
will get a table with 10 rows. Surprise?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 Filtering Options 3
Checkbox issue - Checkbox overlapping when filter is applied 1
Filter out rows based on the value of a cell 4
Counting the Unique Numbers 2
How can I get Excel 2007 to consider only filtered cells? 2
Excel wrapping incorrectly 1
Hitting the limits with Excel and need about 1 million rows of data.What is the best option for what 1
Visible row index after applying a filter in Excel 1

Top