Next: Clear
Up: Edit
Previous: Paste
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.
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: Clear
Up: Edit
Previous: Paste
Daniel Medina
2000-12-10