If they are sorted, you can use the Data-Subtotals command. It won't put in
a blank line though - it'll add a new line with a formula

"Holly" wrote:

My file has over 1000 lines by sku & customr, I need to add line between each
sku group. This is a data file, I don't want to pivot table to add line,
instead of manually add line between each sku, does excel have a formular to
add line?