my $fmt_hdr = $workbook->add_format( border=>1, color=>'blue' ); my $fmt_cell = $workbook->add_format( border=>1, color=>'black' ); . . . $worksheet->write($row, $col, "HDR", $fmt_hdr); $worksheet->write($row+1, $col, "value", $fmt_cell);