Cutting Rows within a filtered search

New Contributor



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 for "fenders" it lists all the items I am looking for.  That being said, if I select all the rows and columns and cut them and then go back to my normal list to past them where I want, All other items get deleted.  I must be doing something wrong.

1 Reply


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.