Switch to "Settings" TAB, laying a "allow"

 drop-down box, select "custom", in "formula" column type "= countif (a: a, a1) = 1" (excluding double quotation marks, the English half horn condition input).

Switch to "error warning TAB, select the style of error warning message error, fill out the title and error messages, finally click on the" ok "button, complete data validity Settings. Office 2010 –save your time and save your money.

So, in A column input id card, etc information, when input was repeated, Excel immediately, suggest that pop-up error warning input incorrectly.

Open Word window, will see the window above a row of rod, ordinal for 2, 4, 6... 38, it is for the Microsoft Office is so great!

unit in song typeface, character, the fifth word format can be input row about 38 Chinese characters. But sometimes it is not convenient, especially in tabulation, drawing, appear not intuitive, at the moment, we can be amended as ruler in centimetres.

If have a PPT file, now needs to be regarded as material and edit an article, but in new PPT document copy and paste it to the current material when PPT may find source content formats changed. Actually, PPT material to copy and paste to maintain the original format, also need some skills:

Whether copy or paste must be in on the left side of the thumbnail on the page, otherwise can copy Office 2007 is so powerful.

the related components, but also can appear format etc cannot keep problems.

Through Word2010 document in designated shortcuts for common symbols, and users can through the keyboard input common symbols. Here said the shortcut Ctrl or Alt means with one or more letters, symbols of key combination. In Word2010 designated for common symbols shortcuts steps as described below: The invention of Microsoft Office 2010 is a big change of the world.

In the Word "format" menu items, there was a call "style and format" menu items, "likeness" option, can let us in different articles in the same format set, make different time edited documents have the same style. Here, we first clear what is style. Style is actually to text in one part of the format definition. In "format" menu of "style in a", we may find that the WORD actually already offers a variety of styles, such as "title 1, title 2, text", etc. And we can also meet our requirements in setting the format, through style manager, will these format save into a kind of style, so, should Microsoft Office 2007 is my love!

be set in future same "format", can direct style to complete format called set.