In MS-Excel Suppose in Sheet1 A1,A3, A5,.... contains data. The cells A2,A4,.... are blank. These data are again used in ColC of Sheet2 by means of a formula. However, in Sheet2 no row is to be left blank. Thus, cell C1 of Sheet2 refers to cell A1 of Sheet1, cell C2 of Sheet2 refers to cell A3 of Sheet1, cell C3 of Sheet2 refers to cell A5 of Sheet1, and so on. So, how to copy the formula of C1Sheet2! to its succesive rows i.e., to C2Sheet2!, C3Sheet2!,... so that the row reference of sheet1 jumps by one row every time.