You don't mention a version so I will only cover 5.x and 6.x which differ in that statistics on rows are reported in the same worksheet in 5.x and a new worksheet in 6.x. Highlight the columns you want included in the calculation and then run this script:
if(system.version<6.0211) {
run.section(WKS,StatRow);
wo -a 1;
wks.col$(wks.ncols).name$=max;
copy _max %H_max;
delete %H_mean;
delete %H_sd;
delete %H_se;
} else {
%M=%H;
run.section(WKS,StatRow);
%N=%H;
win -a %M;
wo -a 1;
wks.col$(wks.ncols).name$=max;
copy %N_max %M_max;
win -c %N;
};
