IplugIn tag 8192 winamp PplugIn tag 8192 winamp Fill Down NplugIn tag 8192 winamp

Often we have several cells that need the same formula (in relationship) to the location it is to be typed into. There is a short cut that is called Fill Down. There are a number of ways to perform this operation. One of the ways is to

  1. select the cell that has the original formula
  2. hold the shift key down and click on the last cell (in the series that needs the formula)
  3. under the edit menu go down to fill and over to down
ABC
153=A1+B1
282 fill down
346fill down
438fill down
 Cells information is copied from its relative position. In other words in the original cell (C1) the equation was (A1+B1). When we paste the function it will look to the two cells to the left. So the equation pasted into (C2) would be (A2+B2). And the equation pasted into (C3) would be (A3+B3). And the equation pasted into (C4) would be(A4+B4).

IplugIn tag 8192 winamp PplugIn tag 8192 winamp Fill Down NplugIn tag 8192 winamp

790795

Choose:   TRIO homeplugIn tag 8192 winamp   I   tutorialsplugIn tag 8192 winamp   I   by Brad JamesplugIn tag 8192 winamp   I   bwjames@usd.eduplugIn tag 8192 winamp