row placement & alternating highlighting
1) conditional formatting:
Formula Is
=MOD(ROW();2)=0
and select grey interior, then copy and paste special as formats
this will not color the whole rows, only specific cells
2) select a cell somwehere in 2nd row and go to Window-Freeze Panes
|