How to replicate formulae down the spread sheet
Answers
*Select the first cell in the target range.
*Type = INDEX
*Using the mouse highlight the score range. *Press F4 and add Dollar sign to the score range reference.
*Type the comma and then column(A1) then after closing parenthesis.
*Simple press enter.
Here is yours answer....
The easiest approach to copy down formulas is to use the fill handle in Google Sheets. Write your formula in the first row of your spreadsheet, and then point your mouse to the lower right corner of the formula cell.
fill-down-sheet-formula.gif
The pointer changes into a fill handle (black plus symbol) that you can drag to the last row of the sheet. The fill handle will not just copy down the formulas to all the adjacent cells but also copies the visual formatting.
If you need to copy the formulas across cells but sans any formatting, select the cell that contains the formatting and press Ctrl+C to copy it to the clipboard. Next select the range where that formula needs to applied, right-click, choose Paste Special and Paste Formula only.
Hope it helps you....
I knew i am late......
Plz! make me as brainliest...