View Single Post
  #2   Report Post  
Dave O
 
Posts: n/a
Default Formatting Spreadsheet

One way:
~Insert a new column and number each cell in that column, 1 thru X.
~Insert a new column next to that with the formula =MOD(cell
reference,2) that references each numbered cell. This will result in 1
or 0 for each cell.
~Sort all rows on the 1/0 column. Shade either the 1 section or the 0
section.
~Sort all rows again on the numbered column 1 thru X.