Forum Discussion
Cutting Rows within a filtered search
Hello, I have a spreadsheet with 2000 items in it. I need to rearrange the items so that similar items are next to each other. When I do a filter and define the search as text, lets say f...
If you cut such selection it cuts both filtered and not filtered cells, other words entire range. Cuts also doesn't if GoTo Special->select visible cells only since it doesn't work on noncontiguous range.
You may copy/paste one range by another to other location.