Why do I need to re-learn where to find the same things, without any add-on. I hate workarounds, especially if it worked with older products.īy the way, the ribbon menu change in 2007 is also totally ridiculous. But this comes close to doing everything manually as well, so garbage. Now way to get this right except my sorting things around. What excel does, is just pasting my selection continously, therby also populating the hidden row. Pasting into a new sheet is fine.īut I did in previous versions was to copy a block onto a filtered range. So I managed to get the copy thing selecting the visible range only. With this bug, it made excel useless for me. I am glad to hear that I am not the only one with this problem. My advice is to select the entire range and then apply the autofilter. The way it works entirely relies on which cells you have selected before you apply the filter. This behavior is different from Excel 2000, 2002/XP and 2003. If I select the entire data-range or a single cell in it and then apply the filter it works as expected. If I have my data, select the header row and then apply the filter, the filtering works but it copies all the data. I can reproduce the bug in a certain situation. When you now copy, only the visible result of your filter will be copied and pasted. Make your selection, then press F5 (go to.) then click on the "Special." button and choose "Visible cells only". After you've done this is works just as in the previous Excel versions. Select the cells and then in the Excel menu choose: If you convert your table to a 'table' it works as you would expect. If it doesn't work, here are some workarounds: If the double-lines don't show, the hidden rows are copied too: You can recognize when it is going to work correctly by double, moving striped-lines: This is different from the way Excel 2000-2003 works. 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. I just got an email that says you cannot copy only the filtered data in Excel 2007.
0 kommentar(er)
