Cutting Rows within a filtered search

New Contributor

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 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

@LilTurtle 

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.