Deleting Blank Rows in Word

Replace > Special > All White Space First Step Find ^p (with one space after it) and replace it with ^p (no spaces) also try it with 2 or 3 or 4 spaces etc, replacing with no spaces Repeat all until you get a zero Second Step Find ^p^p Replace with ^p Repeat until you … Continue reading Deleting Blank Rows in Word

Advertisements

Deleting Blank Rows in Excel

Select the Column with the rows you want to delete Press F5 Click "Special..." Select "Blanks" Click "OK" Then click on "Delete Cells...'