Question

How to read data in alternate rows in excel?

Answer 1

$follow \: setup \: by \: setup \: and \: try$

•Choose a blank cell in the same row but adjacent to the column you want to sort.

•Type in =MOD(ROW(2)

•If you're using Excel type =MOD(ROW(2)

•Fill this formula to the bottom.

•Now you can either...

•To apply a background color to alternate rows, go to conditional formatting.

•Choose Formula is then =MOD(ROW(2)but again replace the with a if you're using Excel.

•Choose a color.

•Click ok and enjoy