Do actually delete a line you would need to use VBA there is no excel formula that can invoke the delete command.