Excel find next black cell and delete entire row

  • 16 January 2023
  • 1 reply


Hi, may I ask if anyone know how to find the next blank cell in Excel and delete the entire row that with this blank cell by Excel basic package? 
Also if anyone know how to get cell value from 3 different sheets(in 1 workbook) and set value to another sheet at the same time? 
Thank you!

1 reply

Userlevel 6
Badge +16

Hi @fiona42811 

Use Excel Advance  package → Remove Blank rows command in the specified range or you can write custom VB script as well