shouldn't the value be '$1:$2' # or "\$1:\$2" instead of "1:2" ? Also, is $sheet->PageSetup a hashref or an object? I'm wondering if you need to do $sheet->PageSetup->PrintTitleRows('$1:$2'); (or maybe a ->set() method of some kind)?