Office software is closely linked to the PDF,the PDF is also must have to control!
Set home Page Add to Favorites
|
Third, the automatic switching input method In the input data, a worksheet contains both Chinese characters and English letters and numbers, then for different cells, continued to switch input is also artificially increase the input of the input workload. For about as long as the pre-processing, Excel will be able to make different types of cells to achieve the automatic input switching. Start Excel 2000, a new workbook, named "2002.xls", right-click the worksheet tab "Sheet1", choose "rename", renamed the "Student Registration Form." Zhang frequently used first "smart bridge input method Chen," Chinese character input method as default: Click the bottom right corner of the "En" icon, select "Properties" dialog box that appears, select the Language tab of the "smart Chen bridge input platform ", click [set default] and confirmed. Design input by the above-mentioned header content, and then select "Name", "gender" the need to input Chinese characters, such as those listed in the menu, select "Data input method ¡ú ¡ú effectiveness model" tab in the "model" under the pull list box, select "Open", click [OK] button. Then select other out, ibid steps, out of "input mode" tab in the "model" drop-down list box select "Close (English model)", click [OK] button. After dealing with such a simple after the entry process, when the insertion point in a different cell, Excel 2000 can be set in accordance with our Chinese and English automatically to switch between input methods, eliminates the need to switch back and forth in both English and Chinese to the trouble of . IV pretreatment variable length data Student home address for this column, how to set the column width it? Is too wide will cause a scroll around the table too inconvenient, too afraid of the students in case the address of which long was it not the right to block out? It does not matter, there are two bills are specialized to deal with this situation: The first one, in the "home address" listed above the click, select the entire column, select the menu "Format ¡ú Cells ¡ú Alignment", in the "Text control" selected under the "Shrink to Fit" check box, click [OK] button to adjust the column to the right column width. So, if you have the address of a student more than the width of the cell, Excel can automatically reduce the size of characters in the data set adjusted to the same column width, so that all the data displayed in the cell. Even after these cells had to change the column width, in which the characters can also be good to automatically increase or reduce the number to the cell to adapt to the new column width. The second measure, select the "home address" is as follows, check the Figure 2 the "Word Wrap" check box, Excel will the basis of the width and the length of the text wrap automatically, so you do not have eyes the small print to put up with those! five, so that EXCEL also "AutoNumber" As we all know, EXCEL automatic filling is that it features one of the major. Use it to carry out the serial number of the "automatic preparation of" tailor-made it as easy as it is. General methods are automatically filled with the left mouse button to fill handle, hold down the mouse and drag down the completion of the (fill handle is located in selected regions of the small black block corner will be filled to handle the mouse, the mouse changes the shape of black cross. drag the fill handle to copy the content to the adjacent cell, or to fill the date of series). If there are too many forms of the line, this method inconvenient distance from the master drag. I find here a more simple method of operation: with the left mouse button double-click the fill handle. All OK! Note: sometimes do not achieve the desired effect of filling. Also must meet the following conditions: 1, filled not only vertical horizontal fill. 2, To fill the left column (right), out of adjacent non-empty, and the middle without interruption, otherwise the above will be filled with intermittent stops. 3, the method of the sequence of the text also play a role. $Show_page$ six, automatic positioning decimal places Because there are a large number of 123.5, such as student achievement, such as the need for entry, if carried out before admission to the following settings will allow you to increase the input speed doubled (you can do not need to enter the decimal point). Click the "Tools" ¡ú "Options" ¡ú "Editor" tab, select the "decimal point is automatically set" check box, and in the "median" type needs to fine-tune the edit box to the right of the decimal point is displayed in the median. Here, we type "1." Click "OK" button. Now, in a worksheet cell, type "1235", then you press the enter key, the number of cells automatically become "123.5." Much more convenient for you! At this point if you type in the cell is "89", then in the end you enter, the number of cells automatically changed to "89.0." In addition, if you are in the "median" box, enter a negative number, such as "-1", then Excel will automatically enter the number of add two "0." If you want to temporarily suspend the "decimal point is automatically set" function to set the option, you can enter data in decimal own. Use Excel's "automatically set the decimal point" function, for a large number with a fixed number of decimal places, or with a fixed digit to "0" string at the end of the digital input, will greatly enhance the speed of editing. seven, so that personalized forms In order to improve efficiency, the more energy the more dry and at the same time a good time in order to avoid post-entry errors. Select the entire worksheet, click the Format menu under "AutoFormat ... ...", the "AutoFormat" dialog box, select a comparison of the programs you like, click [Options] button to start the dialog box the lower part of the "type of application format" option box, in order to maintain in front of a lot of settings, we must remove the "digital", "align", "border" and other options before the resumption of choice, check only "character" and "pattern "Two, [OK] to complete the set. [Hint: in the table, to the unit different color and shading can enhance the data input when the intuitive feeling, but when printing in black-and-white color and shading are not even playing out of form on the reduced visibility , so the user wants in the data processing colorful print in black and white is still common. In the "File" menu, select "Page Setup ¡ú Sheet ¡ú cell ¡ú monochrome printing Print", then print the forms is a common form of black and white. ] Everything is ready, the following entry could be the beginning of the. |
