Delete Blank Rows Excel

This bot will remove all the blank rows in the wrong place. there's an easy way to remove blank rows from a data range, but this easy technique.

Top Benefits

  • Speed up the work with Excel Sheets
  • Easy to report in the Log file
  • Manageable code with the help of the Config file
  • Handle most of the code from config file


  • Excel Macro will do this task for you
  • Can send multiple excel sheet to remove all the blank rows from the sheet
  • Mail will be sent after task finished

Blank rows aren't bad, but in most sheets, they're definitely undesirable. Excel uses blanks to determine data ranges, and a blank row in the wrong place will inhibit many built-in features. Fortunately, there's an easy way to remove blank rows from a data range, but this easy technique has the potential to destroy data, so you must be careful. This bot will do this for you.

Buy Now

$90 USD per bot
Annual Subscription

Free 30-Day Trial

Request quote for more purchase options

Bot Security Program
Level 1
Business Process
Automation Type
Last Updated
July 24, 2020
First Published
April 13, 2020
Enterprise Version

Setup Process


Download the Bot and follow the instructions to install it in your AAE Control Room.


Open the Bot to configure your username and other settings the Bot will need (see the Installation Guide or ReadMe for details.)


That's it - now the Bot is ready to get going!

Requirements and Inputs

  • Input Folder
  • Config Folder
  • Macro should be placed in Input folder
  • Config file should be placed in Config folder.