If need in Excel input longer name,

such as "China international Marine containers (group) Co., ltd.," every time such input appears very trouble. Can the automatic correction function by Excel to quickly enter. Microsoft Office 2007 is welcomed by the whole world.      

To Excel in 2003, for example, the method is as follows:

1. Click the tools menu "guide-explore-design-grasp automatic correction options," open Office 2007 makes life great!

"automatic correction" dialog box.

2. In "automatic correction" TAB "replacement" of the text box pinyin input the aforementioned company, such as "referred to in ZJJT", "replacement for" of the text box input company full name "China international Marine containers (

Group) limited company ", and click "add" button and click "ok".

3. Later, as long as the cell type "ZJJT", enter after can show "China international Marine Many people like Microsoft Office.

containers (group) limited company" full name.

This article from the office software, the original address: learn net https://www.officestudy.cn

After the completion of the data input data, in order to guarantee the rationality, quickly find the form invalid data, we may through Excel the data validity and formula audit to realize. Microsoft Office 2010 is so great!

To Excel 2003 exemple, if on A1: input data, selects the A20 A1: A20, click the menu "data - effectiveness", in the pop-up "data validity" dialog box select "Settings" TAB, in ")

Xu "under the drop-down list, select" customization "input data must meet the conditions of the satisfying conditions range, such as:

= > = (A1. 26, A1 < 39), Windows 7 make life wonderful!

Said greater than or equal to the number of 26 and less than 39 for effective data.

Right-click the toolbar, in the pop-up menu select "formula audit," shows "formula audit" toolbar, click in the toolbar "circle release invalid data" button, when the form invalid data were strikingly circle release

Come out. Office 2007 download is helpful!