What do you mean by manual deletion? You could just write a macro to delete every row with no data, it shouldn't take that long to process. I personally haven't heard of the Hidemark property until seeing this post.