+ 0 Votes Who needs the help feature anyway? ... Sven2157 May 25, 2013 at 6:32pm PST ... Click in the cell you want( M4 ), then type '=A1' in the text bar, hit enter. Click back in M4, and a black box will appear around the cell. In the bottom right corner there will be a little black square, drag that square down the 'M' column, until it matches your 'A' column. + 1 Votes Designed to work that way Mehul Bhai May 27, 2013 at 5:40pm PST As per what you say I believe it is working as per design. If you want any other way than you have to enter individual fields/cells individually.