Each cell in a worksheet has a unique reference that describes its position – for example A1. In a spreadsheet, there are two types of cell reference – 'relative cell reference' and 'absolute ...

and set up your column headers (in cells A1, B1, and C1) In cell A2 of Sheet 2, enter the formula to reference the first row of data from Sheet 1: Now select cells A2, B2, and C2, and drag the ...