Automatically refer to a formula

**stanleyyeh** · 09-30-2012, 09:57 PM

A1=2, B1=3, C1=A1+B1
A2=3, B2=3, C2=A2+B2

Besides autofill by double-clicking on C1, what should I do so as soon as I change C1 to "A1*B1", C2 would be automatically changed to "A2*B2"?

**protonLeah** · 09-30-2012, 10:01 PM

You still have to double click the cross at the bottom right corner of C1

**stanleyyeh** · 09-30-2012, 10:05 PM

Originally Posted by protonLeah

You still have to double click the cross at the bottom right corner of C1

Thanks. I was wondering if there's something more advanced than autofill.

**TMS** · 09-30-2012, 10:21 PM

You could convert the data to a table but you'd need column headers for that. Then, when you change a formula, it will automatically change in all the other cells in that column.

Regards, TMS

**stanleyyeh** · 09-30-2012, 10:40 PM

Originally Posted by TMShucks

You could convert the data to a table but you'd need column headers for that. Then, when you change a formula, it will automatically change in all the other cells in that column.

Regards, TMS

Thanks. It works just perfectly.

**TMS** · 10-01-2012, 02:20 AM

You're welcome. Thanks for the rep.

If you want to know more about tables, you can Google it or have a look at this comprehensive explanation:

http://www.jkp-ads.com/articles/Excel2007tables.asp

Regards, TMS

**stanleyyeh** · 10-01-2012, 03:12 AM

Originally Posted by TMShucks

You're welcome. Thanks for the rep.

If you want to know more about tables, you can Google it or have a look at this comprehensive explanation:

http://www.jkp-ads.com/articles/Excel2007tables.asp

Regards, TMS

Thanks. I saw the trick you taught me was mentioned, "a nice feature is that formula is automatically copied down"

**TMS** · 10-01-2012, 03:24 AM

I'm not sure what trick you mean. I think that having consistent formulae in the columns of a table is part of the functionality of a table. Suggest you have a Google around for more information.

Regards, TMS