auto fill formulas

B

bl

Is there any option to auto fill cells (say B2:B4) with formulas from cells above (A2:A4), when (immediatelly after) cell B1 is filled? I know it is possible as I saw this kind of action (without using macros or VBE).

Thanks in advance
 
D

Debra Dalgleish

You can use the built-in data form to add records to the table
(Data>Form). Or, turn on the Auto Extend feature (Tools>Options, Edit
tab, 'Extend list formats and formulas), and formulas and formatting
will be copied down as you add rows on the worksheet.

The following MSKB articles explain how Auto Extend works:

XL2000: How Auto Extend List Behavior Works
http://support.microsoft.com/?id=231002

XL2000: Entering Data in List May Not Extend Formats as Expected
http://support.microsoft.com/?id=230584
 
Top