Demo: Create formulas with Formula AutoComplete

Formula building on worksheet Play Demo Demo button

Or Down arrow download the demo.

(You may experience a delay while the demo is loading.)

The Formula AutoComplete feature in Office Excel 2007 helps you avoid gotchas — those little syntax or typing mistakes that can break your formula and display an error in the cell. Every step of the way, Formula AutoComplete guides you with ScreenTips that show you how to build your formula. The ScreenTips also point you to Help articles for more information about the functions you're using. And you can save time by using defined names in Formula AutoComplete. Watch the demo and then try it yourself.

How to do it (text version):

Help Button Problems watching the video? Try our troubleshooting tips.

Applies To: Excel 2007

Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language