Excel 2010 formulas easier to write new features

Office 2010 asked the city has a long time, but I found a lot of friends around still usingOffice 2007, after asking some people that page has changed so much because of Office 2010, can not find a good multi-functional place, leading to their ultimate more busy messgive up the use. There are some people simply do not understand is that Office 2007'snew features, without realizing that these new features for their work to bring the convenience.

Today we introduce you first write the formula manipulation Office Excel 2010 new features more easily.

1 adjustable bar

Bar will automatically adjust to accommodate long, complex formulas, which prevents the formulas from covering other data in the worksheet. And compared to the earlier versions of Excel, you can write formulas longer, use more levels of nesting.

(2) AutoComplete function

Use AutoComplete function, you can quickly write the proper formula syntax. It not only caneasily detect the function you want to use, you can also get help to complete the formulaparameters, so that when you first use and future use of each access to the correctformula.

3 structured references

In addition to cell references (such as A1 and R1C1), Office Excel 2010 also provides aformula reference named ranges and tables in a structured reference.

4 Easy access to named ranges

By using the Microsoft office 2010 download name manager, in a central location to organize, update, and manage multiple named ranges, which helps no need to use your worksheet interpret its formulas and data.

These features are not that simple and practical it, at a later time we will be graduallyintroduced in Office 2010 for our work to bring more convenience features. Whileeveryone has more or less the lack of Office 2010, but why not try to do new things, therewill only continue to try to keep the innovation!