next up previous contents
Next: Clear Up: Edit Previous: Paste

Fill...

Fill is very useful for entering data multiple times. Its use is simple; select the region you wish to fill and then choose Fill from the Edit menu. The Fill dialog will pop up.

../images/fill.jpg

If you are entering a formula, you can enter the formula once, and have it referenced correctly in all the selected cells. For example, to get A2+B2+C2 in D2 and A3+B3+C3 in D3 select cells D2 and D3. Select Fill from the menu, then in the dialog enter =SUM(A2:C2). The value of D2 will be =SUM(A2:C2) and the value of D3 will be =SUM(A3:C3). This is only a very limited example of the applications of Fill. Larger ranges may be filled with more complex formulas as well.
next up previous contents
Next: Clear Up: Edit Previous: Paste
Daniel Medina
2000-12-10