Office 2010 document editing, you need to use information from other documents, thisneed to switch the document window. In order to more easily switch document, you canadd a button to switch documentation. Specific steps are as follows:
(1) Right-click the "view" tab window "option group" Switch Window "command.
(2) the "switching window" pop-up menu select "Add to Quick Access Toolbar" command.
(3) After the completion of the quick access toolbar, a "switch window" button. Can quickly switch between documents by clicking the button.
In the status bar to find the "treasure"
The previous version of Word status bar does not have a "word count" an Office Standard 2010Word, the the. Can be seen through the document word count. Similarly, we can try to check the status bar of the other options, try to find more useful information. Specific steps are as follows:
(1) Right-click the status bar, the pop-up "Customize Status Bar shortcut menu, click the" word count "command.
Quickly enter uppercase Chinese digital
Special departments, such as financial workers with numbers, often need to enter theChinese digital input uppercase figures more frequently, I would like to use the fast inputmethod of Chinese figures. Specific steps are as follows:
(1) mouse click "Insert" tab "symbol" option group "No" command.
(2) Enter the desired number "dialog box open," No. "Arabic numerals in the" NumberType "box, select the uppercase Chinese figures. Click "OK" button.
2012年3月31日星期六
2012年3月6日星期二
The AREAS Function
You can use the AREAS function to determine the number of areas in a reference. Areas refer to individual cell or range references, not regions. The single argument to this function can be a cell reference, a range reference, or several range references. If you use several range ref-erences, you must enclose them in a set of parentheses so that Microsoft Office 2010 Excel doesn’t misinterpret the commas that separate the ranges. (Although this function takes only one argument, Excel still interprets unenclosed commas as argument separators.) For example, suppose you assign the name Test to the group of ranges A1:C5,D6,E7:G10. The function =AREAS(Test) returns the number 3, the number of areas in the group.
The TRANSPOSE Function
The TRANSPOSE function changes the horizontal or vertical orientation of an array. It takes a single argument, array. If the argument refers to a vertically oriented range, the resulting array is horizontal. If the range is horizontal, the resulting array is vertical. The first row of a horizontal array becomes the first column of the vertical array result, and vice versa. You must type the TRANSPOSE function as an array formula in a range that has the same num-ber of rows and columns as the array argument has columns and rows, respectively.
The TRANSPOSE Function
The TRANSPOSE function changes the horizontal or vertical orientation of an array. It takes a single argument, array. If the argument refers to a vertically oriented range, the resulting array is horizontal. If the range is horizontal, the resulting array is vertical. The first row of a horizontal array becomes the first column of the vertical array result, and vice versa. You must type the TRANSPOSE function as an array formula in a range that has the same num-ber of rows and columns as the array argument has columns and rows, respectively.
订阅:
博文 (Atom)