The Spreadsheet Import Filter imports only text and not the graphic representation of the worksheet (that is, charts, graphs, borders), giving you the most flexibility for arranging the data in a layout. Excel 97Excel 98Excel 2000Excel 2002Excel 2003Excel X. InDesign CS2 for Mac OS. In this video, Susan Mershon, Technology Coach & Trainer shows you how to sort and filter data in Microsoft Excel 2011 for MAC. This step by step video includes detailed instructions along with tips and tricks. If you need help sorting and filtering this is the video to watch.

I just got an email that says you cannot copy only the filtered data in Excel 2007. If you use the autofilter to make a selection and then you only want to copy the filtered rows, Excel 2007 copied everything, even the hidden rows. This is different from the way Excel 2000-2003 works. You can recognize when it is going to work correctly by double, moving striped-lines: If the double-lines don't show, the hidden rows are copied too: If it doesn't work, here are some workarounds: Workaround 1 If you convert your table to a 'table' it works as you would expect.

Select the cells and then in the Excel menu choose: Insert > Table. After you've done this is works just as in the previous Excel versions. Workaround 2 Make your selection, then press F5 (go to.) then click on the 'Special.' Button and choose 'Visible cells only'. When you now copy, only the visible result of your filter will be copied and pasted. The ultimate workaround (and fix?) I can reproduce the bug in a certain situation. If I have my data, select the header row and then apply the filter, the filtering works but it copies all the data.

If I select the entire data-range or a single cell in it and then apply the filter it works as expected. This behavior is different from Excel 2000, 2002/XP and 2003.

Conclusion The way it works entirely relies on which cells you have selected before you apply the filter. My advice is to select the entire range and then apply the autofilter. Kanwaljit Singh Dhunna, on Said: Hi Bastien, May the couple live 1000 years:) The above bug affects when the filters are applied using the entire row / or a specified range within the data (not only the Header row). And it affect only for the First time the Filters are used after applying them in the way specified before.

If we reapply the filters or reuse them for 2nd time, it will behave properly. So the simple workaround is: click on a cell anywhere within the range, apply the filter, use them and have a good night's sleep.

Good Night Regards CA Kanwaljit Singh Dhunna •. Seanc, on Said: I've been looking into this problem, and playing with the various work arounds listed here.

The solution for me is 'The ultimate workaround (and fix?)'. If I select the header cells where I want the filter, and then apply the auto filter, copying any filtered data also copies the hidden items. If I select the complete range, or a single cell in that range, and now apply the auto filter, when copying filtered data I now only copy the visible items. This appears to be the case whether or not the 'Extend data range formats and formulas' is selected, and seeing as this can be a useful function then I will leave it ticked for now.

The reason I often select the row where I want the filters to appear is that I sometimes have data in the row above it, and Excel does not always want to use the same row as me! It looks like in these cases I will have to format as a table. Some things just don't need changing! Felipe, on Said: Hi Focus, I try to figure out how resolve the problem with filters in excel 2007 (ver. 12.0.6300.5000) SP1 MSO (12.0.6213.1000). I filtered some list by some value, the list obsvously reduce from orignal line numbers, now when I try to copy a value to the interval, means only these filtered cell should be update with the new value, but does not work like should.

Excell 2007 applies the new value to all cell (not listed on filter) between the range of firt occurer of criteria filter and the last Lets supose the list has type of car and collors of the cars, so I filterd 'ferraris' and see how many ferraris has in my filtered list and the collors of theses cars. Now I can change de color (value of cell) of all ferraris, and when I do that, excel applies not only on ferraris, but in porches, bmw, jaguars, etc.