Cutting Rows within a filtered search

%3CLINGO-SUB%20id%3D%22lingo-sub-2072352%22%20slang%3D%22en-US%22%3ECutting%20Rows%20within%20a%20filtered%20search%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2072352%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20spreadsheet%20with%202000%20items%20in%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20rearrange%20the%20items%20so%20that%20similar%20items%20are%20next%20to%20each%20other.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20do%20a%20filter%20and%20define%20the%20search%20as%20text%2C%20lets%20say%20for%20%22fenders%22%20it%20lists%20all%20the%20items%20I%20am%20looking%20for.%26nbsp%3B%20That%20being%20said%2C%20if%20I%20select%20all%20the%20rows%20and%20columns%20and%20cut%20them%20and%20then%20go%20back%20to%20my%20normal%20list%20to%20past%20them%20where%20I%20want%2C%20All%20other%20items%20get%20deleted.%26nbsp%3B%20I%20must%20be%20doing%20something%20wrong.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2072352%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2072440%22%20slang%3D%22en-US%22%3ERe%3A%20Cutting%20Rows%20within%20a%20filtered%20search%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2072440%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F933726%22%20target%3D%22_blank%22%3E%40LilTurtle%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20cut%20such%20selection%20it%20cuts%20both%20filtered%20and%20not%20filtered%20cells%2C%20other%20words%20entire%20range.%20Cuts%20also%20doesn't%20if%20GoTo%20Special-%26gt%3Bselect%20visible%20cells%20only%20since%20it%20doesn't%20work%20on%26nbsp%3B%3CSPAN%3Enoncontiguous%20range.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EYou%20may%20copy%2Fpaste%20one%20range%20by%20another%20to%20other%20location.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
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.