SOLVED

mass delete of alternate rows in spreadsheet

%3CLINGO-SUB%20id%3D%22lingo-sub-1510779%22%20slang%3D%22en-US%22%3Emass%20delete%20of%20alternate%20rows%20in%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1510779%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20have%20copy%20rows%20of%20data%20and%20how%20to%20mass%20delete%20of%20alternate%20rows%20that%20is%20blank.%26nbsp%3B%20I%20selected%20the%20range%20of%20data%2C%20go%20to%20%22data%20%2C%20filter%20but%20I%20do%20not%20know%20what%20criteria%20to%20be%20input%20to%20filter%20out%20the%20blank%20rows%20%3F%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1510779%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1510920%22%20slang%3D%22en-US%22%3ERe%3A%20mass%20delete%20of%20alternate%20rows%20in%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1510920%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F723113%22%20target%3D%22_blank%22%3E%40softlan3699%3C%2FA%3E%26nbsp%3BOnce%20you%20have%20the%20filter%20on%2C%20you%20should%20see%20a%20small%20downward%20pointing%20triangle%20in%20the%20column%20header.%20Press%20it%20and%20deselect%20(Blanks).%20See%20example%20in%20the%20picture%20below.%20Copy%2FPaste%20to%20another%20location.%20However%2C%20if%20this%20is%20a%20large%20data%20file%20and%20you%20have%20to%20do%20this%20often%2C%20there%20are%20better%20ways%20to%20do%20this.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202020-07-09%20at%2009.13.54.png%22%20style%3D%22width%3A%20271px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F204306i697DC8AE6DD4B00E%2Fimage-dimensions%2F271x190%3Fv%3D1.0%22%20width%3D%22271%22%20height%3D%22190%22%20title%3D%22Screenshot%202020-07-09%20at%2009.13.54.png%22%20alt%3D%22Screenshot%202020-07-09%20at%2009.13.54.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1510963%22%20slang%3D%22en-US%22%3ERe%3A%20mass%20delete%20of%20alternate%20rows%20in%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1510963%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3EThanks%20for%20the%20tips.%26nbsp%3B%20It%20really%20helps%20me.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi, I have copy rows of data and how to mass delete of alternate rows that is blank.  I selected the range of data, go to "data , filter but I do not know what criteria to be input to filter out the blank rows ?? 

2 Replies
Highlighted
Best Response confirmed by softlan3699 (New Contributor)
Solution

@softlan3699 Once you have the filter on, you should see a small downward pointing triangle in the column header. Press it and deselect (Blanks). See example in the picture below. Copy/Paste to another location. However, if this is a large data file and you have to do this often, there are better ways to do this. 

Screenshot 2020-07-09 at 09.13.54.png

Highlighted

@Riny_van_Eekelen ,

Thanks for the tips.  It really helps me.