auto fill formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to have cells automatically fill when entering value in ref 2
Copy & paste 1
Relative column referencing within formulas 4
Auto Fill Cell Based on Data in a different cell 4
"$" command will not work in VISTA 4
Auto Fill with some references locked 3
Extend Formula 1
find blank cell and replace with " ' " 2

Back
Top