Auto fill after inserting row without using the fill handle

Is there anyway to automatically fill the empty added cell after inserting a row without using the fill handle?
For example, for a series of numbers:
http://office.microsoft.com/en-001/e...001154232.aspx

2. Drag the fill handle Selected cell with fill handle across the range that you want to fill.

Or running balance:
http://office.microsoft.com/en-001/e...003069811.aspx

2. Extend the running balance formula into the new rows by selecting the last cell in the balance column and then double-clicking the fill handle.

In 2003, there is an option to extend formatting and formulas within lists or tables. I forget the exact path to it and its wording, and no longer have 2003 to check it. So poke around a bit...

If you are working within a table, when you add a row, the formulae and formatting of the row above it copied down to the active row.

If you are not working in a table, you could try with the active cell being the one that you want to copy, left click in the cell, hold and drag down the column or along the row (depending upon your needs) then use Ctrl + D to fill down.

Another method is to click in the cell that you want to copy then in then Name Box (to the left of the formula bar) you will see the current cell address.
Click in the Name box, the cell address will become selected, click again and the cursor will blink beside the cell reference. Enter a : and the cell at the end of the range that you want to fill. Hit enter then Ctrl + D

To do that, you would need a formula in each cell to be filled that references the source cell. If the value was to be entered in B1 then down column B enter this formula from B2 to as far as you need. When you enter something in B1 it will fill all the cells with the same value if it has the formula.

Formula:

Please Login or Register  to view this content.

This is a direct quote from the help file that you cited. There is nothing "automatic" about the process.

"2.Extend the running balance formula into the new rows by selecting the last cell in the balance column and then double-clicking the fill handle."

A table will fill the rows automatically with the formatting and formulae from the preceding row. If you insert a row between existing rows of the table will mess up the formulae in the rows that follow because the inserted row doesn't update the existing formulae. Nowhere in the help file example does it indicate that inserting rows between existing rows will keep the formulae intact. The formulae will only remain intact if you are adding data to the bottom of the table.