Remove Blank Rows

Functioning: Deletes Blank/Empty rows from selected cells

Case Study: We need to remove empty rows (refer screen-cliping below) from Expense Schedule (as it doesn't look good when printed)

Normal Method:

  1. Select these rows
  2. Home > Editing > Find & Select > Go To Special
  3. Select Blanks option
  4. Home > Cells > Delete > Delete Sheet Rows

Excel BI Method:

screenshot blank row remover