2 Quick Tips: Merge Total Rows Quickly & Add a Blank Row After Each Subtotal Row in Excel Steps: Apply Filters on Columns, Select Blanks, Select Visible Cells Only, Merge and Center & Clear Filters. Add Helper Column, Apply Filters on Columns, Select Blanks, Select Helper Column Visible Cells Only, Input 1 and Press CTRL ENTER, Clear Filter. Select Blank Cell in Helper Column, Go to Home Tab, Insert, Insert Cells, Shift Cells Down, Again Apply Filter and Select Helper Column, Select Visible Cell